Hi all, i’m on Grafana v10.2.0 with the data manipulation plugin made by Volkovlabs @mikhailvolkov . I’m trying to insert the results from a query inside a form that have a cell with a “select with custom options”. I would like to figure out how to avoid entering all the acronyms of the provinces …

i solved it, @mikhailvolkov @yosiasz thank you so much for the help :partying_face:, always very gently. this community is great! with the new plugin 3.7: [image]

hi guys, have you ani solutions?

Can’t you use a variable to get all the acronyms?

where should I enter this query? [image]

Well is that prov comune data saved in a database? Or is it in csv or excel file

yes it is saved into a mysql db

Check this to find where to put it [image] Add and manage variables | Grafana documentation Learn about the types of variables you can add to dashboards and how

I know how to use $_variables on grafana, but, do you think we can add the variable somewhere in the data manipulation plugin? if so where? this documentation doesn’t treat this plugin

then this might help Variables | Volkov Labs Dashboard and global variables are replaced automatically in the following elements:

@yosiasz @mikhailvolkov i’m trying to do my best following the guide but in this plugin there aren’t some options like this. This is my plugin: [image] this is the guide plugin: [image] there isn’t the options source option in my plugin, but it’s the same

Insert values from a SELECT query result inside a select with custom options form

Grafana MySQL

yosiasz April 2, 2024, 12:12pm 4

select prov as __value, comune as __text from prov_comune_table

Key-Value Variable Displays Key Before Interacting with the Variable

Topic		Replies	Views
How to use one variable value as a result for another variable input in Grafana? Configuration	7	36774	February 20, 2020
Using query results as a select option to generate new query for my backend datasource plugin Grafana Plugin Development api , plugins , query-help	5	1882	March 29, 2023
Key -> value style for custom template variable configuration and usage MySQL	15	20556	October 27, 2020
Using Variables to dynamically select Columns in MySQL Grafana templating	12	12253	July 5, 2023
Assign one variable to another Grafana	3	691	February 4, 2020

Insert values from a SELECT query result inside a select with custom options form

Related topics