Query-based dropdown not working

Issue Summary

Query-based dropdown not working.
Found an open ticket about that: Unable to execute Query Based Dropped Down List

Expected Behavior

Two queries use a ‘date-range’ parameter. One of these is using the returned rows from the other as a dropdown to choose from. These queries, placed on a dashboard, should use the same ‘date-range’ dashboard parameter.

Actual Behavior

Even though the query used for the dropdown finish running and returns rows, the query-based dropdown parameter doesn’t work. A status-500 error was in the console and attached under screenshots.




Technical details

  • Redash Version: 8.0.0+b32245 (a16f551e)
  • Browser/OS: Brave for Mac.
  • How did you install Redash: Company hosted.

Does the “Get measure names” query use a parameter?

It does, a date range parameter which serves as a dashboard parameter to control both queries.

Alright, that’s the issue.

A query can do exactly one of the following:

  • Use a query parameter in its query text
  • Be used to power a query based dropdown list

Your backing query, in other words, cannot use parameters. Because there’s no apparatus to pass parameter values from the parent query into the backing query’s execution.