Insert variable by User

fra · July 17, 2017, 7:50am

Hi all!
I try to explain my aim/issue…
I have a MySQL database filled by a Visual Basic application; in this database I have a column where I store a number that represents an “index number” of…(is not important of what… )
Then I plot database with Grafana.
My idea is that User can insert into Grafana panel his interesting index number and Grafana shows only the data with the matching index.
Grafana query is simply: SELECT “Column 1”, “Column 2” from “Table” where “Column 1” is not null and “IndexNumber” = "Variable"
My issue is how insert that “Variable”…
Somebody can help me? How can I do to do insert a value from User into Grafana panel?
Thanks!!!

fra · July 17, 2017, 1:03pm

Solved :
Created a new table where I write by Visual Basic the Index Nmber and in Grafana query I write:

SELECT “Column 1”, “Column 2”, “Index” from “Table”, “TableIndex” where “Column 1” is not null and “Index” = “Column 2”