Filtering Tables

All tables in CadnaA can be filtered based on conditions applied to a column. The "Filter" function can be selected from the context menu after right-clicking on a table column:

Dialog Options

Active

If the "Active" option is selected, the filter is applied to the table, otherwise not. An active filter is indicated in the table by the symbol .

Arithmetic Expression

Enter an arithmetic expression where x represents the original value of each cell. For example, entering x>5 will display only rows where the value in this column is greater than 5. The available operators are documented here. Primarily, the comparison operators (==, !=, >=, >, <=, <) are useful for filtering tables.

String Expression

If the table column displays text (instead of numeric values), filtering can be performed using a string pattern. Entering Test will display only the cells whose text is exactly "Test"*. Entering Test* will display all cells whose text begins with "Test". Further operators for string matching are documented here.

* Option "Match Case" active

Match Case

Determines whether the entered string pattern is case-sensitive. A pattern Test with this option enabled will display only cells whose text is exactly "Test". If the option is disabled, cells containing "test", "TEST", "TesT", etc., will also be displayed.