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. |