How to reference a parameter in a query?

Pokca

Hi, how can I reference a parameter in a query string in Action calling request of SQL DB integration?
Thanks :-)

Jan Pokorný (Adapptio)

Hi, the parameters are possible to reference with :<param-name>.

For example a parameter email can be referenced in SQL query as SELECT * FROM accounts WHERE email = :email;.
See, that no quotation marks are needed around the :email, because the parameters are sent as as string by default.