I have a mysql database with different tables. Depending on the name of the parameter, I first need to lookup it’s ID. With this ID, I can then find the values in another table. For example, I want to get the values for parameter “OPPSM001”. To get these values, I need to look in table t_par_ref and…

select va.* from ( select param_id , gentime, value, 't_par_dbl ’ as t_raw from t_par_dbl union select param_id , gentime, value, ‘t_par_u16’ as t_raw from t_par_u16 ) va join t_par_ref ref on va.t_raw = ref.t_raw and va.param_id = ref.param_id WHERE ref.name = ‘OPPSM001’

Mysql variables

Grafana MySQL

stijnilsen February 17, 2025, 6:31pm 11

Some more info. Example of t_par_ref values:

Example of one of my tables (t_par_dbl):

Handling selection from 10k+ parameters

Topic		Replies	Views
Variables in MySQL MySQL templating , mysql	4	4702	September 29, 2020
Handling selection from 10k+ parameters Dashboards time-series , sql	10	142	March 2, 2025
Using Variables to dynamically select Columns in MySQL Grafana templating	12	12176	July 5, 2023
Table as variable Grafana	5	9279	January 27, 2022
Grafana mysql variable with multiple values Developers & API	0	1028	October 9, 2021

Mysql variables

Related topics