Dropdowns empty on dashboard's initial import

Hi,

We have a Grafana dashboard that has a variable which is of type “query”. When we import this dashboard, we see the dropdown for the variable at the top of the window is empty. When we go and edit the variable and save without changing anything, we see the values are fetched and dropdown is filled.

For reference, we are using a Postgres data source with a query like this for the variable:

select distinct data->‘app’->>‘appId’ from mobileappmetrics;

Anyone seen this problem?

Grafana version is: Grafana v5.0.0-pre1 (commit: f1813ae3a)

Ok, found the missing part.

There is a “Refresh” field in the variable edit screen and selecting “On Time Range Change” fixed the problem.