BY-EXP-DSND is a modifier that first separates the values in a MultiValued attribute and then sorts them in descending order. EXP stands for exploded, meaning that each value in the MultiValued attribute is sorted separately.
Format
|
BY-EXP-DSND attribute [BY-EXP-DSND attribute ...] |
Example
This example sorts orders by last name, then sorts the MultiValued item TITLE in descending order. The BREAK-ON modifier separates the report by LAST-NAME:
|
>SORT ORDERS BY LAST-NAME BY-EXP-DSND TITLE BREAK-ON LAST-NAME TITLE |
||
|
|
|
|
|
PAGE 1 |
|
14:17:26 DD MMM YYYY |
|
|
|
|
|
ORDERS.. |
LAST-NAME... |
TITLE............................ |
|
|
|
|
|
10122 |
BUCKLER |
WRITING COMMERCIAL APPLICATIONS |
|
|
|
|
|
|
*** |
|
|
|
|
|
|
10105 |
EDGECOMB |
WRITING COMMERCIAL APPLICATIONS |
|
10105 |
EDGECOMB |
WORD PROCESSING |
|
10115 |
EDGECOMB |
OPERATING SYSTEM CONCEPTS |
|
10105 |
EDGECOMB |
DATABASE MANAGEMENT SYSTEMS |
|
10115 |
EDGECOMB |
DATABASE MANAGEMENT SYSTEMS |
|
|
|
|
|
|
*** |
|
|
|
|
|
|
10113 |
JENKINS |
WORD PROCESSING |
|
10113 |
JENKINS |
OPERATING SYSTEM CONCEPTS |
|
|
|
|
|
|
*** |
|
|
|
|
|
|
10107 |
JOHNSON |
OPERATING SYSTEM CONCEPTS |
|
10111 |
JOHNSON |
OPERATING SYSTEM CONCEPTS |
If the BY-DSND modifier had been used in place of BY-EXP-DSND, TITLE would have been sorted by the first title of each order only. The remaining titles would not have been sorted.
See Also