1
0
-1

I have designed a process with a simple rules decision and a Database update tool. The Rules decision will run a simple rule to compare the values of two variables and set the priority values as High or Low respectively. Following this the DB Update tool will set the current value of the Priority Workflow Variable to the DB Column.

After the process is executed though the workflow variables are getting the correct values (verified in monitoring section) the DB Update tool is not setting the value in the database.


Process Diagram:

My Query:

c_priority is the column which needs to be modified and c_TMSRefID is the unique id column to refer to the correct row


    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      Hi, what are the error messages in the logs? I believe you might be missing single quotes (') around the hash variables in your query. 

      1. gopinath

        Adding the quotes made my query work. Thank you anders.

      CommentAdd your comment...