Search operators on the advanced Search page

The following table describes the search operators used to construct search expressions in an advanced search on the Search page.

Note: The information in the following table does not apply to Document Content contains and Document Content does not contain, which use dtSearch syntax detailed in later sections. The People fields designation applies to People, Identities, and Organizations. Most search expressions apply to a single field (for example, Document Title), although some expressions apply to specific features in Nuix Discover (for example, History or Levels).

Operator	Applies To	Results
has a value	All Fields	Returns documents that are coded.
does not have a value	All Fields	Returns documents that are not coded.
is	Pick Lists Text Number Yes/No People	Returns documents coded with the search term. One-to-many fields might be coded with additional values.
is not	Pick Lists Text Number Yes/No People	Returns documents not coded with the search term. The result set includes documents that are not coded to any value in addition to documents coded with other values.
is only	Pick Lists People	Returns documents that are only coded with the search term.
is any of	Pick Lists People	Returns documents that are coded with the search term. This operator is used to create multiple search expressions that are grouped together separated by the OR operator.
greater than	Pick Lists Text Number People	Returns documents coded with a value that is alphabetically or numerically greater than the search term.
greater than or equal to	Pick Lists Text Number People	Returns documents coded with a value that is alphabetically or numerically greater than or equal to the search term.
less than	Pick Lists Text Number People	Returns documents coded with a value that is alphabetically or numerically less than the search term.
less than or equal to	Pick Lists Text Number People	Returns documents coded with a value that is alphabetically or numerically less than or equal to the search term.
is like	Pick Lists Text Memo People	Returns documents where the search term is found anywhere in the field value. A search for Document Title is like pl returns documents with apple in the title.
is not like	Pick Lists Text Memo People	Returns documents where the search term is not found anywhere in the field values. Also returns documents not coded with any value and documents coded with other values.
contains	Pick Lists Text Memo People	Returns documents that satisfy the search expression. Permissible syntax includes: Single terms Single terms with . This will find values with the word stem. Phrases (use double quotes around phrases) Phrases with . Use double quotes around phrases. Each term in the phrase is considered a stem. For example, “local wine*” will find “locally wined and dined”. AND, AND NOT, and OR are supported. The AND operator is evaluated before the OR operator. For example, Term A AND NOT Term B OR Term C is logically evaluated as (Term A AND NOT Term B) OR Term C. AND NOT is not supported as the first part of a CONTAINS search.
does not contain	Pick Lists Text Memo People	Returns documents that do not satisfy the search expression including documents that are not coded with any value. See permissible syntax in the previous row.
begins with	Pick Lists Text People	Returns documents where the search term is found at the beginning of the field value. A search for Document Title begins with apple returns documents with Apple Pie in the title but does not return documents with Red Delicious Apple in the title.
does not begin with	Pick Lists Text People	Returns documents where the search term is not found at the beginning of the field value, including documents that are not coded with any value and documents coded with other values.
is between	Pick Lists Text Number Date	Returns documents coded with a value that is between the search terms inclusive. For text fields and pick list fields, returns documents with a value alphabetically between the two search terms, inclusive of the search terms. For number fields, returns documents with a value numerically between the two search numbers inclusive. For date fields, returns documents with a value chronologically between the two search dates inclusive.
not between	Pick Lists Text Number Date	Returns documents coded with a value that is not between the search terms inclusive. This includes documents that are coded with values outside the range, and documents that are not coded with any value.
on	Date	Returns documents coded with the exact search date. One-to-many fields might be coded with other values.
not on	Date	Returns documents not coded with the exact search date. This includes documents that are coded with no value and documents that are coded with other values.
after	Date	Returns documents coded with a date that is later than the search date.
on or after	Date	Returns documents coded with a date that is later than or equal to the search date.
before	Date	Returns documents coded with a date that is earlier than the search date.
on or before	Date	Returns documents coded with a date that is earlier than or equal to the search date.
find similar to	Document ID	Returns documents that are conceptually similar. This type of search returns the same results that you receive if you select a document in the List pane, and then select Find similar on the Options menu.
is correspondence between	People	Requires the selection of two people values. Returns documents where one of the people values is an author (FROM) and one of the people is a recipient (TO, CC, BCC). The order of selected names does not impact the result.
is like correspondence between	People	Requires the input of two people search terms. Returns documents where one of the search terms matches an author (FROM) and the other search term matches a recipient (TO, CC, BCC). The order of search terms does not impact the result. The LIKE search syntax applies such that the search term can appear anywhere in the people value.
contains correspondence between	People	Requires the input of two people search terms. Returns documents where one of the search terms matches an author (FROM) and the other search term matches a recipient (TO, CC, BCC). The order of search terms does not impact the result. The CONTAINS search syntax applies. See the contains entry earlier in this table.
Previous Value Ever Was	Pick Lists Text Number Yes/No Date Fields	Returns documents where the search term matches how a document was previously coded in the searched field.

‎