Operators
Operators allow you to manipulate the attribute you can use depend on the type of field you select. The operators you can use depend on the type of field you select.
The following table explains the operators you can use and when:
| Operator | Field Type | Description |
|---|---|---|
is | Single–value text fields, Number fields | Filters content items that match the value exactly (includes) |
is not | Single–value text fields selected from a list | Filters out content items that match the value exactly (excludes) |
contains | Multi–value text fields | Filters content items that contain the value specified |
does not contain | Multi–value text fields | Filters content items that do not contain the value specified |
is above or equal | Number fields | Filters content on values equal to and exceeding the specified value |
is below | Number fields | Filters content on values less than the specified value |
- Date fields
- Elasticsearch handles date fields as text fields. When you specify dates and times as filter, make sure to use the appropriate formatting.
- Text fields
-
A text field accepts alphanumeric values as a single line of text or multiple lines of text. If the values can be selected from a list, the possible values are displayed in the drop-down menu.
Type Multiplicity Values selected from a list Operators Text Single value No is
Text Single value Yes isis not
Text Multiple value No containsdoes not contain
Text Multiple value Yes containsdoes not contain
- Number fields
-
A number fields accepts numeric values. If the values can be selected from a list, the possible values are displayed in the drop-down menu. The same operators are used regardless of the field is single or multi value, or whether the values can be selected from a list or not:
Type Multiplicity Values selected from a list Operators Number Single or Multiple value Yes or No isis above or equalis below
- Standard Tridion Sites fields
-
You can also use the following default attributes—applied to content items published from the Content Manager to Elasticsearch—to filter content:
Attribute Value Operators componentid The tcm:uri of a Component (content) isis not
componentname The name of a Component is
componentpresentation The rendered HTML page in the Content Broker (the combination of the Component and Component Template) is
publicationid The tcm:uri of a Publication isis not
publicationtitle The Title of a Publication is
schemaid The tcm:uri of a Schema (defines the fields available in Components) isis not
schematitle The Title of a Schema is
templateid The tcm:uri of a Component Template (used to render the Component in a webpage) isis not
templatetitle The Title of the Component Template is