Query Approval -Series Wise

[msundararaja_perumal]

Dear All

I am facing a issue in the approval scenairo in PO

Series created are AI10,TI10,AM10

Now i ve created approval template with doctotal-inrange 10000-20000 series wise

and in the query in i ve given query as

select distinct 'true' from where t0.series =70

But im getting approval template authorization for all the 3 series

ex if AI10 series is chosen in PO the approval template for TI10 and AM10 also appears.

Can any one give solution for the above so that only one approval template will be triggered

[Former Member · Accepted solution]

You may try:

select distinct 'True' from opor t0 where t0.series=70 and

$[opor.doctotal.number\]>=10000 and $[opor.doctotal.number\]<=20000

[msundararaja_perumal]

Chintesh Soni and Niladri Bhusan,

I tried like this

select distinct 'True' from opor t0 where t0.series=70 and $[opor.doctotal]>=10000 and $[opor.doctotal]<=20000

what went wrong in the above query

Gordan,

If i use query approval along with built in terms,both are functioning

[Former Member]

Your question is not very clear. How many query approval templates have you created? If it is user defined query approval, the built in terms would not be functional at all.

Thanks,

Gordon

[Former Member]

Hi,

I have already done this process kindly paste the detail query enable me to rectify it.

regards,

Niladri Bhuasan Harichandan

[Former Member]

i think you need to write the condition of doctotal-inrange 10000-20000 at Query side.

Means you need to define at Select Distinct clause