access.seqlist Definition/Access: Verbs

access.seqlist

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.
Syntax
Options
Example
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.
Purpose
Related access.by
access.by-dsnd
access.by-exp
access.by-exp-dsnd
access.without
access.sreformat
access.sort
access.with
access.s-dump
access.sort-label
access.sselect
access.list-item
access.verbs
collation.order