Mysql table : filter on several columns by values

Grafana MySQL
1

Hello

I see here MySQL | Grafana documentation that I can add a form field linked to my panel with __searchFilter
So I try this query :
SELECT ti, system_name, hypervisor_name FROM logicals WHERE function = 'database' and hypervisor_name like '$__searchFilter'
but it does not work
how can add a ‘hypervisor’ form field ?
ans system_name too ?

2

Do you have a dashboard variable for searching?

image

If you could share a screen shot

3

Thank you for you answer @yosiasz no and I woul like to have

image

4

ah gotcha. Which visualization plugin are you using there.
Ainsi?

image
image497×555 26.2 KB

5

Oh sorry @yosiasz I didn’t see that, yes the switch was off.
I can now filter all columns, so i remove the useless and hypervisor_name like '$__searchFilter'(without knowing its usage)
Thank you very much !

1 Like