Database SQL Operation: PDCEvidenceLink.searchByTypeAndStatus
Description: | Retrieves a list of evidence types associated with a participant data case by type. |
Sterotype: | nsmulti |
SELECT
PDCEvidenceLink.pdcEvidenceLinkID,
EvidenceMetadata.evidenceType,
PDCEvidenceLink.shareableInd
INTO
:pdcEvidenceLinkID,
:evidenceType,
:shareableInd
FROM
PDCEvidenceLink,
EvidenceMetadata
WHERE PDCEvidenceLink.pdcTypeID = :pdcTypeID
AND EvidenceMetadata.evidenceMetadataID = PDCEvidenceLink.evidenceMetadataID
AND EvidenceMetadata.recordStatus = :recordStatus
|