I created a process variable. Now I want to run an SQL and assign that value to this process variable. How to do this?
I created a process variable. Now I want to run an SQL and assign that value to this process variable. How to do this?
I want to get the max id of a table and assign this value to the process variable.
I try to use the query record. But unable to understand how to make a query for that and assign value to a process variable.
-
Hi Rakesh,
Unfortunately you can't write SQL query in process modell. You could do this in forms, but not in process. Here you would need to create a stored procedure and use it to get value. You could also do that in form and assign the value to the for field and in process model assign this form field to process field.
Regards,
Alexey
Please sign in to leave a comment.
Comments
2 comments