Database SQL Operation: EvidenceRelationship.searchRelatedBusinessObjects
Description: | This method returns a list of the Business Object IDs (successionIDs) related to the supplied successionID |
Sterotype: | nsmulti |
SELECT DISTINCT
EvidenceDescriptor.successionID
INTO
:successionID
FROM
EvidenceRelationship,
EvidenceDescriptor
WHERE
EvidenceRelationship.parentID in (SELECT relatedID from EvidenceDescriptor where successionID = :evidenceSuccessionID AND caseID = :caseID) AND
EvidenceRelationship.childID = EvidenceDescriptor.relatedID AND EvidenceDescriptor.caseID = :caseID
UNION
SELECT
EvidenceDescriptor.successionID
FROM
EvidenceRelationship,
EvidenceDescriptor
WHERE
EvidenceRelationship.childID in (SELECT relatedID from EvidenceDescriptor where successionID = :evidenceSuccessionID AND caseID = :caseID) AND
EvidenceRelationship.parentID = EvidenceDescriptor.relatedID AND EvidenceDescriptor.caseID = :caseID
|