When Querying Existing Query Results -
Is there a way to have a parameters for the basic query before using it in the Query results (in order to make the basic query much lighter, to pull only relevant information in the first place)? In other words, the parameters that are shown in the Query results are for the basic query.
For example:
select *
from query_123 as a join query_456 as b on a.id = b.id
where a.date = {{date}}
– query ‘a’ pulls only the information for the specific date from activity_DB, but the parameter window is shown in the Query results page.
Thanks!