Filter component - Use select in values instead of free text

Following the product requirements we work on designing an app that will allow us to save customers configurations with complex filters engine. One of the requirements is to support nested filters with different OR/AND operators in different deep levels.

The best component that Retool has which responds to those complex requirements is the Filter component. It already has multiple filters and filter groups support with operators. We shouldn't present any data table to the user, it is kind of configuration he need to define and filter entities he doesn't need. Those entities still doesn't exist, it is real time entities, so we don't have table to present. Let's say, I can hide a table with all the mock data with all possible options for each column.

The main issue with it from the Design/Product perspective is that we have multiple entity types (10-12) and subtypes (~100). We don't expect the user to remember all those subtypes and write them manually in the values column. Is there a chance that to the Filter component will be added option to present values as a Select component instead of a free text input? Exactly like we have in the Filter when the type of column is Boolean (check the attached screenshot).

For example, in the demo table data you have Teams and Roles, that has array structure. Seems like it make be easily presented as a list of options in a dropdown list with single or multi-select. Is it something that may be added to the Filter component?

Hi @AbbeyHernandez I am also experiencing some complexity with the Filter component where I am attempting to maintain a connection with a data table but don't want to display all the columns in the Statement option. Is there a way of customizing that?

In addition, I am intrigued by how one could control the number of rules and groups, as my current scenario does not need a series of nested groups. As these groups are continuously be added and leads to a stage where API response will be empty.

Any insights or guidance on how to manage this efficiently would be gratefully appreciated. Thank you for your time and assistance.

Hi @MichaelT,

I can definitely make a feature request to add to the filter component a nested select/multiselect component. I thought it might already be an option but it appears that it isn't yet :sweat_smile:

@SalmanMaqbool Unfortunately Abbey moved over to the TAM team with Retool. You may need a separate community thread for your question about columns in the Statement option.

1 Like

@Jack_T oh, that's sounds great! It will be very helpful to have such functionality. Thank you!

1 Like