Search Comparator Configuration

To configure a dropdown list with selectable search comparators, you have to configure it for each field renderer separately.

For basic information and details on search renderers, check our object renderer documentation (opens new window).

The selectable comparator list is configured with tag <comparator_list>. It contains all allowed comparators that should be selectable in the dropdown.

Example

<field_renderer>
  <operator>AND</operator>
  <comparator>EQUAL</comparator> <!-- Default if part of comparator_list, else ignored. The first comparator from comparator_list is then the default. -->
  <comparator_list>
     <comparator>EQUAL</comparator> <!-- If no comparator is set or the comparator is no part of this list, the first comparator is the default. -->
     <comparator>NOT_EQUAL</comparator>
  </comparator_list>
  <search_fields>
    <search_field>
     <name>name</name>
    </search_field>
  </search_fields>
</field_renderer>

Result in the GUI:

Your <comparator> value is the field's default value. It must be part of the <comparator_list>, too. If not, it will be ignored. In that case, the first <comparator> from <comparator_list> is taken as the default value.

Available Comparators

Possible values for <comparator_list> are:

Comparator	Translation in the UI	Description	Limitations
EQUAL	Equal	Finds objects containing only that exact search term (nothing else).	Case-sensitive Not suitable for a full-text search.
NOT_EQUAL	Unequal	Finds only objects containing not that exact search term.	Case-sensitive Not suitable for a full-text search.
LIKE	Contains	Finds all objects containing that search term.	Not case-sensitive Only for a search in string fields (texts) Wildcard % can be configured (more details).
NOT_LIKE	Does not contain	Finds all objects not containing that search term.	Not case-sensitive Only for a search in string fields (texts) Wildcard % can be configured (more details).
IN	Contains one of	Finds all objects that contain at least one of the search terms.
NOT_IN	Does not contain one of	Finds all objects that do not contain at least one of the search terms.
CONTAINS_ALL	Contains all values	Finds all objects containing all entered search terms.
NOT_CONTAINS_ALL	Contains none of the values	Finds all objects that do not contain all entered search terms.
LESS_THAN	Less than	Finds only objects with a value less than the search term.
LESS_THAN_OR_EQUAL	Less than or equal	Finds only objects with a value less than or equal the search term.
GREATER_THAN	Greater than	Finds only objects with a value greater than the search term.
GREATER_THAN_OR_EQUAL	Greater than or equal	Finds only objects with a value greater than the search term.
IS	Is not filled	Finds all objects with value null.	Only searches for null/not null. Deactivates the search entry (ignores former entries).
IS_NOT	Is filled	Finds all objects with any value except null.	Only searches for null/not null. Deactivates the search entry (ignores former entries).
MATCH	Full-text (OR search)	Finds all objects containing at least one of the entered search terms (default) or specific phrases using full-text search comparators.	For a full-text search. Wildcards like *, + or - can be used (full-text search details (opens new window)).
MATCH_ALL	Full-text (AND search)	Finds all objects containing exactly all of the entered search terms or specific phrases.	For a full-text search. Wildcards like *, + or - can be used (full-text search details (opens new window)).