Please enable JavaScript to view this site.

A Data select sorter sorts dictionary rows before displaying them in the data selector dialog. Sorting can be done alphabetically and numerically, and both ascending and descending order are supported.

Ordering

Data selector sorters can be ordered in relation to each other, but sorting is always done after calculated columns and filtering have been performed.

If there are multiple data selectors in the same data selector, they are performed top-down, meaning that the bottom sorter is prioritized.

Settings

Data selector sorters have the following settings:

Setting name

Description

Name

The name of the sorter. Since this is not used in expressions, there are no restrictions on which characters to use.

Notes

Internal notes.

Sort expression

Expression that returns a value that is used to sort the rows in the dictionary. The expression can return a double, int, or string and based on this, the sorting is done either in alphabetical or numerical order. See the ActiveKey() method for how to access dictionary values from the active row in an expression.

Descending order

Checked if sorting should be in descending order.

  

Keyboard Navigation

F7 for caret browsing
Hold ALT and press letter

This Info: ALT+q
Page Header: ALT+h
Topic Header: ALT+t
Topic Body: ALT+b
Contents: ALT+c
Search: ALT+s
Exit Menu/Up: ESC