Operation Details
Description: Searches for all caseEvidenceTree records on a case with a status of Active or InEdit.
Sterotype: nsmulti
SQL 
SELECT
  CaseEvidenceTree.caseEvidenceTreeID,
  CaseEvidenceTree.caseID,
  CaseEvidenceTree.effectiveFrom,
  CaseEvidenceTree.statusCode,
  CaseEvidenceTree.previousEvidenceID,
  CaseEvidenceTree.versionNo
INTO
  :caseEvidenceTreeID,
  :caseID,
  :effectiveFrom,
  :statusCode,
  :previousEvidenceID,
  :versionNo 
FROM
  CaseEvidenceTree 
WHERE CaseEvidenceTree.caseID = :caseID 
  AND 
  (
    CaseEvidenceTree.statusCode = :statusCode 
    OR CaseEvidenceTree.statusCode = :statusCode2 
  ) 
ORDER BY caseID,
  effectiveFrom,
  statusCode