Operation Details
Description: Searches for links on an evidence tree based on caseEvidenceTreeID and evidenceType.
Sterotype: nsmulti
SQL 
SELECT
  CaseEvidenceGroupLink.caseEvidenceGroupLinkID,
  CaseEvidenceGroupLink.caseEvidenceGroupID,
  CaseEvidenceGroupLink.relatedID,
  CaseEvidenceGroupLink.evidenceType,
  CaseEvidenceGroupLink.isEditableInTreeInd,
  CaseEvidenceGroupLink.evidenceTypeInstanceID,
  CaseEvidenceGroupLink.versionNo
INTO
  :caseEvidenceGroupLinkID,
  :caseEvidenceGroupID,
  :relatedID,
  :evidenceType,
  :isEditableInTreeInd,
  :evidenceTypeInstanceID,
  :versionNo 
FROM
  CaseEvidenceTree,
  CaseEvidenceGroup,
  CaseEvidenceGroupLink 
WHERE CaseEvidenceTree.caseEvidenceTreeID = :caseEvidenceTreeID 
  AND CaseEvidenceGroup.caseEvidenceTreeID = CaseEvidenceTree.caseEvidenceTreeID 
  AND CaseEvidenceGroupLink.caseEvidenceGroupID = CaseEvidenceGroup.caseEvidenceGroupID 
  AND CaseEvidenceGroupLink.evidenceType = :evidenceType