Operation Details |
Description: | Method to count any occurrence of the evidence type for a particular Evidence Tree ID. |
Sterotype: | ns |
SQL |
SELECT COUNT(*) INTO :recordCount FROM ISPEvidenceTypeStatus WHERE ISPEvidenceTypeStatus.caseEvidenceTreeID = :caseEvidenceTreeID AND ISPEvidenceTypeStatus.caseEvidenceTypeCode = :caseEvidenceTypeCode |