Apply a!queryLogicalExpression() on a datasubset

I have one question why are you not applying a!queryLogicalExpression while you are fetching datasubset?

I have a scenario, where I need to filter the datasubset based on various user inputs. I am loading the data only when refresh was requested and do not want hit db every time user changes his filter.

I have not done this before but you can use function like find() ,where() and remove(), to remove specific rows from your datasubset.data when user select some specific filters. But i am not sure about it, you can try this out.

This is possible, but best practice is to let database do this work as it is way more optimized to do that. But in case you only have very small amount of data this can be an option.

It's better to make another query and get the filtered datasubset per user applied filter. It's not too big an operation for DB to handle. Still, if you don't want to fire queries then you may do a wherecontains() and then save off matching records in a different variable of same type.

Yes and it is not a good practice to hold huge amount of data in the memory and perform operations on that. So its best to get the data every time from the DB if you are dealing with huge amount of data.

We are not dealing with huge amount of data. But call to db is bit expensive in my case, as it happens through service every time.

Thank you all for the inputs.

If you want to allow paging to operate independently of the filters, you could have each of the filters in their saveInto redo the query with filters applied.

You could then use todatasubset() to configure paging so that you do not have to go through the expensive WS call every time.

forum.appian.com/.../Scripting_Functions.html