Searching quick reference guide
Use this search quick reference to improve your understanding of searching within Relativity.
Fields types and filter types
Field type | Boolean | Text box | Single-choice list | Multi-choice list | Pop up | Custom/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 string | Results |
---|
salt pepper | The exact phrase salt pepper. |
salt and pepper | The 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 pepper | Either salt or pepper. |
salt w/5 pepper | Salt appears within five words of pepper. |
salt NOT w/5 pepper | Salt does not appear within five words of pepper. |
salt pre/5 pepper | Salt appears within five words before pepper. |
salt and not pepper | Salt appears but pepper does not. |
salt | Any word that begins with salt. For example, salted or saltiness. |
dtSearch fuzzy searching and stemming
Character | Definition | Example |
---|
% | 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
Operator | Fixed-length text, long text, extracted text | Whole number, decimal, currency | User | Date | Yes/No | Single 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.
Filter | Description |
---|
Boolean | Available for Yes/No field types. Conditions display a drop-down list similar to list filters. |
CustomOnly | Uses filtering criteria from advanced and Boolean operators. |
List | Usually associated with fields used for coding documents. Conditions vary by the type and purpose of the field associated with it. |
Multi list | Uses multiple conditions from a drop-down menu. You can connect the conditions with the OR or AND operator. |
Pop-up pickers | Contains 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)
|