Home > MultiValue Central > Online D3 Reference > Access: Verbs > collation.order

collation.order

Definition/Access: Verbs, Releases: R83 and AP

Definition of collation order.

Description

refers to the sequence in which data is collated or sorted in an Access process.

The collation order is typically triggered by one of the following Access modifiers: 'by', 'by-dsnd' 'by-exp', or 'by-exp-dsnd'.

The term 'seqlist' (short for 'sequence list') is used throughout Advanced Pick Reference Manual as a convention for representing the collation order.

Example

sort entity by zip
sselect invoices by date by customer
sort entity with name = '[mike]' by name

See Also

Command Name Type Description
access.by Modifier Defines (ascending) sort key in Access sentence.
access.by-dsnd Modifier Defines descending sort key in Access sentence.
access.by-exp Modifier Explodes multi-values for sorting purposes.
access.by-exp-dsnd Modifier Explodes multi-values in descending sequence.
access.sellist Definition Defines selection criteria portion of an Access sentence.
access.selection.criteria Definition Description of Access selection criteria.
access.seqlist Definition Definies collation sequence.
access.verbs Definition General form of Access sentences.
list.processor Definition Access output-processing facility.
access.introduction Introductory a Pick facility to retrieve and output data.

User Comments

What do you think?

Share your experience or ask a question by using the form below.

Login to leave your comments.