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 Giobis over 11 years ago

Yes I understand. But the problem is that I need a where condition only IF a Process variable isn't null.

This works
Select a, b from table where a=ac! Value1

Now if the pv! Value1 isn't null I need to add, in the previous query, this condition:

And date_format (b,....) between xxxx and yyyyy

How I can do this?

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Giobis over 11 years ago

Yes I understand. But the problem is that I need a where condition only IF a Process variable isn't null.

This works
Select a, b from table where a=ac! Value1

Now if the pv! Value1 isn't null I need to add, in the previous query, this condition:

And date_format (b,....) between xxxx and yyyyy

How I can do this?

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data