This guide shows you how to create a custom filter in a window of your choice. Generally speaking, you can use general SQL operators, such as the
LIKE operator, but you will also need to use the field separator (
<^>) or the segment separator (
<~>) to write your query.
Note the spaces before and after the
LIKE operator. They are essential!
Also, note the
<^> symbol. This is the field separator. It marks the search field, the operator and the value.
When querying several terms, the segment separator is used, which looks like this:
|The name of the column must be identical to the one in
Let’s use a practical example. Assume you want to create a filter for the “Attribute Value” window. This filter shall include the following filtering options: Name, Attribute and IsActive flag.
Enter the filtering code: