Home > Features > Options > Sort
Sort
Feature Location: Options tab | Group and Sort (see Figure 1)
Availability: Version 1.0+, sort using custom list: Version 1.5+
Sequence: Executes after Search and Replace
This feature will sort data by up to 3 columns. Sorting can be performed using Excel's Normal sort order (e.g., alphabetically or numerically) or by specifying custom sort orders. A custom sort order may be specified for each sort column. Use the Column Selector button to specify sort settings. Alternately you can specify the sort order by following each column name with ASC or DESC to sort ascending or descending respectively. Ascending is the default order if the order is not explicitly defined.
Figure 1: Location of Sort Setting
The sort dialog is shown in figure 2. The description of each sort setting is detailed in the table below.
| Item |
Setting | Description |
| 1 |
Column |
The column(s) used for sorting the data set. |
| 2 |
Order |
The sort order used to sort the specified column. |
| 3 | Direction |
The direction Direction to sort |
| 4 | Ok button |
Saves the sort settings and closes the sort dialog. |
| 5 | Cancel button |
Cancels all changes made and closes the sort dialog. |
Figure 2: Sort Dialog Settings
This example will sort the data set first by the State field using the custom order of submitted, opened, resolved in ascending order. It will then sort by the Severity field in ascending order using Excel's default sort order.
EXAMPLE : Sort Examples - the examples listed below can be found in the download example link.
Download example
| Example | Setting | Output |
| 1 |
Sort by |
|
| 2 |
Sort by State using custom sort order submitted, opened, resolved ascending then by Severity alphabetically ascending.  |
|
| 3 | Sort by State using custom sort order submitted, opened, resolved ascending then by Severity using custom sort order Minor, Average, Major, Critical, Enhancement ascending.  |
|
See also
Report Sequence
See also