Support for nested drop downs is much needed!

[nakamurau1]

Discussed in https://github.com/getredash/redash/discussions/6744

^{Originally posted by **NielsKSchjoedt** February 5, 2024} _This is a copy of: https://discuss.redash.io/t/observable-query-based-dropdown-list/3229_ Redash is such a great tool 🎉 - however, one thing I really lack is nested query based drop downs. Basically the idea is, that if your database has two columns, say: `country, city` then those could be used to populate two nested drop downs. One for country, one for city. However currently, that is not possible because the queries powering drop downs cannot interdepend:  **Example of what we need** You could have a query like: ```sql SELECT DISTINCT country FROM my_db.my_table ORDER BY country ``` Then add a "Query Based Drop Down" with those countries Then use the selected variable in another drop down query for city: ```sql SELECT DISTINCT city FROM my_db.my_table WHERE country = '{{country}}' ORDER BY city ``` It is such a pain this functionality does not exist 😬

[nakamurau1]

@arikfr Hello,

I would like to get your advice on the following proposal.

📡 API

My proposal is to create a POST: /api/queries//dropdowns/ endpoint with similar functionality to POST: /api/queries//results.

💻 Frontend

I plan to add a new query parameter type called “Dynamic Query Dropdown.” When other parameters in the Dashboard or within the query change, this API will be called to update the dropdown content accordingly.

Are there any issues or concerns with this approach?

Thank you for your guidance! 🙏

[nakamurau1]

Hi @justinclift,

I recently opened this issue (#7052) about adding support for nested query-based dropdowns in Redash. Could you take a look and provide any feedback or suggestions?

Thanks, @nakamurau1

[gaecoli]

Maybe you want to use xx.country and xx.city? And that just show one parameter xx?