Filtering records
Learn how to filter records in NocoDB.
Filters provide a powerful way to narrow down and organize your data according to your specific requirements. NocoDB supports nested filters, allowing you to select multiple fields and conditions for filtering. You can choose between and or or mode of operation to combine filters, and filtering also supports Lookup, Formula, and Nested Data.
Adding or Editing Filters
To add or edit a filter, simply click the Filter button in the toolbar and select either Add filter or Add filter group.
Configure the filter by specifying the Field, Operation, and Value (if applicable).
You can combine multiple filter conditions using either And or Or mode of operation.
Deleting Filters
To remove a filter, click on the bin icon located to the right of the respective filter.
Grouping Filters
You also have the option to group multiple filters together using a Filter Group.
Filter by Current User ☁
This feature is available in NocoDB Cloud and NocoDB Enterprise Edition.
To filter records based on the current logged-in user, you can use the Current User option in the filter configuration for User field & its derivatives (createdBy & updatedBy field types) . This is particularly useful when creating views that display records relevant to the user currently logged in.
Toolbar filters display an "@" icon next to the filter count to indicate the presence of dynamic filters based on the current user applied to the view.
"Current User" based filters evaluate to false in publicly shared views. The shared view will display all records after applying any other filters. If "Current User" was the only filter applied, no records will be shown.
Enabling NULL and EMPTY Filters
By default, NULL filters (is null & is not null) and EMPTY filters (is empty & is not empty) are hidden. If you wish to filter out either of these explicitly, you can enable Show NULL and EMPTY Filter in Project settings.
Before enabling Show NULL and EMPTY Filter:
Once enabled, you can use the is null & is empty filters to filter out cells with NULL or EMPTY values.
Alternatively, you can use Blank filters to filter out cells with NULL or EMPTY values.