Support for nested drop downs is much needed!

[nakamurau1]

trafficstars

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:

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:

SELECT DISTINCT city
FROM my_db.my_table 
WHERE country = '{{country}}'
ORDER BY city

It is such a pain this functionality does not exist 😬