Refresh Query Based Dropdown List with parent query

gittinitian · June 13, 2018, 6:26pm

I have a Query Based Dropdown List that uses a query with a global parameter and a parent query that shares the same global param. I’d like the dropdown query to refresh as appropriate (both when it’s global param changes, and if you refresh the parent query).

Initial load:

Note that I don’t actually want to have the FILTER_CampaignID query on the dashboard. It was just there illustrating that the results were changing correctly, but not updating in the dropdown list.

This was asked about in the following comment in the original PR:

github.com/getredash/redash

Feature/query based parameter

getredash:master ← rohithmenon:feature/query_based_parameter

opened 04:18PM - 14 Aug 17 UTC

rohithmenon

+101 -1

Feature: Query based parameter (drop-down) ================================= T…he feature is useful for our use-cases where parameters tend to be dynamic and comes from other queries. We have couple of use-cases where we will need such support. This is a feature available in a comparable product offering from Mode analytics (https://help.modeanalytics.com/articles/using-dynamic-parameters/). The implementation is basically to use a saved query within redash as a parameter. Restriction for this query is that only first column will be used for options of the parameter and it must of a string format. By using saved queries for parameter, we get all the goodies of redash queries (caching, refreshing etc.)

Thanks for your consideration.

gittinitian · June 13, 2018, 6:27pm

After changing global param and refreshing:

arikfr · June 20, 2018, 7:41am

The “Query Based Dropdown” doesn’t support parameters.

faelon · June 20, 2018, 2:43pm

Isn’t that why it’s posted here as a feature request?

▼Categories

▼Tags

Refresh Query Based Dropdown List with parent query