Database SQL Operation: ProductEvidenceLink.searchByProductID
Description: | Retrieves a list of evidence types associated with a specified product. |
Sterotype: | nsmulti |
SELECT
ProductEvidenceLink.productEvidenceLinkID,
EvidenceMetadata.evidenceType,
ProductEvidenceLink.shareableInd
INTO
:productEvidenceLinkID,
:evidenceType,
:shareableInd
FROM
ProductEvidenceLink,
EvidenceMetadata
WHERE ProductEvidenceLink.productID = :productID
AND EvidenceMetadata.evidenceMetadataID = ProductEvidenceLink.evidenceMetadataID
AND EvidenceMetadata.recordStatus = :recordStatus
|