Last date modified: 2025 12 Aug

Searching quick reference guide

Use this search quick reference to improve your understanding of searching within Relativity.

Fields types and filter types

Field typeBooleanText boxSingle-choice listMulti-choice listPop upCustom/Advanced
Fixed-length text   
Long text *    

Date

    
Number
Whole, decimal, currency
    
Yes/No     
Single choice    
Multiple choice    
Single object   
Multiple object   

Long text search in text box only works if the field is not enabled for data grid.

dtSearch strings and operators

dtSearch stringResults
salt pepperThe exact phrase salt pepper.
salt and pepperThe word salt and the word pepper.
"salt and pepper shaker"

The exact phrase salt and pepper shaker.

dtSearch assumes the word and was removed from the noise words list.

salt or pepperEither salt or pepper.
salt w/5 pepperSalt appears within five words of pepper.
salt NOT w/5 pepperSalt does not appear within five words of pepper.
salt pre/5 pepperSalt appears within five words before pepper.
salt and not pepperSalt appears but pepper does not.
saltAny word that begins with salt. For example, salted or saltiness.

dtSearch fuzzy searching and stemming

CharacterDefinitionExample
%Fuzzy searching"app%%" matches apply and apple, but not applied
~Stemming"apply~" matches apply, applied, applies, and so on

Search operators and field types for saved searches

OperatorFixed-length text, long text, extracted textWhole number, decimal, currencyUserDateYes/NoSingle choice, multiple choice
All of these, Not all of these     
Any of these    
Between     
Contains*     
Does not contain*     
Is*  
Is after, Is after or on     
Is before, Is before or on     
Is greater than*    
Is in     
Is less than*    
Is like*     
Is logged in user     
Is not*  
Is not like*     
Is not set
Is set
None of these    

The fields marked with an asterisk in the Fixed-length text, long text, extracted text column only work if the field is not enabled for data grid.

FilterDescription
BooleanAvailable for Yes/No field types. Conditions display a drop-down list similar to list filters.
CustomOnlyUses filtering criteria from advanced and Boolean operators.
ListUsually associated with fields used for coding documents. Conditions vary by the type and purpose of the field associated with it.
Multi listUses multiple conditions from a drop-down menu. You can connect the conditions with the OR or AND operator.
Pop-up pickersContains values for multiple or single choice fields, as well as multiple or single choice objects.
Textbox

Used to search on specific terms, numbers, and dates. You can enter multiple terms connected by any of the following operators:

  • AND

  • OR

  • BETWEEN

  • = (equal)

  • >= (greater than or equal to)

  • <= (less than or equal to)

  • % (to filter for NOT null)

Return to top of the page
Feedback