1

Hi all
is it possible (in visualization) to have two syncronized dropdown lists based on queries?
For example: list A shows some strings from a query. When I select an item, list B shows some results by query based on list A choice.

2 Likes
2

Not directly. The query that powers a Query Based Dropdown List Parameter cannot itself use parameters. But you can do the same thing with a Query Parameter and a Query Filter. Use the the parameter for dropdown A, and the filter for field B.

1 Like
3

Is there a documentation on how to use the output of a Query Parameter to another Query Parameter using a Query Filter?

4

It’s not documented because it’s an edge case. But the idea is straight forward.

Query 1 (any SQL data source)

SELECT * FROM table WHERE field = {{ param }}

Query 2 (via QRDS)

SELECT field as "field::filter" FROM query_1
1 Like
5

Hi, thanks for the idea.
But isn’t it possible to call the query which has the Query Parameter in it?

6

Nope. There’s no way to bubble up parameters between queries that way.