Variables in SQL Requests

[GHirsch (Guilherme Hirsch)]

Hey guys!
Congratulations on developing this amazing tool.
I have a question about using SQL Request in a workflow. How do I reference a variable in an SQL Request?

[Quentin (Quentin Durantay)]

Hey @GHirsch

At the moment, you have to consider your SQL query like a string and use a concatenate function to use variables inside a query.

Small example here:

Hope this helps!

PS: we know this user experience is not ideal, so we’ll love to have your feedback on how to improve it

[GHirsch (Guilherme Hirsch)]

Thanks a lot for the help!

When a sql request is selected in actions, one more option appears in the list, along with formula and javascript. Being able to reference the variables.

[Quentin (Quentin Durantay)]

Hey @GHirsch,

Not sure to understand what you mean here

[GHirsch (Guilherme Hirsch)]

It is a suggestion to include sql without having to use concatenation.

[Joyce]

Nice! I’ve added your suggestion to our user research