1

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?

2

This feature has been requested a lot but it’s not supported yet.

1 Like