Database SQL Operation: VDIEDLink.readEDIDRelatedIDAndEvidenceTypeByVDIEDLinkID
Description: | Method finds the relevant VDIEDLink record using the passed in key, then using the evidence descriptor ID on VDIEDLink reads the related evidence descriptor entity and returns the evidenceID, Evidence Type and Related ID. |
Sterotype: | ns |
SELECT
EvidenceDescriptor.evidenceDescriptorID,
EvidenceDescriptor.evidenceType,
EvidenceDescriptor.relatedID
INTO
:evidenceDescriptorID,
:evidenceType,
:relatedID
FROM
EvidenceDescriptor,
VDIEDLink
WHERE VDIEDLink.VDIEDLinkID = :VDIEDLinkID
AND VDIEDLink.evidenceDescriptorID = EvidenceDescriptor.evidenceDescriptorID
|