A Data select calc filter is a filter that controls which rows in the referenced dictionary are displayed in the data selector.
If a filter should not always be used, or if different filters should be used depending on the circumstances, this can be controlled by the filters' activation expressions. Because the activation expression is executed once before any filtering is performed, it is a good idea to use activation expressions instead of adding the corresponding logic to the inclusion expressions that are executed for each remaining row in the dictionary.
Ordering
Data selector calculation columns and data selector filters can be arranged in relation to each other. If a calculated column is not needed during filtering, it is recommended to place calculation columns after all filters to reduce the number of cell values that are calculated and improve performance.
If multiple data selector filters are active in the same data selector, the second filter will be applied to the dictionary rows remaining after the first filter, and so on.
Settings
Data selector filters have the following settings:
Setting name |
Description |
|---|---|
Name |
The name of the filter. Since this is not used in expressions, there are no restrictions on which characters to use. |
Notes |
Internal notes. |
Activation expression |
Expression that controls whether the filter should be applied. |
Inclusion expression |
Expression that controls whether the active row in the dictionary should be displayed in the data selector dialog. See the ActiveKey() method for how to access dictionary values from the active row in an expression. |
