Table Filter Expression Screen

This screen is displayed when a filter expression is being added to a table sheet, or an existing filter expression is being edited (using the Format Table Display screen).

Filter expressions can be a statement, or series of logical statements, used to control which data qualifies for inclusion in the current table. You can restrict rows based on a comparison of a database properties with a value (only show rows where an AU value is less than 2.5, for example), a comparison of two or more properties (e.g. only show rows where a copper grade is less than a grade cut-off value) or where the contents of a table cell can be matched to a pattern using regular expressions.

For more information, see logical expressions and filtering.

To configure these settings:

In Expression, enter or edit the logical expression to be applied to the table.
Click Expression Builder to launch the Data Expression Builder screen, which provides an interface for producing simple and complex logical expressions.
Check Filter Enabled to make the filter active. Active filters are applied with the other active filters listed on the Format Table Display screen. Clear this check box to make the filter expression inactive without removing it from the list, so that it can be reactivated later if required.