How can I reference the value of a process variable in the sql statement in a Qu

geneb over 11 years ago

How can I reference the value of a process variable in the sql statement in a Query Database Task? I capture the value I want to use on a form in a User Input Task upstream of the Query Database Task. Here is the query:
select max(version_id) from versions where docnumber=(want to substitute value of processvariable here) it's an integer....

Discussion posts and replies are publicly visible

Parents

0 David Williams over 11 years ago

Try ...

select max(version_id) from versions where docnumber=ac!docNumber

This should then show on the inputs tab, and you can map a variable to it then.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 David Williams over 11 years ago

Try ...

select max(version_id) from versions where docnumber=ac!docNumber

This should then show on the inputs tab, and you can map a variable to it then.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data