Operation Details
Description: Returns a count of CoCEvidenceLink records for the specified case and for the evidence which is in a state of unevaluated. Evidence can attain this state when verifications have been deferred and in edit evidence is added to the case and not activated due to evidence validation failures.
Sterotype: ns
SQL
SELECT 
  count(*) 
INTO 
 :numberOfRecords
FROM 
  CoCEvidenceLink,
  EvidenceDescriptor,
  CurrentPostponedVerification
WHERE 
  EvidenceDescriptor.caseID = :caseID AND
  CoCEvidenceLink.evidenceDescriptorID = EvidenceDescriptor.evidenceDescriptorID AND
  CurrentPostponedVerification.caseID = :caseID AND
  EvidenceDescriptor.evidenceDescriptorID = CurrentPostponedVerification.evidenceDescriptorID