CManaging Dynamic Product Filtering with ListView Checkboxes – Avoiding Circular References

App Building
,
1

Hi all,

I’m working on a Retool app where I’m displaying data from a SQL table called laptops. The table includes features like brand, ram, harddisk, etc., each with multiple choices (e.g., brand options: HP, Asus; ram options: 4GB, 8GB; harddisk options: 1TB HD, etc.).

I’m using a ListView with multiple checkboxes for each feature. The main label shows the feature name (e.g., "RAM"), and each checkbox displays the feature values alongside the count of products for each (e.g., "4GB (15 products)"). When the user selects values, the product count should decrease dynamically, reflecting narrower filtering as he selects more options.

However, I’m running into circular reference issues no matter what approach I take. Has anyone faced this problem successfully, or have any suggestions on handling dynamic filtering without triggering these circular references?

Any advice would be much appreciated!

Thanks!

2

Hello @ziouzitsou!

There should be a way to dynamically filter your table based on which items in a ListView component have been checked.

We will just have to apply multiple filters on the table for each filter that the user has specified.

If you can share screenshots on your current setup, I can look to reproduce the functionality or see if there is anything I can change to work around the circular reference issues.

How many column values are you looking to be able to filter the rows of the table by?

Also we have a built in Filter component that might be worth checking out and playing around with.

Also check out the Column Sort Mode that comes built in with the table. You might be able to pass logic from the list view into this to achieve the functionality you are looking for.