Object Definition Syntax › OBJECT Statement › STANDARD_LISTS Optional Statement › Example (STANDARD_LISTS Optional 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" ;
};

The STANDARD_LISTS statement alone does not necessarily create entries that are listed in a dropdown field. To create the dropdown list in a web interface form, you need to customize the statement.