You are here: Advanced Topics > Creating Custom Queries > Step 2 - Add Columns to Sort Order

Step 2 - Add Columns to Sort Order

Step 2 - Add Columns to Sort Order is divided into these areas:

  • The Add Columns to Sort Order drop-downs, functionality buttons, and check box - used to define the custom query sort order
  • The Defined Sort Order overview area, functionality buttons, and arrows - used to adjust the custom query sort order

To set the custom query sort order following a plan from Planning a Custom Query:

  1. Click Column to Sort On and select a column available in the selected existing query.
  2. Click Direction to set the direction of data to sort ascending or descending.

    3. Note: The Group Display check box is for future use.

  3. Click Add to Sort to add the defined sort order to the Defined Sort Order overview area.

    4. Note: The sort order is added to the end of the sort order (default) or before the sort order selected in the Add to End\Before drop-down.

  4. Make any needed adjustments to the sort order in Defined Sort Order overview area by clicking the Action buttons:
    • Delete
    • Edit
    • Move Up or  Down.

    Continue with Step 3 - Add Columns to Results List