Using Grafana Global Variables

[yanhan92]

Hi,

I am trying to test some simple queries using this plugin and running into some difficulty in accessing global variables in the sql.

For example, when i try:
SELECT count(code) FROM "dw_diff-test" where __time >= TIMESTAMP '2021-08-10'
I get a result as expected:

However, when i replace the timestamp with a global variable like:
SELECT count(code) as C FROM "dw_diff-test" where __time >= TIMESTAMP '${__from:date}'
or
SELECT count(code) as C FROM "dw_diff-test" where __time >= TIMESTAMP ${__from:date}
or
SELECT count(code) as C FROM "dw_diff-test" where __time >= ${__from:date}

I get an error:

In the query inspector, i see that the variable has not been replaced in the query (not sure if it should be):

May i know what am i doing wrong here?

[jermudgeon]

I'm having similar difficulties. I'm going to resort to inspecting the query in druid logs as I don't see a way to get a dump of the query with substitutions.

[jbguerraz]

Hello mates,

You need to wrap the variable with simple quotes: __time >= '${__from:date}' AND __time <= '${__to:date}'
Also you can get a dump of the query by looking at data.queries[0].builder.query

Hope it helps :)

Note: this relates to #98 (any contribution is welcome!)

[yanhan92]

Hi @jbguerraz,

Thank you for your reply. I tried what you suggested but i see that the time mapped into the SQL command is different from what it actually is.

Seems like a strange issue. Is it just me doing something silly?

p.s. i just refreshed the query inspector again and the sql still looks the same

Thank you.

Yan Han

[jbguerraz]

Hello @yanhan92 👋
Interesting issue!! I've asked the Grafana mates since I don't understand this issue: https://grafana.slack.com/archives/C3HJV5PNE/p1632834011084200
Basically, the templateSrv service provided by Grafana won't replace time range variables properly when in explore (but it's ok in dashboards).
I'll keep you posted!

[yanhan92]

Hey,

Thank you for your help. Ill try it with dashboards.