Operator Returns Documents Where...
Is like
The field contains the entered term. Blank values are filtered out, and search values can be
enclosed in double quotation marks. A partial match does not require a wildcard (*).
Relativity returns an OR operator between terms when a condition uses the "Is like"
operator, and the terms are separated by a carriage return into multiple lines, or they are
separated by a comma within a single line. For example, Relativity interprets a query as
"Field is like Term 1 or Field is like Term 2 or Field is like Term 3".
Note:For performance reasons, Relativity recommends using the "Contains" operator
rather than building queries with single or multiple uses of the "Is like" operator. See FAQs
for Contains and Is Like operators on the next page.
Is not like
The field does not contain the entered term. Wildcards (*) are already applied at the
beginning and end of a term with this operator. The comments about the "Is like" operator
also apply to "Is not like".
Relativity returns an OR operator between terms when a condition uses the "Is not like"
operator, and the terms are separated by a carriage return into multiple lines, or they are
separated by a comma within a single line. For example, Relativity interprets a query as
"Field is not like Term 1 or Field is not like Term 2 or Field is not like Term 3".
Is
The field value equals any of the entered items. Multiple values can be separated by a
comma or carriage return. Blank values are filtered out, and search values can be enclosed
in double quotation marks.
Relativity returns an OR operator between terms when a condition uses the "Is" operator,
and the terms are separated by a carriage return into multiple lines, or they are separated by
a comma within a single line. For example, Relativity interprets a query as "Field is Term 1 or
Field is Term 2 or Field is Term 3".
Is not
The field value does not equal the entered term.
Relativity returns an OR operator between terms when a condition uses the "Is not"
operator, and the terms are separated by a carriage return into multiple lines, or they are
separated by a comma within a single line. For example, Relativity interprets a query as
"Field is not Term 1 or Field is not Term 2 or Field is not Term 3".
Is set The field is not empty.
Is not set The field is empty.
Is less than The field value is less than the entered term.
Is less than
or equal to
The field value is less than or equal to the entered term.
Relativity returns an OR operator between terms when a condition uses the "Is less than or
equal to" operator, and the terms are separated by a carriage return into multiple lines, or
they are separated by a comma within a single line. For example, Relativity interprets a
query as "Field is less than or equal to Term 1 or Field is less than or equal to Term 2 or Field
is less than or equal to Term 3".
Is greater
than
The field value is greater than the entered term.
Is greater
than or
equal to
The field value is greater than or equal to the entered term.
Relativity returns an OR operator between terms when a condition uses the "Is greater than
or equal to" operator, and the terms are separated by a carriage return into multiple lines, or