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 |