This post suggests adding an "additionalScope" input field to the Control Query GUI.
This seems to have been implemented in some way
if additionalScope is defined in the SQL Mode of the query.
Why not add the option to define additionalScope in the GUI Mode as well? Right now it works if you define it in SQL Mode and then swap to the GUI Mode, but this behaviour seems unintuitive and confusing.
+1 on this - I've often found myself using "Run Script" as I need to pass additional scope but then maintaining code and reviewing changes becomes harder
+1 omg I never thought of setting it in SQL mode then just switching back, I've always wondered why it was missing though! thanks for the workaround!!!!
+1 here as well. I attempted going the route of adding an additionalScope in SQL mode of my delete method in one of our Retool apps, yet upon saving and switching back to GUI mode, it still appears as undefined (even though my logs and actual delete method are working just fine).
It would be nice to see the app recognizing the variable that I'm passing as an additionalScope.