|Command||access.seqlist Definition/Access: Verbs
Applicable release versions: AP, R83
|Category||Access: Verbs (152)|
|Description||defines Access collation sequence.
The sort(s) invoked by the "by", "by-dsnd", "by-exp", or "by-exp-dsnd" modifiers a left-to-right order determine the order in which items are processed by Access.
There is no limit to the number of sort keys within an Access report.
The "by" modifier automatically sorts the specified attribute in ascending sequence, and only applies to the first value in the designated attribute, even if it contains multiple values.
The "by-dsnd" modifier sorts in descending sequence, and only applies to the first value in the designated attribute, even if it contains multiple values.
The "by-exp" modifier performs an "exploded" sort and treats every value in a multi-valued attribute as a separate item for sorting purposes. "by-exp" sorts in ascending sequence. "by-exp-dsnd" also treats each every value as a separate item for sorting purposes, but sorts in descending sequence.
sort entity by name name This example has one sort key. It produces a listing of the entity item-id and name attribute sorted by the value of the first name in each entity item. sort entity by state by city by name This example has three sort keys. First, the data in "entity" is sorted by ascending "state" sequence, and within state by ascending "city" sequence, and within city by ascending "name". The attributes listed in the file's macro or output-macro are displayed. sort invoices by-dsnd amount.due This examples reverses the normal sort order and sorts the highest values to the top of the list, which is useful for circumstances such as determining who owes you the most money.