Hi Guys,
I have a problem to define multiple filters. In my App I defined if a field is selected by a checkbox.
now I want to filter another table by this option
Is there a way to "tell" the App to filter only by selected countries of query 1? The only idea I have is to set up a new attribute in the Database like "isSelected". But I don´t want to run a server call ervery time I select something. As I design the App as a PWA it shall also run offline.
Thanks for your help!
Tobias
Hi Tobias,
You won't be able to easily do that kind of filtering using an Aggregate, as there's no way of representing "value of attribute is in set of selected values". For this typically you'd use a SQL tool with an IN clause, and you would use the BuildSafe_InClauseIntegerList (for instance) as explained here.
Building your application as a PWA means that for it to work offline it cannot rely on server queries (including the database aggregates you are using). You need to rely on Local Storage Entities and local storage aggregates (icon will be a hollow version of the database aggregates).
The problem here is that there's no SQL tool client-side, so the alternative approach would be for you to do it via logic and possibly system functions that manipulate Lists like ListFilter (you can see here a simple explanation on how to use it).
Hope this helps!