Database SQL Operation: CaseEvidenceGroupLink.readTreeForLink
Description: | Returns the case evidence tree identifier for the specified link. |
Sterotype: | ns |
SELECT
CaseEvidenceTree.caseEvidenceTreeID
INTO
:caseEvidenceTreeID
FROM
CaseEvidenceTree,
CaseEvidenceGroup,
CaseEvidenceGroupLink
WHERE CaseEvidenceGroupLink.caseEvidenceGroupLinkID = :caseEvidenceGroupLinkID
AND CaseEvidenceGroup.caseEvidenceGroupID = CaseEvidenceGroupLink.caseEvidenceGroupID
AND CaseEvidenceTree.caseEvidenceTreeID = CaseEvidenceGroup.caseEvidenceTreeID
|