Database SQL Operation: EvidenceRelationship.searchRelatedBusinessObjectsOfTypeExcludingStatus
| 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 = :successionID AND caseID = :caseID) AND
EvidenceRelationship.childID = EvidenceDescriptor.relatedID AND EvidenceDescriptor.evidenceType = :evidenceType AND EvidenceDescriptor.statusCode <> :excludedStatusCode AND EvidenceDescriptor.caseID = :caseID
UNION
SELECT
EvidenceDescriptor.successionID
FROM
EvidenceRelationship,
EvidenceDescriptor
WHERE
EvidenceRelationship.childID in (SELECT relatedID from EvidenceDescriptor where successionID = :successionID AND caseID = :caseID) AND
EvidenceRelationship.parentID = EvidenceDescriptor.relatedID AND EvidenceDescriptor.evidenceType = :evidenceType AND EvidenceDescriptor.statusCode <> :excludedStatusCode AND EvidenceDescriptor.caseID = :caseID
|
