Filters/Finders in Collection
Allows you to apply customised filters in a collection to filter data entries.
The filter settings of a collection contain the following fields:
Filter Name
This field allows you to name the filter so you can easily recognise the created filter while applying it to a data table, group or list.
Sort By
This field allows you to choose the behaviour of a filter to sort items in a data table, group or list. Either you can choose the default options or create constants and apply them here to customise the sorting behaviour of a filter.
Private/Public
This checkbox allows you to either public or private.
Public: Makes the filter available for everyone to use.
Private: Makes the filter only available for the logged in users to use.
Order
This field allows to choose the order of the added filter, which could be either ascending or descending.
Filter
This field allows you to choose the type of filter you want to create.
Include
This field appears if you select Find One Record or Find All Records as the filter type in the Query field. Here, you can add a limitation of including the specific type of data.
Exclude
This field appears if you select Find One Record or Find All Records as the filter type in the Filter field. Here, you can add a limitation of excluding the specific type of data.
Condition
This field allows you to add an additional condition to the created filter. Know more
Accessing Collection Filter
To access filter settings, go to the Collection panel in the Left Toolbar of the builder and open the settings of the collection you want to add filters by clicking the settings icon. A dialogue box containing all setting options to modify the collection will open. Click on Filters and adjust the above-mentioned fields one by one.
Adding a Filter
To add a filter in a collection, go to the Collections panel and open the Filter settings of the collection in which you want to add a filter. Fill in the required fields and click the Create button.