Database SQL Operation: AdminICEvidenceTypeDefLink.countAdminICEvidenceTypeLinks
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 |
SELECT
count(*)
INTO
:counter
FROM
AdminICEvidenceTypeDefLink
WHERE
AdminICEvidenceTypeDefLink.evidenceTypeDefID = :evidenceTypeDefID
AND AdminICEvidenceTypeDefLink.adminIntegratedCaseID = :adminIntegratedCaseID
|