We need to use query parameters in multiple data sources via the respective query results. At the moment our queries aren’t optimized because we have no context as to the parameters coming through in the parent query so we need to pull an entire data set.
Is it possible to pass a query parameter from a parent query into the query results?
Here is an example:
SELECT * FROM query_70 as user_details LEFT JOIN query_80(pass in query paramters here) as activity ON activity.user_id = user_details.id
Here is another topic (Thoughts on adding support for queries with parameters in query results data source - #19 by Tim) which supports this feature if it exists?