Search Operators

*

The standard wildcard function.

This search operator works for Text fields and Single Keyword fields. It does not work for Multiple Keyword Fields.

Usage Example

Return letters starting with the letter 'a':

a*

>

Hits are generated for 'greater than' the entered value.

>=

Hits are generated for 'greater than or equal to' the entered value.

<

Hits are generated for 'less than' the entered value.

<=

Hits are generated for 'less than or equal to' the entered value.

AND

Hits are generated only if both search terms are found.

OR

Hits are generated if either of two search terms are found.

TO

Hits are generated for a range of values.

Usage Example

100 TO 110; ab* TO am*

EMPTY

Hits are generated only for documents in which this index data field is blank.

NOT EMPTY

Search for all documents in which this index data field is not blank.

TODAY

This operator works for date fields only.

It searches for dates in relation to the current date.

Usage examples

Last week:

>TODAY-7

Last 8 hours:

>TODAY-0.33

This operator works for date and date/time fields only.

It searches for dates in relation to the current date/time.

Usage example

<NOW

1/1/2025 TO NOW

NOT

Combine this operator with other operators to retrieve the opposite result.

Usage example

Exclude any results where this field contains values starting with p:

NOT p*

Username

A macro to search documents with a user's username in the index data field.

Domain\Username

A macro to search documents with a user's domain and username in the index data field.

User Displayname

A macro to search documents with a user's display name in the index data field.

User Emailaddress

A macro to search documents with a user's email address in the index data field.