Question & Answer > View Question

How to get workflow variable in Database Update Tool?

Confluence User - 28 Sep, 2018

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'

databaseupdatetool;workflow;variable;hash

1

Confluence User •

29 Sep, 2018 •

confluenceUser •

•

confluenceUser •

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.

1

CSV | Excel | XML | PDF

Your answer

Print

How to get workflow variable in Database Update Tool?

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

1.builder-style-8e683eda-ce52-476c-89b0-fdd057e008e6{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-8db10fe0-d7f6-47b6-8376-7af917b19cdc{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

1

Your answer