Operation Details
Description: Reads the tree status for the specified evidence link identifier.
Sterotype: ns
SQL 
SELECT
  CaseEvidenceTree.statusCode
INTO
  :statusCode 
FROM
  CaseEvidenceTree,
  CaseEvidenceGroup,
  CaseEvidenceGroupLink 
WHERE CaseEvidenceGroupLink.caseEvidenceGroupLinkID = :caseEvidenceGroupLinkID 
  AND CaseEvidenceGroup.caseEvidenceGroupID = CaseEvidenceGroupLink.caseEvidenceGroupID 
  AND CaseEvidenceTree.caseEvidenceTreeID = CaseEvidenceGroup.caseEvidenceTreeID