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