The project I am developing has multiple screens that use the same base query but filter it based upon a variable(s) specific to the screen (Used in the where statement).
I thought about using a dataset tag for the base query and then trying to run a query off the tag. This would greatly reduce the number of queries hitting the database connection.
I have looked at the lookup function but this only returns one object.
Is it possible to grab a subset of a dataset tag?