If I've queried up some data, is there an easy way to filter that into smaller subsets without making new queries? For example if wanted a grid of 'all users', then I wanted second grid of all people with the first name 'John' and then a third grid of all the people with the last name 'Smith', is there a way to filter the data for the other 2 grids using the first grid's data? Or am I stuck making 3 different queries to the database? Would it be possible somehow to create local variables containing all three using a single query?
Discussion posts and replies are publicly visible
Use the index function: index() Function - Appian 21.4.
Common pattern would be combining this in the format index(data, wherecontains(), null) in order to only find the data in your set that meets there wherecontains() condition. You can create the subsequent indexes as local variables following the first local variable with the parent/top-level grid data.
This works, thanks!