Operation Details
Description: Counts the number of live evidence records for an evidence type version. Live records are considered the evidence records with status ACTIVE, INEDIT, IDENTICALINEDIT or NONIDENTICALINEDIT
Sterotype: ns
SQL 
SELECT
    count(*)
INTO
    :counter 
FROM
    DynamicEvidenceData,
    EvidenceDescriptor
WHERE DynamicEvidenceData.evidenceTypeVersionDefID = :evidenceTypeVersionDefID
  AND EvidenceDescriptor.relatedID = DynamicEvidenceData.evidenceID 
  AND
    (
     EvidenceDescriptor.statusCode = :statusCodeInEdit
     OR EvidenceDescriptor.statusCode = :statusCodeInActive
     OR EvidenceDescriptor.statusCode = :statusCodeIdenticalInEdit
     OR EvidenceDescriptor.statusCode = :statusCodeNonIdenticalInEdit
    )