Filter settings window
Conditional filtering allows data grid contents to be filtered against any columns using boolean operators and wildcard matching.
Filter conditions are applied in the Filter settings window.
Filter conditions are organised in groups. Groups are related to each other by boolean operators. Groups are visually separated by left indentation.
Filter settings window components:
— Top-level filter group menu. Click to open a drop-down list of commands:
Add condition — adds a new filter condition in the same group (same effect as button [
]).Add group — adds a new subgroup of filter conditions.
Clear — clears all filter conditions from the window.
— Sub-level filter group menu. Performs the same function as ( ) with the exception that the command is replaced by the command. The command removes the adjacent condition or group of conditions.
— Click this button to add a new condition in the same group.
— Boolean operator. Click to open a drop-down list of boolean operators: AND, NOT AND, OR, NOT OR. These operators define the relationship between groups.
— Column name. Click to open a drop-down list containing names of all the columns in the data grid. Click a column name to select it.
— Condition operator. Click to open a drop-down list of conditions. The conditions available for selection depend on the type of column selected in ( ):
Equal to and not equal to are always available.
Greater than, less than, greater than or equal to and less than or equal to are only available when a numerical or date column is selected.
Like and not like are wildcard operators and are only available when a text column is selected. See (
) for a description of special characters used as wildcard symbols.
— Search expression. Enter the string to be matched by the condition operator in this field. Special characters:
% — percent sign. Wildcard, replaces any sequence of symbols.
_ — underscore. Wildcard, replaces any single symbol.
[abc] — square brackets. Represents a group of symbols. A row containing any one of these symbols will be considered a match.
[^abc] — represents a group of forbidden symbols. A row containing any one of these symbols will not be a match.
— Column unique values. Click this button to open a drop-down list of unique values in the column selected in ( ). Select a value to enter it in the search expression field. The first option, , clears the field. This is used to specify an empty field value as the search expression.
The
button applies the filter and closes the filter settings window. The button closes the window without applying filter settings. The button applies filter settings without closing the window.