SQL-020: Retrieve all IMAGE_CATEGORY_CODE rows¶

This statement retrieves all rows from IMAGE_CATEGORY_CODE without any WHERE clause or parameters. It is executed by clsImageCategoryCodeCollection.BeforeRetrieve to populate the full code-table collection.

Classification¶

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

Parameters¶

No parameters.

Tables¶

Table	Access	Columns used
IMAGE_CATEGORY_CODE	SELECT	CODE, CODE_DESCR, CREATE_DATE, CREATE_USER, IMAGE_FILE_CODE, RETENTION_SCHEDULE_CODE

Sample SQL¶

Select
    IMAGE_CATEGORY_CODE.CODE as Code,
    IMAGE_CATEGORY_CODE.CODE_DESCR as CodeDescr,
    IMAGE_CATEGORY_CODE.CREATE_DATE as CreateDate,
    IMAGE_CATEGORY_CODE.CREATE_USER as CreateUser,
    IMAGE_CATEGORY_CODE.IMAGE_FILE_CODE as ImageFileCode,
    IMAGE_CATEGORY_CODE.RETENTION_SCHEDULE_CODE as RetentionScheduleCode
From IMAGE_CATEGORY_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\clsImageCategoryCodeCollection.vb