Sort Tab

Use the Sort tab to arrange the display of rows in the Table Editor or Point and Shoot Editor. To arrange rows according to values in one or more columns, drag column names from the Available Columns list to the Sort Columns list.

sort tab where you choose columns to be sorted and direction of the sort, ascending or descending

Sort Columns

Names of columns, in priority order, used for arranging the display of rows in the table. The arrangement has no effect in a process using the Access Definition.

Column Name
Name of column. Select a column name in the Available Columns box and drag it to the Sort Columns box. (You can also double-click a column name to move it.)
  • To rearrange the order of priority in the Sort Columns box, drag a column name to a new position.
  • To remove a column name from the Sort Columns box, drag the column name to the Available Columns box, or right-click the name and select Remove.
Desc
Sequence of values in the column:
  • To arrange in descending order, select the check box.
  • To arrange in ascending order, clear the check box.

Available Columns

Names of columns that are not involved in the sort sequence.

Sort Specifications Identified

A sort criteria icon sort criteria icon in the Table Specifications column on the Access Definition Editor table List indicates that sort criteria are specified.