I am trying to build a dashboard or a low code app and I need a table with a filter depending on a column. I could do the grouping by the column but it creates a header which gets expanded or collapsed within the table but what I really need is to have a separate drop down menu to dynamically display the rows in the table.
I have tried using the drop down feed but it was not successful, not only because there was only the list feed that I could use but also I could not query the actual column values. Could someone please give an advice how I can make the table filtering works?
For example, I want to filter the below table with Manual Override Status column as a drop down (Main & Not found).
You can achieve this in multiple ways:
- You can rightclick the column header to filter on that column.
- You can add a query filter visualization (soft-launch), add your query to it and feed its query to the table.
- You could create a new query that queries the distinct values for your column. That query can be visualized in a component of your choice (mine is the grid), and its selection can be linked as a feed in your query for the table.
- You could link it to a free text feed in which you could search.