Retrieve a subset of a dataset tag

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?

Yes, with the help of the Simulation Aids module, available here. You would use the view() expression function to reduce one dataset into another using its pseudo-SQL syntax.

thank you for your help. I attempted to download it but unfortunately the download link isnt working (states the page cannot be found). I have emailed their support for a resolution. As soon as I can get it downloaded and tested, I will mark this as complete.

[quote=“Lonewulfe”]I attempted to download it but unfortunately the download link isnt working (states the page cannot be found). I have emailed their support for a resolution.[/quote]That would be me. (-: Link fixed.