Manipulating Grid Column Sort Order

Under Sort Order on the Personalize Column and Sort Order page, you can alter the grid column sort order. Any sort order changes that you save remain in place until you change them again.

To specify a persistent sort order for a grid:

  1. Under Column Order, select the column on which you want to sort.

    Note that you can sort hidden columns; however, you cannot select the following column types for sorting:

    • Tab separators.

    • Images.

    • Buttons or links.

    • HTML areas.

  2. Click the right arrow to display that column under Sort Order.

    To select multiple adjacent columns, press and hold the Shift key as you select additional column names. To select multiple nonadjacent columns, press and hold the Ctrl key as you select additional column names.

  3. If you have moved more than one column to Sort Order, you can select a column and click the up and down arrow button to alter the sort hierarchy.

    You can sort multiple columns at one time. The system considers the first column in the list the primary sort, the second the secondary sort, and so on.

  4. To sort columns in descending order (instead of ascending order, which is the default), select the Descending check box for the highlighted column.

    The (desc) text appears next to the column name to indicate which columns are sorted in descending sort order.

  5. Click OK to save your changes and return to the transaction page.

    The system saves your sort settings until you change them again or until you click the Restore Defaults button in the Personalization page.

You can override the sort order of a column in a grid directly in the transaction page without altering the personalization settings. To do so, click the column heading link (not underlined) for the column that you want to sort. This action sorts the column in ascending order. You can toggle between ascending and descending order by repeatedly clicking the column heading link. The last column heading link that you click becomes the primary sort for the grid. Note that this type of sorting is only temporary. When you exit the transaction, the system does not save the sort order that you just performed.