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