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	4610	September 29, 2020
Links - Column value as a variable in a link	2	427	May 30, 2019
How to use one variable value as a result for another variable input in Grafana? Configuration	7	36308	February 20, 2020
Help with templating variables in MySQL MySQL templating , mysql	2	645	July 31, 2018
How to use template variable in another dashboard mysql query MySQL mysql	8	3805	June 15, 2018

Mysql variables

Related topics