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?