Operation Details
Description: Returns a count of CoCEvidenceLink records for the specified case and evidence status.
Sterotype: ns
SQL 
SELECT 
  count(*) 
INTO 
 :numberOfRecords
FROM 
  CoCEvidenceLink,
  EvidenceDescriptor
WHERE 
  EvidenceDescriptor.caseID = :caseID AND
  CoCEvidenceLink.evidenceDescriptorID = EvidenceDescriptor.evidenceDescriptorID AND
  EvidenceDescriptor.statusCode = :statusCode