Search operators
Operator
Description
<, ≤, =, ≥, >
<>, <> or empty
Logical operators that compare the search field with the search value.
%searchkey%
Operator that enables you to search for entries containing (parts of) the specific word (search key). You can use multiple search keys to fine-tune your result.
_
The underscore can be used as a wildcard for a single character.
H_t finds: Hat, Hut, Hit.
Contains
Does not contain
Operators that search for the presence of the search value in the search field.
Contains a value
Does not contain a value
Operators that search for the presence of any value in the search field.
Starts with
Does not start with
Does not start with or is empty
Operators that search for the presence of the search value at the beginning of the search field.
Ends with
Does not end with
Does not end with or is empty
Operators that search for the presence of the search value at the end of the search field.
In
Not in
Not in or empty
Operators that search for the presence of a set of search values in the search field.
Between
Operators that search for a range of values in the search field. It includes both the start and end values.
*For orders, using the search operator Between is not possible for alphanumeric fields containing only digits because it throws off sorting. To work around this issue, do not filter on Number, but add No. (SysOrderID) to the layout to filter on the (main) order.