Sort Records

The Sort Records tab lists previously saved sorts for the selected query. If you have not selected a sort option for your query, Sorted by current record order displays in the list. In this case, the data is displayed in the same order as it appears in your tables.

About Sort Direction

Sorting means placing data in some kind of order to help you find and evaluate it. When you sort, you define the field you want the sort to be based on and the sort direction.

Sort Direction refers to the order in which the values are displayed, once sorted.

• Ascending order means smallest to largest (1 to 9, A to Z).
• Descending order means largest to smallest (9 to 1, Z to A).  

Changing Sort Order

The fields you select for sorting automatically defaults to ascending order. (DESC) next to the field name indicates that the values in the field are sorted in descending order.

1. From the Sort Records tab, click the Select Order button. The Select Sorting Order dialog box opens.
2. The Fields to pick from list shows all the fields you selected for this query from the Select Fields to Show in Query dialog box.
3. The Fields to sort records by list shows those fields you select to sort on and the corresponding sort order.  
4. From the Fields to pick from list box, double-click the fields or use the SHIFT and CTRL keys to select the fields you want to include in the query. The selected fields appear in the right list box in the order in which you selected them. This is the order in which Sage HRMS sorts the fields in your query. To remove a field from the Fields to include in query list, highlight it and click Remove or double-click it.
5. To change the order of the fields, move your cursor over the button to the left of the field until you see a two-headed arrow. Press your left mouse button and drag the field to the desired position. Release the mouse button. The field moves to the new position and the other fields automatically reorder to accommodate the moved field.
6. In single field sorting, all the records used in the query are sorted based on the values in a single field. Sorting a query by employee last name is an example of single field sort.
7. In multiple field sorts, Secure Query first  sorts the records based on the values in the first field, putting them in ascending or descending order as specified. When two or more records have the same field value in the first sort field, the system then sorts those records based on the value in the second sort field.
8. Click the Sort Asc/Desc  button to change the sort order.
9. Click OK.

Published: May 17, 2017
© 2017 The Sage Group plc or its licensors. All rights reserved. Privacy Policy | Copyright/Trademarks