LF best practice. How can I work with matrix result from SQL Query action?
Example.
A have SQL action in my workflow. As result of query I have matrix.
| City | User | Total Activity |
|---|---|---|
| Moscow | Ivanov | 5 |
| Moscow | Petrov | 1 |
| St. Petersburg | Sidorov | 4 |
Can I work with this matrix? Or I need make 3 Nintex Actions for each data type and work with 3 collections?
check documentation for the action http://help.nintex.com/en-US/nintex2013/help/#Workflow/RootCategory/Actions/Nintex.Workflow.ExecuteSQL.htm?Highlight=sql
since your query returns more then 1 column you have to check 'Specify column names' and it wil allow to specify a collection variable for each column.
then you will have to use 'For each loop' action to loop through collection(s) to process data.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.