Open topic with navigation

Sort the Query Results

For any query, you can define criteria to determine how the results will be sorted by default.

Before You Begin

When defining sort criteria for a query, note that:

• The sort criteria determines the default sort order for query results. After the results are displayed, users can modify the sort order in the results grid.
• If no sort criteria has been defined, the query results will not be sorted in any particular order by default. Users can still modify the sort order in the results grid.
• Any sort criteria that is defined for numeric columns in a query will be applied to stored values (vs. displayed values) regardless of whether the query is running in formatted or unformatted mode.
• Unlike the sorting that you can apply directly to the results, sorting preferences that you define in the Design workspace are stored with the query itself and are applied each time you run the query.

For example, according to the following image, the Asset Installation Date will be sorted in Ascending order:

These sort options will affect the query results, as shown in the following image:

Note: The sort order that you specify within the query definition will be saved as the default layout for the results.

Steps

1. For the query whose results you want to sort, access the Design workspace.

2. In the Conditions section, in the Sort cell for the field that you want to sort, select Ascending or Descending.

   Note: By default, the Sort Index cell for the first field that you sort displays a 1, indicating that this field will be used as the primary sort value.

3. If you want to set a secondary sort value, in the Sort cell of the appropriate field, select Ascending or Descending.

   Note: By default, the Sort Index cell for the second field that you sort displays a 2, indicating that this field will be used as the secondary sort value.

4. Repeat these steps until you have defined all the sort values you want.

   After you run the query, the columns for which you defined a sorting preference will be sorted in the specific order.

Copyright © 2018 General Electric Company. All rights reserved.