Object Definition Syntax › OBJECT Statement › STANDARD_LISTS Optional Statement › Example (STANDARD_LISTS Optional Statement)

Previous Topic: Optional Statements (STANDARD_LISTS Optional Statement)

Next Topic: MODIFY Statement

Example (STANDARD_LISTS Optional Statement)

This example provides both a master list and a restricted list. Both lists contain the values defined for the sym, code, and description attributes. The records in the list can be sorted according to the values in the sym and code attributes. The restricted list contains only records that were not deleted:

STANDARD_LISTS {
    SORT_BY "sym,code" ;
    FETCH "description" ;
    WHERE "delete_flag = 0" ;
};