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.
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.