Dear One Data community,
I am trying to set multiple values in a variableConfigSingleSelect selector when picking an element of a drop-down menu, and to do that I am resorting to using the following SQL query from a data source. When the user picks an option from the drop-down menu, the value from the ‘value_column’ is then inserted into the following global variable:
` "sql": "SELECT CONCAT(plant_label, \" (\", system_label, \")\") as label_column, to_json(map('value', 1)) as value_column from inputTable"`
Now, I am trying to read the value
'value' contained in the value_column in another element of the page, but whenever trying to do that with the following command, I get a blank value.
However, when reading the whole variable’s content (not the single value element), the output is correctly displayed:
Q: Is there any way to read the value contained in the ‘g_global_var’ ‘value’ field?