Functional description
Difficulty level:
How do I search in a field with custom values?
A general explanation of searching with a particular field type.
Columns in the filters have a fixed field type. The possibilities of the search differ per type.
Field type
Custom.
There are two main flavors here: custom fields with a self-specified field type (text, numeric, date) and the "Custom table".
This page only describes the custom table fields. The other types follow their regular pattern.
A custom table has an id and a value. And can be saved in a 1-to-1 or 1-to-many format.
You can search for both the id and the value.
Allowed operators
| != | >= | <= | > | < | = | NOT IN | IN | !~ | ~ | IS NOT | IS |
|---|---|---|---|---|---|---|---|---|---|---|---|
| YES | NO | NO | NO | NO | YES | YES | YES | NO | NO | NO | NO |
Example advanced
RES_CUSTOM01 IN (1, Value)
