Filtering on empty fields
-
- UpdatedAug 3, 2023
- 1 minute read
- Vancouver
- Navigation and UI
Most filter operations do not return empty fields in their result set. You can create a filter that displays records with an empty field value in addition to records that match the initial filter conditions.
About this task
For example, when viewing all records that are assigned to the Hardware group, to include records with an empty Assignment group field, complete the following steps.
Procedure
Related Content
- Values for date/time fields
When you filter on fields of type date/time, such as the Created field on any task record, several time-related options are available, such as Today, This week, Last 3 months, and so on.
- Comparing field values
Field comparison allows users to evaluate equality between fields on the same table or on related tables by using operators in the condition builder.