Operation Details
Description: This call returns all the evidence forms which have been filled in for a given case.
Sterotype: nsmulti
SQL 
SELECT
  DISTINCT ProductEvidenceFormLink.evidenceFormID,
  EvidenceForm.evidenceNameCode,
  EvidenceForm.caseEvidenceType,
  ProductEvidenceFormLink.startDate,
  ProductEvidenceFormLink.endDate
INTO
  :evidenceFormID,
  :evidenceNameCode,
  :caseEvidenceType,
  :startDate,
  :endDate 
FROM
  ProductEvidenceFormLink,
  EvidenceForm,
  CaseEvidence,
  CaseEvidenceType 
WHERE CaseEvidence.caseID = :caseID 
  AND CaseEvidence.statusCode = :statusCode 
  AND CaseEvidenceType.evidenceID = CaseEvidence.evidenceID 
  AND EvidenceForm.evidenceNameCode = CaseEvidenceType.evidenceFormName 
  AND EvidenceForm.evidenceFormID = ProductEvidenceFormLink.evidenceFormID 
  AND ProductEvidenceFormLink.productID = :productID 
  AND ProductEvidenceFormLink.recordStatus = :recordStatus