I’ve been trying to figure this out, but not getting anywhere.
Redash 8
how do I set the Show Pivot Controls option in a visualization when configuring a query visualization via JSON? I can’t figure out the incantation. I assume there’s a boolean with a relatively simple name, but not finding it. Also, I can’t seem to figure out how setting the slider and saving the query registers in the database for persistency (which table), but that’s mostly secondary if I could use the JSON.
Digging through the code, it looks like it should be possible to something like this in the visualization json, but it doesn’t seem to be doing anything when I upload the query via json (but all of the other parameters are working, so it’s not a problem with the api in general)
“controls”: { “enabled”: false },
The easiest way to find this is to save the change in your browser and spy on the network request to see where the Redash front-end puts it. When I did this it appears the API expects the setting to appear in options.controls.enabled. But paradoxically, the boolean is flipped.
If you want the controls to disappear you need to set enabled=true.
If you want the controls to appear you need to set enabled=false.
Wow, weird. somehow I missed notification about this. thanks.