Operation Details
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
SQL 
SELECT
  DISTINCT VerifiableDataItem.verifiableDataItemID,
  VerifiableDataItem.dataItem,
  VerifiableDataItem.name,
  VerificationRequirement.verificationRequirementID,
  VerificationRequirement.dueDays,
  VerificationRequirement.dueDateFrom
INTO
  :verifiableDataItemID,
  :dataItem,
  :name,
  :verificationRequirementID,
  :dueDays,
  :dueDateFrom 
FROM
  VerifiableDataItem,
  VerificationRequirement,
  VerificationRequirementUsage 
WHERE VerifiableDataItem.evidenceType = :evidenceType 
  AND VerificationRequirement.verifiableDataItemID = VerifiableDataItem.verifiableDataItemID 
  AND VerifiableDataItem.recordStatus <> :recordStatus 
  AND VerificationRequirement.fromDate <= :currentDate 
  AND 
  (
    VerificationRequirement.toDate IS NULL 
    OR VerificationRequirement.toDate >= :currentDate 
  ) 
  AND VerificationRequirementUsage.verificationRequirementID = VerificationRequirement.verificationRequirementID 
  AND VerificationRequirementUsage.relatedItemID = :relatedItemID 
  AND VerificationRequirementUsage.recordStatus <> :recordStatus 
  AND VerificationRequirement.recordStatus <> :recordStatus 
  AND VerificationRequirementUsage.relatedItemType = :relatedItemType