Hi,
1) Can you please open another topic if this question is not linked to this topic ?
2) You have several solutions
a. SQLToParameters
You can use the SQLToParameter action that is designed for that.
It creates process parameters from SQL requests, but your request must return only one column/one row
So you'll need to do multiple requests.
Example:
For more information, please refer to the documentation of the action, that can be found in the designer or here:
stambia.org/di-stbar
b. SQL Operation and Scripting Action
You can bind the result of the SQL Operation to use the values, like explained in this article:
stambia.org/doc/104-process/actions/sql/...-and-sql-action-type
To publish variables from the bind result, you can use a scripting action with the following context function:
__ctx__.publishVariable("variablePath","variableValue");
Example:
The advantage of this solution is that you execute the query only once
Does this help ?
