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

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...

OriginalPostID-68190

OriginalPostID-68190