Operation Details
Description: Counts live evidence data records for the specified evidence type and date. These are records added on or after the specified date. Live records are considered the evidence records with status ACTIVE, INEDIT, IDENTICALINEDIT or NONIDENTICALINEDIT
Sterotype: ns
SQL 
SELECT
    count(*)
INTO
    :counter 
FROM
    EvidenceDescriptor
WHERE EvidenceDescriptor.evidenceType = :evidenceTypeCode 
  AND EvidenceDescriptor.receivedDate >= :date
  AND
    (
     EvidenceDescriptor.statusCode = :statusCodeInEdit
     OR EvidenceDescriptor.statusCode = :statusCodeInActive
     OR EvidenceDescriptor.statusCode = :statusCodeIdenticalInEdit
     OR EvidenceDescriptor.statusCode = :statusCodeNonIdenticalInEdit
    )