Sort Order

Shortcut: Ctrl+R

This dialog box allows you to specify how the rows of the grid should be ordered.

Current -- Shows the sort expression that is currently used.

New -- Enter the new sort expression you want to apply, using the following syntax:

<FieldName> [ASC|DESC][, ...]

Where:

• <FieldName> is the name of the field to sort on. You must enclose the name in square brackets ('[' and ']') if it contains spaces or special characters.
• ASC indicates the field should be sorted in ascending order (with the smallest value at the top).
• DESC indicates the field should be sorted in descending order (with the greatest value at the top).
• Each field expression should be separated by a comma (',').
• When you use several fields, the first one is the main order, the second one is the secondary order, etc.

If no expression is specified, the grid will be displayed in the order the entries are in the database (which should be the same as the Key field).

Important: The sort order, like the filter, is dynamic. The changes you make to the entries are reflected in the sort order of the row immediately.

Examples -- Click this button to get a list of pre-defined examples you can insert directly in the edit box.

Fields -- Click this button to get a list of the fields available.

Order -- Click this button to get the list of the order available.

Set Sort -- Click this button to apply the new sort expression and close the dialog box.

Clear Sort -- Click this button to remove the sort expression and close the dialog box.

Example of expressions:

[Text_EN_US] DESC, Key
Text_EN, ChgDate_EN, ChgUser_EN
ChgUser_FR, ChgDate_FR

Use brackets ([...]) to enclose names of fields that include white spaces or special characters.

When editing the sort expression you can leave any number of trailing spaces and commas. They are removed automatically when the dialog box is closed.

You can also set the sort order directly from the main window by clicking the headers of the grid:

• If you left-click on a column header, the sort is automatically set to the column's field ascending or descending order (alternatively).
• If you right-click on a column header, the sort expression is set to the column's field ascending or descending order, and the Sort Order dialog box opens, so you can make additional changes if needed.