Sort columns in a query

See Queries.

  1. Navigate to Queries > Job queries/Work queue queries/System queries.

    The list of queries appears.

  2. Create a new query or open the query in which to sort the columns.
  3. Click the Sorting tab.

    The Sorting tab is only displayed if the Work queue/Workload/Jobs setting under Enable custom sorting is selected in the System >System settings>System>General.

  4. To specify the sort order, on the list of sort order, select a column and specify the direction as Ascending or Descending.

    • Job query
      1. Sort order 1 (Default: Expected duration, Ascending)

      2. Sort order 2 (Default: None, Descending)

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

      3. Sort order 3 (Default: Disabled)

    • Work queue query

      1. Sort order 1 (Default: Due date, Ascending)

      2. Sort order 2 (Default: Priority, Ascending)

      3. Sort order 3 (Default: Pending time, Ascending)

        Note When a Work queue control is added to a new form, by default None is displayed on the sort order list. For upgraded and imported forms, the None option is available but the selected column remains as is. None property is used for client side sorting and is applied to the result set returned, even when custom server side sorting is enabled. Therefore, the results are sorted on the server and returned, and then client side sorting is applied. We recommend that you set client side sorting to None when using server side sorting.

    • System query

      1. Sort order 1 (Default: Due date, Ascending)

        The default sort order 1 is Completed date and Ascending, if Completed work is selected.

      2. Sort order 2 (Default: Priority, Ascending)

        The default sort order 2 is Pending time and Ascending, if Completed work is selected.

      3. Sort order 3 (Default: Pending time, Ascending)

        The default sort order 3 is None and Descending, if Completed work is selected.

  5. Click Save.

    For Job queue query, the sorted results are displayed in the Job list control at runtime.

    For Work queue query, at runtime the sorted results are displayed in the Work queue control in the order specified in the query. If you select Pending Time as display column, the time the activity became pending is displayed in the results.

    For System query, at runtime, the sorted results are displayed in the Workload control. If you select the Pending time as display column, the time the activity became pending is displayed in the results.