Filters Flashcards
(42 cards)
What is the purpose of filtering in Relativity?
To search for items in a list quickly and easily
What determines the available filter types in Relativity?
The field type associated with each column
Do you need specific security permissions to use filtering in Relativity?
No
How can you enable filters in the item list?
By clicking an icon located at the top of the document list
What happens when you click the Show/Hide filters icon?
It displays the field filters at the top of each column and turns orange when activated
What does the Clear all option do?
Removes the current filter settings
What should you do before defining a new search filter?
Click the Clear All icon or link to remove any existing filter settings
What are the steps to use a filter?
- Enable filtering 2. Enter filter criteria 3. Press Enter to display results
What are the available filter types in Relativity?
- Boolean
- Numeric
- List
- Date
- Multi-list
- Text box
What is a Boolean filter used for?
Yes/No field types
How do you apply a numeric filter?
Select an operator from the drop-down menu and enter a numerical value
What operators can be used with numeric filters?
- Equal to (=)
- Not equal to (!=)
- Greater than (>)
- Less than (<)
- Less than or equal to (<=)
- Greater than or equal to (>=)
What types of fields can use List filters?
- Single Choice
- Single Object
- User
- Fixed Length Text
What operators are available for date filters?
- (All)
- (Not Set)
- Is
- Is before
- Is before or on
- Is after
- Is after or on
- Between
What is the function of the multi-list filter?
To select multiple conditions from a drop-down menu
What field types can use text box filters?
- Fixed-length Text
- Long Text
- Date
- Whole Number
- Decimal
- Currency
- Object
What operators can you use in text box filters?
- AND
- OR
- IS SET
- IS NOT SET
- BETWEEN
- = (equal)
- > = (greater than or equal to)
- <= (less than or equal to)
What should you avoid when entering dates in searches?
Placing a zero (0) in front of single-digit values
What is the result of using ‘cubs OR sox’ in a text box filter?
Matches either cubs or sox or both
What does the ‘IS SET’ operator do?
Returns only items where the field has a value
How do you perform alphabetical filtering?
Use operators like >= or <= with a letter
What does the ‘Between’ operator do in date filters?
Matches dates that fall between two specified dates
What is the advanced filtering feature used for?
To build more complex filter queries
What happens if you do not enter a specific time when filtering on date fields?
Relativity enters the default time of 12:00 AM