Approval query is not being triggered

[former_member277944]

Hello Experts,

Scenario: I would like to send my Sales Order in approval only when Business Partner "C00282" is selected in Sales Order. I am using the following query but approval is not being triggered:

SELECT DISTINCT 'TRUE' FROM ORDR Where $[ORDR.CardCode.0]= 'C00282'

help required !

Thanks & Regards,

[kothandaraman_nagarajan]

Hi,

Try this:

SELECT distinct 'true' FROM ORDR T0 WHERE $[$4.0.0] = 'C00282'

OR

SELECT distinct 'true' FROM ORDR T0 WHERE $[ORDR.cardcode] = 'C00282'

Thanks & Regards,

Nagarajan

[former_member277944]

Thanks for reply, I have tried the query that you mentioned but it doesn't work.

I have even tried by just writing the following in query and save it but still the approval is not being triggered.

SELECT 'true'

[kothandaraman_nagarajan]

Hi,

The above query is working for me. How did you assign above query in approval template?

Thanks & Regards,

Nagarajan

[former_member277944]

I have tried the same template by selecting the option: Launch Approval Procedure - > Always. It works fine. But when I try the option When the Following Applies, and select the query (see pic below), it does not work.

[kothandaraman_nagarajan]

Hi,

Please post your query here.

Thanks & Regards,

Nagarajan