Dashboard parameter mapping: can't map different dropdown lists

[susodapop]

Issue Summary

I should be able to write a single dropdown list and map it to multiple queries on a dashboard. Similar to a query based dropdown list without the extra query.

Right now, queries with dropdown list parameters can be mapped together -- but values from one list are not inserted into other queries. The mapping appears to happen by list position instead of by value.

Is this a bug or a feature request? Please close it if I'm in the wrong place.

Steps to Reproduce

1. Write a query that uses a dropdown list parameter.

SELECT '{{ param }}';

Use the values Foo and Bar

2. Write a second query that uses a dropdown list parameter.

SELECT '{{ param }}';

Use the values Happy and Querying

3. Add both queries to a dashboard and map them to the same dashboard parameter

Observe that you cannot map the parameters so that both queries return the same string of Foo, Bar, Happy, or Querying.

You can make this work with a query based dropdown list. But that isn't as convenient if the values don't come from the database.

Technical details:

• Redash Version: V8 and V9
• Browser/OS: Firefox
• How did you install Redash: SaaS