SQL-023: Retrieve IMAGE_DOCUMENT_TYPE_CODE by key¶

This statement retrieves a single IMAGE_DOCUMENT_TYPE_CODE row filtered by IMAGE_FILE_CODE, IMAGE_CATEGORY_CODE, and CODE. It is executed by clsImageDocumentTypeCode.BeforeRetrieve.

Classification¶

Field	Value
SQL ID	SQL-023
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text**
Business object	`clsImageDocumentTypeCode`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:Code`	Input	[not specified]**	5	The document type code value.
`:ImageCategoryCode`	Input	[not specified]**	5	The image category code.
`:ImageFileCode`	Input	[not specified]**	5	The image file code.

Tables¶

Table	Access	Columns used
IMAGE_DOCUMENT_TYPE_CODE	SELECT	CODE, CODE_DESCR, CREATE_DATE, CREATE_USER, DEFAULT_DISCOVERY_FLAG, DEFAULT_CONFIDENTIAL_FLAG, DEFAULT_EXTERNAL_VIEW_CODE, EFFECTIVE_DATE, EXPIRATION_DATE, EXTERNAL_DESCR, IMAGE_CATEGORY_CODE, IMAGE_FILE_CODE, PRIORITY_CODE, SORT_ORDER_NUM, UPDATE_DATE, UPDATE_USER

Sample SQL¶

Select
    IMAGE_DOCUMENT_TYPE_CODE.CODE as Code,
    IMAGE_DOCUMENT_TYPE_CODE.CODE_DESCR as CodeDescr,
    IMAGE_DOCUMENT_TYPE_CODE.CREATE_DATE as CreateDate,
    IMAGE_DOCUMENT_TYPE_CODE.CREATE_USER as CreateUser,
    IMAGE_DOCUMENT_TYPE_CODE.DEFAULT_DISCOVERY_FLAG as DefaultDiscoveryFlag,
    IMAGE_DOCUMENT_TYPE_CODE.DEFAULT_CONFIDENTIAL_FLAG as DefaultConfidentialFlag,
    IMAGE_DOCUMENT_TYPE_CODE.DEFAULT_EXTERNAL_VIEW_CODE as DefaultExternalViewCode,
    IMAGE_DOCUMENT_TYPE_CODE.EFFECTIVE_DATE as EffectiveDate,
    IMAGE_DOCUMENT_TYPE_CODE.EXPIRATION_DATE as ExpirationDate,
    IMAGE_DOCUMENT_TYPE_CODE.EXTERNAL_DESCR as ExternalDescription,
    IMAGE_DOCUMENT_TYPE_CODE.IMAGE_CATEGORY_CODE as ImageCategoryCode,
    IMAGE_DOCUMENT_TYPE_CODE.IMAGE_FILE_CODE as ImageFileCode,
    IMAGE_DOCUMENT_TYPE_CODE.PRIORITY_CODE as PriorityCode,
    IMAGE_DOCUMENT_TYPE_CODE.SORT_ORDER_NUM as SortOrderNum,
    IMAGE_DOCUMENT_TYPE_CODE.UPDATE_DATE as UpdateDate,
    IMAGE_DOCUMENT_TYPE_CODE.UPDATE_USER as UpdateUser
From IMAGE_DOCUMENT_TYPE_CODE
Where IMAGE_DOCUMENT_TYPE_CODE.IMAGE_FILE_CODE = :ImageFileCode
  AND IMAGE_DOCUMENT_TYPE_CODE.IMAGE_CATEGORY_CODE = :ImageCategoryCode
  AND IMAGE_DOCUMENT_TYPE_CODE.CODE = :Code

Operations and processes¶

Code table management

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business\SAIF.Business.Imaging\clsImageDocumentTypeCode.vb