cancel
Showing results for 
Search instead for 
Did you mean: 

Query Approval -Series Wise

msundararaja_perumal
Active Contributor
0 Kudos
262

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

View Entire Topic
msundararaja_perumal
Active Contributor
0 Kudos

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