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

Optional Statements (STANDARD_LISTS Optional Statement)

At least one of these optional statements must be specified:

SORT_BY index_att

Defines the attributes that can be used to sort the standard lists. If specified, a master list is produced. Attributes must be enclosed in quotes and separated by commas. When displayed in a list or select window, the list is sorted by the first attribute, by default. For example:

SORT_BY "sym, code" ;

FETCH fetch_att

Specifies additional attributes to keep in the cache, besides those used to sort the list. They must be enclosed in quotes and separated by commas. For example:

FETCH "description" ;

WHERE string

Specifies a condition, in SQL format and surrounded by quotes, that must be met for an object to be included in a restricted list. If specified, a restricted list is produced. This example specifies that the restricted list contain only records that were not deleted:

WHERE "delete_flag = 0" ;

MLIST ON|OFF

Indicates whether to produce a master list, which includes all objects, using one of the following values:

Note: CA SDM web engine only uses the MLIST to populate the data in the web forms. MLIST is created on the domsrvr cache.

RLIST ON|OFF

Indicates whether to also produce a restricted list, which includes only the objects that meet the criteria in the WHERE clause, using one of the following values:

Note: RLISTs can speed up access and display but they use memory. They are usually used in select windows.

Important! MLIST OFF must be specified if you specify RLIST OFF.