Re-using results of a query

I've looked and I can't find a way to do this, but maybe I'm missing something!

 

In my report, I have one somewhat complicated query that gives results that are then used in all the other queries (its a list of ids that then get used in all other queries)

At the moment ?I have to do that query in every query, to get the list of ids.

Is there any way to do a query then use the results of the query in other queries?

e.g.

select * from blah where id in {{ other_query.ids }}

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 3 mths agoLast active
  • 15Views
  • 1 Following