Hi everyone!
So, the problem is: I’m creating a variable that selects ids from PostgreSQL table
I don’t want it to be displayed as dropdown or whatever, I just want it to store all the ids from database, so it will be hidden. I wanna display all the ids in the dashboard panel.
For example, I use json api as a datasource (actually it doesn’t really matter, I also tried infinity plugin - the same problem), I write $variable to jsonata
and get only the first record in response
So, my question is how do I get all the data from a variable?
Show variable, select “all” value for that variable in the UI, hide variable, save dashboard - save also variable values
1 Like