I am using a database query to generate a ListView.
Now, I have multiple DropDowns, which can be used to filter things. There are two issues I am facing:
I have a list of cities in the objects of the database, also, there is a list of cities in the multiselect DropDown. I only want to display objects, which have a selected city.
If I set up everything as I would think to be correct, I get an error: "you can use at most one in, not-in, or array-contains-any clause per query. you can't combine these operators in the same query."
So, if I cannot combine these filters, how can I achieve my goal?