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