Database SQL Operation: VerifiableDataItem.searchVerifiableEvidenceTypeByRelatedItem
Description: | Searches the verifiable data item, name, verifiable data item ID, verification requirement ID, due date and due date from for Verifiable data item by evidence type and related item id. |
Sterotype: | nsmulti |
SELECT
DISTINCT VerifiableDataItem.evidenceType
INTO
:evidenceType
FROM
VerifiableDataItem,
VerificationRequirement,
VerificationRequirementUsage
WHERE
VerificationRequirement.verifiableDataItemID = VerifiableDataItem.verifiableDataItemID
AND VerificationRequirementUsage.verificationRequirementID = VerificationRequirement.verificationRequirementID
AND VerificationRequirementUsage.relatedItemType = :relatedItemType
|