Operation Details
Description: Retrieves a list of Evidence Descriptor details for the specified case and statuses. The list returned is ordered by evidence type and status.
Sterotype: nsmulti
SQL 
SELECT
  evidenceType,
  statusCode
INTO
  :evidenceType,
  :statusCode 
FROM
  EvidenceDescriptor 
WHERE caseID = :caseID 
  AND 
  (
    statusCode = :statusCode1 
    OR statusCode = :statusCode2 
  ) 
ORDER BY evidenceType,
  statusCode