22. Sorting

Sorting

When a query includes an ORDER BY clause, the results of the query will be displayed in the specified order.

The column or columns used in the ORDER BY clause are indicated in the results by highlighted arrows.

For example, these results:

were produced by a query which contained ORDER BY PRIORITY in its ORDER BY clause. The highlighted arrow

in the Repair Priority column indicates to the user that the results are sorted in descending order by the PRIORITY column.

When the user clicks on one of the sort arrows in a column, the results are resorted first by using the column

which was clicked on, and then by any columns by which the results were previously sorted. So in the above

example, if the user clicked on the down arrow in the SEVERITY column, the results would be sorted primarily in

ascending order by SEVERITY, and then in descending order by PRIORITY:

By default, all database columns are sortable, and all derived columns are not sortable. To change the

default behavior, you can edit the sortable property for a column in that column’s field descriptor.