Database SQL Operation: CoCEvidenceLink.countUnevaluatedByCaseID
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 |
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
|