SORT
SORT is a basic panel command that can be issued from any product panel containing a keyed scrollable table and in reports containing repeating groups of data.
SORT is used to change the order of data displayed:
- On keyed scrollable panels, the SORT command changes the column used as the sort key.
- On reports containing repeating groups, the groups are rearranged using the indicated field as the sort key within the boundaries of the group level. Both a primary and secondary sort key can be specified.
SORT A (ascending) is the default value assigned to the F4 key and SORT D (descending) is the default value assigned to the F5 key.
Parameter | Description |
|---|---|
1 | Applies to reports only. Used to specify the primary sort key. 1 is the default. |
2 | Applies to reports only. Used to specify the secondary sort key. |
ASCENDING | Data is sorted in alphabetical or numerical order with the lowest value listed first. ASCENDING is the default. |
DESCENDING | Data is sorted in alphabetical or numerical order with the highest value listed first. |
To issue the SORT command, perform one of the following actions:
- Type SORT (with or without parameters) on the Command line, move the cursor to the column to be used as the sort key, and press Enter
- Move the cursor to the column to be the new sort key, and press F4 or F5
Related topic