Changing the Sort Sequence of a Grid
Access the application containing the grid that you want to change.
Click the Personalize Grid icon to open the Grid Format Manager side panel.
Create a new grid format or select an existing one that you want to modify.
Scroll to the Data Sequencing section.
If you want to sort on a column, click the column name in the Available Columns list, and then click the right arrow.
The system moves the column name from the Available Columns list to the Sequenced Columns list.
A column must be included in the grid before you can sort on it, that is:
for a Table View grid format, its name must appear in the Display and Order section.
for a List View grid format, the field must be included in the Layout section. (Release 9.2.0.5)
If you do not want to sort on a column, click the column name in the Sequenced Columns list, and then click the left arrow.
The system moves the column name from the Sequenced Columns list to the Available Columns list.
To rearrange the order of sort precedence, use the up and down arrows under the Sequenced Columns list to rearrange the column names.
The system first sorts by the column at the top of the list, then by the column second from the top, and so forth.
To sort column values in ascending order, click the column name in the Sequenced Columns list and select the Ascending check box.
If you leave the Ascending box blank, the system sorts the column in descending order.
An A appears next to the column names to be sorted in ascending order, and a D appears next to the column names to be sorted in descending order.
When finished, click the Save button, and then click the Close button.