Using the LIST and SORT Commands

LIST and SORT are two general-purpose INFO/ACCESS commands. LIST displays items in either a dictionary or a data file and gives the user great flexibility in generating reports for these entries. SORT has the same capabilities as LIST and also displays items in sorted order.

The LIST command specifies:

  1. Which attributes to display in the report. An item might have 10 or 12 attributes, but a report might only list the contents of two of them. By default, LIST displays no attributes, only item-IDs.

  2. Which items to select for inclusion in the report. This is done by explicitly specifying items by their item-IDs or by using a selection expression to select only those items that match the specified criteria. These two approaches may also be combined to specify a subset of items and then test them against selection criteria.

  3. How to sort the items. Items may be sorted in ascending or descending order, based on data referenced by any attribute name.

  4. How MultiValued attributes are treated. A report may display all values from MultiValued attributes or only those values that meet the specified condition.

The user may also specify report headings, footings, and vertical spacing, calculate subtotals and totals for the data in various attributes and other formatting parameters, which are described in Formatting a Report.

See Also

Producing Reports with LIST and SORT

Displaying Selected Attributes

Using Selection Expressions

Using SORT Expressions

Using Print Limiters

Producing Vertical Listings with LIST-ITEM