Grafana: how to use variable in sql query

Question

How I can use variable in sql query at Grafana? I have variable robot but I do not know how I can use it in sql query. My query:

SELECT 
  datetime AS "time",
  api_robot.name AS "robot name",
  api_task.name AS "task name",
  api_status.name AS "task status"
FROM api_robotlog, api_robot, api_status, api_task
WHERE 
    -- api_robot.name = {$robot}
   api_robotlog.robot_id = api_robot.id
  AND api_robotlog.task_id = api_task.id

I try add some clauses at WHERE like: api_robot.name = {$robot} api_robot.name = ${robot} But when I use it, I do not receive any data. Any idea?

Jan Garaj · Accepted Answer · 2022-06-01 11:26:49Z

4

Use Grafana variable syntax, which will generate correct SQL condition, e.g.:

api_robot.name = $robot

You may also need advance variable format options, e.g.:

api_robot.name = '${robot:raw}'

answered Jun 1, 2022 at 11:26

Jan Garaj

29k3 gold badges49 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

sosnus Over a year ago

thank You! 2nd case (with {} and '') working!

Collectives™ on Stack Overflow

Grafana: how to use variable in sql query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related