Allow for "Select" GUI

Although I think I may have addressed a similar or related topic before, I think having another option for "Selecting" in the list of Action Types (see screenshot below) would be useful.

Also, if that were to be available, one would be able to dynamically pass in a certain value, which cannot be done using native SQL (for good reasons, probably).

In the case of a GUI approach for "SELECT", I could imagine simply filtering if the given (dynamic) value exists and based on that, the value is used. This would mitigate any security issues, is my estimation.

As a result, queries would be able to run based on variables, rather than having to edit queries over and over again. Similar to how form fields work, I could imagine simply referring to the self.key and then adjusting the query name to be reflected as the table name.

Anyway, hope this helps. Thanks.

:wave:

Thanks for your feedback, @emozio! This feature is currently being considered and a ticket has been created.

1 Like