Operation Details
Description: Method to get all possible evidence types for a given case.
Sterotype: nsmulti
SQL 
SELECT
  EvidenceMetadata.evidenceType
INTO
  :evidenceType 
FROM
  CaseHeader,
  EvidenceMetadata,
  ProductDelivery,
  ProductEvidenceLink 
WHERE CaseHeader.caseID = :caseID 
  AND CaseHeader.caseID = ProductDelivery.caseID 
  AND ProductDelivery.productID = ProductEvidenceLink.productID 
  AND ProductEvidenceLink.evidenceMetadataID = EvidenceMetadata.evidenceMetadataID 

UNION
  
  ( 
  SELECT
    EvidenceMetadata.evidenceType 
  FROM
    CaseHeader,
    AdminICEvidenceLink,
    EvidenceMetadata,
    AdminIntegratedCase 
  WHERE CaseHeader.caseID = :caseID 
    AND CaseHeader.integratedCaseType = AdminIntegratedCase.integratedCaseType 
    AND AdminIntegratedCase.adminIntegratedCaseID = AdminICEvidenceLink.adminIntegratedCaseID 
    AND AdminICEvidenceLink.evidenceMetadataID = EvidenceMetadata.evidenceMetadataID 
  )