How do you sort on multiple fields in a list?
Clicking on the column header will sort a list ascending or descending on that specific field.
If you wish to add a secondary sort on another field hold the Shift key while clicking on the column header of the second field. Alternatively right click on the column header and choose which sort direction you would like for the second sort.
A number is added next to each sort arrow to indicate where it is in the sort order. Any number of fields can be added to the sort order.
Related Articles
8. Fields
The Fields list displays all fields that have been added to the system through the administration screens. When a field is edited the details of the field are displayed. Item Details Field name The short unique name of the field used in lists and ...
Appendix I - Special/calculated fields
A number of special/calculated fields exist in the system that are not used in the Form Editor but can be added as columns to lists. These fields are designed to provide specific information and vary depending on the table they are connected to. ...
How to sort Note order
When Notes are created against a Case, the default order is that notes marked as important are put to the top of the list. This is shown by a ‘1’ being displayed next to the column title. In the example below we can see that the order is displaying ...
Why don't fields appear in the Filter Builder?
Only those fields that are displayed as columns in the List appear in the Filter Builder. If you wish to use a field in the Filter Builder but not display it, then it can be marked as Invisible.
How can Registered Providers be setup to use multiple teams?
The Landlord and Team structure within the system allows for flexible filtering of data so that users are only able to access the data that is relevant to the their roles. However for some users, i.e. managers, they may require a wider view of the ...