Dynamic filter

The Dynamic Filter component is a powerful tool that allows you to filter data from your Data Provider's data set. This is accessible in both Data View and Design View, making it highly versatile for customising your Budibase app to display relevant data effectively.

Data view

You can no longer apply filters to the base table. Instead, you must create a view to apply filters to. To help you quickly locate specific data, the Data View in your Budibase app includes a Filter button at the top right of each view. Clicking this button opens the Dynamic Filter, allowing you to apply advanced filtering criteria to data within your views for faster, more targeted access.

Adding and Configuring Filters

To add a filter, click the Add Filter button. This will open a context menu, allowing you to customise your filters to display your data. The settings within this context menu are as follows;

Initial Group Setting: Select whether to display data matching all or any of the filter groups you create. Choosing all will apply an AND condition between groups, while any will apply an OR condition.
Adding Filter Groups: Click Add filter group to create multiple groups, each with its own criteria. This setup allows you to build complex filtering logic for refined results.
Group-level Matching: Inside each group, choose whether to match all filters or any filters within that group, giving you control over AND/OR conditions within each specific group.
Empty Filter Option: A new setting lets you decide how to display data when no filters are applied. If filters are empty, you can choose to display all rows or none, allowing for greater control over initial view settings.

Filters

In each filter, you can define the conditions that data must meet to appear in the results. Each filter has three configurable fields:

Column: Choose the column you wish to filter.
Operator: Select the appropriate operator (e.g., equals, contains)
The last input field is the value you search against. (An example of this in action can be seen in the gif below.)

Design view

The Dynamic Filter component functions the same way in Design View as in Data View but offers additional flexibility when used alongside the Data Provider's component.

Quick setup process

Add a Card Block component and then eject it to enable customisation.
Add the Dynamic Filter as a child component within the Data Provider's component
Users can then configure the filters accordingly and pull out relevant information they require

This dynamic approach makes it easy to customise data display based on complex filtering conditions, whether working in Data View or Design View.