Operation Details
Description: This method retrieves a list of distinct case IDs which contain evidence marked with the given shared instance ID and have a status code of 'Active', 'In Edit', 'Identical In-Edit', 'Non Identical In-Edit' or 'Non Identical Resolved'.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT caseID
INTO
  :caseID 
FROM
  EvidenceDescriptor 
WHERE sharedInstanceID = :sharedInstanceID 
  AND 
  (
    statusCode = :statusCode1 
    OR statusCode = :statusCode2 
    OR statusCode = :statusCode3 
    OR statusCode = :statusCode4 
    OR statusCode = :statusCode5 
  )