We are trying to get multiple values from a MYSQL query and we would like to assign these multiple values to multiple channels on the same sensor. The way we have it working for now is that we run multiple queries and we assign each query result to a different sensor. That is putting extra load on our DB and it is not a scalable solution. Here is an example:
Select v1,v2,v3,v4,v5 from my_table;
It would be nice if we can run this inside one MYSQL sensor and assign these values to different channels in the sensor.
We have to go around and do the following:
Select v1 from my_table;
Assign the value to sensor 1
Select v2 from my_table;
Assign the value to sensor 2.
... and so on.
I hope my explanation is covering what we are trying to accomplish. Thank you.