Skip to Content
avatar image
Former Member

Approval Query based on Department

Hello Experts!

I'm currently creating a query for my Approval Template that will be dependent on the Department (Dimension 2) entered by the user on the Purchase Request document.

Per department will run through a separate Approval Template. Initially I have created a query for Department 201 but it doesn't seem to work. What am I missing in the query?

SELECT DISTINCT 'TRUE' FROM OPRQ A INNER JOIN PRQ1 B ON A.DocEntry = B.DocEntry WHERE B.OcrCode2 = '201'

Would really appreciate your help, Experts. Thank you!

1.jpg (145.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 04, 2017 at 03:24 PM

    You should use

    SELECT 'TRUE' WHERE $[$38.COLUMNNUMBER.0] like '%;201%'

    - Please, check your column number and replace on the query.

    Add comment
    10|10000 characters needed characters exceeded