STANDARD_LISTS Optional Statement

This article contains the following topics:
casm172
This article contains the following topics:
The optional statement on the FACTORY statement that defines the object’s standard lists.
Syntax (STANDARD_LISTS Optional Statement)
STANDARD_LISTS { [SORT_BY index_att ;] [FETCH fetch_att ;] [WHERE string ;] [MLIST ON|OFF;] [RLIST ON|OFF;] } ;
 
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:
Value
Description
ON
Produces a master list (default if SORT_BY is specified)
OFF
Does not produce a master list (default if SORT_BY is not specified or has no value defined)
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:
Value
Description
ON
Produces a restricted list (default if WHERE is specified)
OFF
Does not produce a restricted list (default if WHERE is not specified or has no value defined.)
RLISTs can speed up access and display but they use memory. They are usually used in select windows.
MLIST OFF must be specified if you specify RLIST OFF.
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.