1
0
-1

Hello,

I have a problem in retrieving workflow variable from the submitted form to use in Database Update Tool query. In my scenario, I have a process which after I submit a form, if approvalStatus == 'Verified', Database will be updated. I want to take the value of approvalStatus to save in updating db. 

I try using this #variable.approvalStatus# but got error : Invalid column name 'Verified'

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Hi, since the error says Invalid column name 'Verified', I believe the #variable.approvalStatus# hash variable is returning the correct value. Please ensure that you are using the hash variable correctly in your Database Update Tool SQL query.

        CommentAdd your comment...