Operation Details
Description: Reads details of an evidence link by caseEvidenceTreeID, evidenceType and relatedID.
Sterotype: ns
SQL 
SELECT
  CaseEvidenceGroupLink.caseEvidenceGroupLinkID,
  CaseEvidenceGroupLink.caseEvidenceGroupID,
  CaseEvidenceGroupLink.isEditableInTreeInd,
  CaseEvidenceGroupLink.evidenceTypeInstanceID,
  CaseEvidenceGroupLink.versionNo
INTO
  :caseEvidenceGroupLinkID,
  :caseEvidenceGroupID,
  :isEditableInTreeInd,
  :evidenceTypeInstanceID,
  :versionNo 
FROM
  CaseEvidenceGroup,
  CaseEvidenceGroupLink 
WHERE CaseEvidenceGroup.caseEvidenceTreeID = :caseEvidenceTreeID 
  AND CaseEvidenceGroupLink.caseEvidenceGroupID = CaseEvidenceGroup.caseEvidenceGroupID 
  AND CaseEvidenceGroupLink.evidenceType = :evidenceType 
  AND CaseEvidenceGroupLink.relatedID = :relatedID