Hi you all, I need to use a Query DB with more "where" variable

Giobis over 11 years ago

Hi you all,
I need to use a Query DB with more "where" variable... In the Setup Tab I tried to force a node variable but it doesn't works.
The Query that I used is:

SELECT count(purchaserequisition.prno) as prno FROM purchaserequisition,pritem WHERE pritem.prchasereqisition_item_prno=purchaserequisition.prno AND purchaserequisition.plant=ac!plantId ac!OtherAndValue

So in the ac!OtherAndvalue there are others process variable that i send to this query BUT it doesn't works.

Any suggestion for solving this doubt?

Thanks...

Discussion posts and replies are publicly visible

Parents

0 Eduardo Fuentes
Appian Employee
over 11 years ago

The acp's were designed to hold values of parameters of you query but they won't work to hold a whole string that itself is another query/operator/statement or the rest of the query/operator/statement. You can use acp's to make your inputs parameters in the query but not to hold the string of the statement itself.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Eduardo Fuentes
Appian Employee
over 11 years ago

The acp's were designed to hold values of parameters of you query but they won't work to hold a whole string that itself is another query/operator/statement or the rest of the query/operator/statement. You can use acp's to make your inputs parameters in the query but not to hold the string of the statement itself.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data