Filter Editor
To create a custom filter on a table, select Filter | Custom Filter from the data view menu:
Do the following:
- If there are multiple filter conditions, select a logical (AND, OR) operator.
- Select a column as the operand.
- Select a comparison operator and, if applicable, enter a comparison value.
- Click Add to add the filter condition to the Filter Text pane.
- If necessary add further filter conditions (see Step 1).
- Finally, click OK to apply the filter to the table.
The filter is applied to the table and is visible below it:
To turn the filter on and off, use the check box provided. Click the Clear button or select the Clear Filter menu option to clear the filter permanently.
When using a LIKE comparison you can only use the wildcard in the following ways:
At the beginning and end (e.g. %ABC%)
At the end (e.g. ABC%)
When the column data type is text:
- If a % or * wildcard symbol are added at the beginning or at the end of the filter string, the input value will be automatically enclosed in quotes: 'abc%'
- If no % or * wildcard symbols have been added at the beginning or at the end of the filter string, to ensure a LIKE rather than exact result. the input value will be automatically enclosed by the % wildcard symbol and then quotes: '%abc%'
When the column data type is numeric, the input value is left as is.