Think of a sort as the sequence rows of data are displayed, for example, an ascending sort by description will list the items whose description starts with the letter A first, then B, C, D etc.
The Tracker offers quick and complex sorts.
Quick sorts sort by one column at a time. You can only sort using the columns displayed in the grid.
Complex sorts can sort ...
Calculated fields, which are calculated from the values in other fields, can't be sorted.
Complex sorts come in 3 types. 'System' sorts come with the Tracker and can be used by anyone. 'Organization' sorts are added by organization managers and can be used by everyone in their organization. 'User' sorts can only be used by their creator. Clickthe Tools icon in the grid menu then Sorts and all 3 types will be listed.
Complex sorts don't have to be complicated. The Descriptions table name sort, for example, could have been run as a quick sort.
Why use a complex sort when a quick sort would do? Because complex sorts can be set up as a default.
RUN A QUICK SORT
Calculated fields, which are calculated from the values in other fields, can't be sorted. If you try to quick-sort a calculated field, nothing will happen.
RUN A COMPLEX SORT
EDIT OR ADD A COMPLEX SORT
SELECT A DEFAULT SORT
Clickthe Tools icon in the grid menu, Sorts then Default sort ... to pick a default sort. When you open a screen, the Tracker runs ...
DUPLICATE A COMPLEX SORT
Click the Utilities icon in the main menu then Sorts).the Tools icon in the grid menu, Sorts then Edit sorts ... to open the Sorts screen (organization managers can also click