SQL:VerifiableDataItem.searchAllActiveEvidenceTypeAndDataItem

Home
Application Views and Tabs
Database Tables
Pages
Domain Definitions
Code Tables
Message Files
Application Properties
Workflows
Rule Sets
Dynamic Evidence
IEG Scripts
Datastore Schemas
Page Flows

Database SQL Operation: VerifiableDataItem.searchAllActiveEvidenceTypeAndDataItem

Operation Details

Description:
Sterotype:	nsmulti

SQL

SELECT
  verifiableDataItemID,
  evidenceType,
  dataItem
INTO
  :verifiableDataItemID,
  :evidenceType,
  :dataItem 
FROM
  VerifiableDataItem 
WHERE recordStatus <> 'RST2'