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

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Hey there, Laura!

     

    I thinking using our liquid parameters might help a lot in scenarios like this.

    You can read more about them here!

    Reply Like
Like Follow
  • Status Answered
  • 4 wk agoLast active
  • 1Replies
  • 23Views
  • 2 Following