Welcome > To Do > Manage work queues > Manage work queue queries > Sort columns

Sort columns

You can define a custom sort order using the columns available in a Work Queue query. You can specify sort order by selecting up to three fields and specify the direction as ascending or descending. You can sort on displayed columns and work type fields. The sorted results are displayed in the order specified in the query.

Note

  • The sorting is only applied if custom sorting is enabled in System setting at design time. (System>System settings>General>Enable custom sort order)

  • You cannot use SLA (Job) and SLA (Activity) columns for sorting.

  1. On the To Do menu, click Work Queue or click on the header.
  2. Select the query in which to sort the columns.
  3. On the toolbar, click Edit Query and then click Sorting Sorting.
    The Sorting pop-up is displayed with the sort order specified at design time.
  4. To change the sort order, on the list of Sort Order 1, Sort Order 2 and Sort Order 3, select a column and specify the direction as Ascending or Descending as required.
    Note If you specify None for all the three sort orders, no sorting is applied regardless of the system level custom sorting defined at design time.

    If you enable the Work Queue custom sorting and do not apply any sorting order at design time and runtime, the default sort order is applied.

  5. Click OK.

    The sorted results are displayed in the order specified. If you select Pending Time as display column, the time the activity became pending is displayed in the results.