This article describes the syntax for advanced result filtering.
Search for different values
When you are searching for different values, you need to enter the search terms in separate condition fields. All values that match any one of the terms will be shown (this is a logical OR).
These conditions:
will be interpreted as Remarks contains "A" OR "B" OR "C".
Filter for (non-) empty values
You can filter for (non-) empty values in a text or numeric field.
Use NULL or NOTNULL in the Condition field and click the Save button.
Wildcards
When filtering text columns, you can use wildcards to represent any character.The wildcard operator is the underscore _.
For example, filtering on _123 will match "A123", "B123", "0123", "$123", etc.