Welcome > Jobs > Manage JobList queries > Sort columns

Sort columns

You can define a custom sort order using the columns available in a JobList 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 the custom sorting is enabled in System settings 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 Jobs menu, click Find.

    The Jobs page appears, listing all live jobs.

  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 specify the sort order, on the list of Sort Order 1 (Default: Expected Duration, Descending), Sort Order 2 (Default: None, Descending), and Sort Order 3 (Default: Disabled), select a column and specify the direction as Ascending or Descending.

    The Sort Order 3 is only available when you specify a column for Sort Order 2.

    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 JobList 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.