Cascading variables that all react to eachother

Grafana Dashboards
1

I am looking to make multiple variables that all react to each other so a user of the dashboard can select any of the variables, and the others will automatically fill in with the corresponding values.

It’s pretty easy to make a variable react to another one. For example:
If you choose an email in the variable “email,” then the variable “User_ID” should auto-fill with the user_id that belongs to the user with that email.

But the part I can’t figure out is how to make it work both ways—so that not only “User_ID” reacts to “email,” but “email” also reacts to “User_ID.”

This might just be impossible, and I know that I could also just do something like:

WHERE email = ${email} OR ' ' AND User_ID = ${User_ID} OR ' '

in my query, but the problem would be if the user is dumb enough to fill in two variables and the data they put in the two variables doesn’t correspond with each other, then the queries in my panels won’t find anything because there is no data where that User_ID and that email correspond

2

IMHO it doesn’t seem to be good idea from the UX point of view. Why you don’t use key/value variable? For example (this is not copy&paste example which will work with any datasource type, just idea how it may work with MySQL datasource - it may need syntax/functional improvements):

SELECT 
  email AS __text,
  User_ID AS __value
FROM table
WHERE 
  email LIKE "%${input}%" OR User_ID LIKE "%${input}%"
3

Hi, great suggestion!
i got something working that work pretty good, i just wish that it would have a dropdown with autocomplete that other variable get.