access.by-exp-dsnd Modifier/Access: Verbs

access.by-exp-dsnd

Command access.by-exp-dsnd Modifier/Access: Verbs
Applicable release versions: AP, R83
Category Access: Verbs (152)
Description followed by an attribute name which references a multi-valued attribute to be used individually as sort keys in descending order.

The "by-exp-dsnd" modifier is used to sort attributes that may contain more than one value. When the "by" modifier is used on a multi-valued attribute, it only sorts on the first value in the attribute. Further, each item-id will only appear one time, assuming that its display is not suppressed.

When the "by-exp-dsnd" modifier is used, it "explodes" each value in the attribute and treats each value as though it were a separate item. Each value sorts into its proper position, and the item-id will appear with each value. In other words, the number of times and item-id will appear on a report coincides to the number of values in the exploded attribute.

The "explosion limiter" specifies that output only occurs on data elements meeting the print limiting criteria.

This can be used with any verb that lists or selects items, such as "list", "sort", or "select".
Syntax by-exp-dsnd attr.name {"explosion limiter"}
Options
Example
If one invoice 0001 exists with quantity ordered attribute as follows:
005 1
    6
    3

sort invoices by-exp-dsnd quantity.ordered

The above statement would result in the following.

0001   6
0001   3
0001   1
Purpose
Related access.by-exp
access.by
basic.readnext
access.modifiers
access.attr.name
access.seqlist
access.sort
access.by-dsnd
collation.order