I currently have a repeater connected to a dataset, itself connected to my database.
I want to be able to have 4 dropdowns enabling the users to filter the repeater by 4 different values, connected to columns in my database. I also want the users to be able to combine filters between the different dropdowns, thus allowing them for example to filter the repeater by Dropdown value 1 = X AND dropdown value 2
So far, I could only do this using 4 filters on my main dataset, one for each dropdown on the main dataset connected to the repeater but it litteraly takes 20 seconds for each change, which is way too long.
Is there a way to do it easily and make it faster ?