Database SQL Operation: Verification.searchByCaseIDConcernRoleAndEvidenceType
Description: | Returns a list of verifications that are of the same evidence type, related to the same individual and on the same case. |
Sterotype: | nsmulti |
SELECT
Verification.verificationRequirementID,
Verification.verificationID
INTO
:verificationRequirementID,
:verificationID
FROM
Verification,
VDIEDLink
WHERE Verification.VDIEDLinkID = VDIEDLink.VDIEDLinkID
AND VDIEDLink.evidenceDescriptorID IN
(
SELECT
evidenceDescriptorID
FROM
EvidenceDescriptor
WHERE participantID = :concernRoleID
AND caseID = :caseID
AND evidenceType = :evidenceType
)
|