MYSQL Custom 'All' value for variables

,
1

Hi,
I am using MYSQL datasource (Grafana v5.2.0) and a query variable $sprint. I want to enable the “All” option so dashboard show All Sprint values. I want the values in “All” to be in the pipe format for example: Sprint 1| Sprint 2| Sprint 3
After reading the documentation, I am trying to pass a custom value like this: ${sprint:pipe}

image
image333×562 22.2 KB

However its not working for my graphs - the generated SQL shows this - when All is selected it is rendering the as is

image
image818×305 22.4 KB

Please advice what am I doing wrong.

3

nm, i found what i was doing wrong. I had to enter the variable formatted as ${var_name:pipe} in my query itself and not in the variable settings . its working now!!!