Operation Details
Description: Method to count the number of instances of a case identifier for a particular external case audit data set.
Sterotype: ns
SQL
SELECT count(*)
INTO :numberOfRecords
FROM 
ExternalCaseAuditData ECAD, ExternalCaseAuditDataItem ECADI
WHERE 
ECAD.name = :name
AND ECAD.externalCaseAuditDataID = ECADI.externalCaseAuditDataID
AND ECADI.caseID = :caseID