I created a process variable. Now I want to run an SQL and assign that value to this process variable. How to do this?

Follow

Rakesh Burde

• January 16, 2020 05:34

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.

0

• 

  Alexey Shmelkin (sysberry-absc.com)

  • January 16, 2020 09:39

  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

  0

  Comment actions Permalink
• 

  Rakesh Burde

  • January 16, 2020 13:29
  • Edited

  I am able to assign it by "query record" activity.
  Thanks

  0

  Comment actions Permalink

Please sign in to leave a comment.