Offline Data
Application Type


For one screen user has to put in several conditions based on this a filtered list of actionable items needs to be displayed.

Expectation -

We are currently using SQL action for above, but one of the requirement id of this application should be enabled in offline mode as well , wherein SQL will not be available .

Since input to this actions is a group of strings we cannot use aggregates

Any help will be appreciated 


I suggest that you can use aggregate and use ListFilter to filter the aggregate's result base on user input.

OR as you mentioned about input is group of strings, is it possible to format the input as ";str1;str2;"? If so, you can keep using aggregate with filter: inputFilter like "%;" + {Entity}.[Attribute] + ";%".

Hope this helps.


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.