Reveal Help Center

Review Search Operators

Depending on type and attributes of a field, different search operators are available. Below are details regarding operators available for Text, Text with multi-values, and Date/Numbers.

Text

Is Like – Finds text within a field or other text string. Using % around search text finds values of text that are within a text string. Example: Is Like %find% will return results on fields with IsLikewillfindtextwithinothertext.

Is Not Like – Opposite of Is Like. Will exclude results with search text found within field and text strings. Using % around search text is a way to exclude text strings from the search results. Example: Is Not Like %find% will NOT return results on fields with IsLikewillfindtextwithinothertext.

Search_Operators_image.png

Contains – Finds items in a field based on items known to exist in the field throughout the database from a pre-populated list of unique items. Contains provides the option to use the AND/OR operators to separate terms. Example: after filtering on smith and selecting the items desired with the OR operator, documents with Curtis Smith OR Day Smith L in the To field will be returned. Other items and text can also be present in the field.

Does Not Contain – Performs the opposite of Contains search. Also provides the use of AND/OR operators. Example: after filtering on smith and selecting the items desired with the OR operator, any documents with Curtis Smith OR Day Smith L in the To field will NOT be returned.

Equal To – Finds items that exactly match the text or phrase inside the field with no other text present. Example: Find will return documents where only the word find exist in the field but not where find data exists.

Not Equal To – Performs opposite of Equal To in that documents with field that DOES NOT have the exact text match to the search term will be retrieved. Example: Find will NOT return documents where only the word find exists in the field but will where find data exists.

Is Empty – Used to locate all records where the specified field contains no data. Example: To field Is Empty will return all records where To contains no data.

Is Not Empty – Used to locate all records where the specified field contains data. Example: To field Is Not Empty will return all records where To contains data.

Text (multi-value)

Same as Text Plus

Has Any – Performs like Contains using the OR operator. Example: after filtering on smith and selecting the items desired, documents with Curtis Smith OR Day Smith L in the To field will be returned. Other items and text can also be present in the field.

Has None – Performs like Does Not Contain using the OR operator. Example: after filtering on smith and selecting the items desired, any documents with Curtis Smith OR Day Smith L in the To field will NOT be returned.

Has All - Performs like Contains using the AND operator. Example: after filtering on smith and selecting the items desired, documents with Curtis Smith AND Day Smith L in the To field will be returned.  Other items and text can also be present in the field.

Date/Number*

Equal To – Finds items that exactly match the text or phrase inside the field with no other text present. Example: Equal To 04/12/2021 will return documents where the date exists in the field.

Not Equal To – Performs opposite of Equal To in that documents with field that DOES NOT have the exact text match to the search term. Example: Not Equal To 04/12/2021 will return only documents where 04/12/2021 DOES NOT exist in the field.

Greater than - Finds records with values after the date or larger than the date or number inside the field. Example: Greater than 04/12/2021 will return documents where the date is after 04/12/2021.

Greater than or equal to - Finds records with values on or after the date, or larger or equal to the date or number inside the field. Example: Greater than or equal to 04/12/2021 will return documents where the date is 04/12/2021 and all after.

Less than - Finds records with values before the date or smaller than the date or number inside the field. Example: Less than 04/12/2021 will return documents where the date is before 04/12/2021.

Less than or equal to - Finds records with values on or before the date, or smaller or equal to the date or number inside the field. Example: Less than or equal to 04/12/2021 will return documents where the date is 04/12/2021 and all before.

Is Empty – Used to locate all records where the specified field contains no data. Example: Sent Date field Is Empty will return all records where Sent Date contains no data.

Is Not Empty – Used to locate all records where the specified field contains data. Example: Sent Date field Is Not Empty will return all records where Sent Date contains data.

Range - Finds items within the date range or within the specified number range inside the field including the search dates/numbers. Example: 04/12/2021 – 4/30/2021 will return documents where the date is after 04/11/2021 and before 05/01/2021.

*Please note that for date examples, Reveal supports DD/MM/YYYY as a format also.