Automatic Approve process problem with sql query

[former_member788827]

Dear Gurus

I have created "PO Test 1" custom approve process and now I am trying to create SQL Query at SAP Business one.

SELECT DISTINCT 'TRUE'  from OPOR WHERE ($[$22.3.Number]) = 5 

When the the Total Payment due (highlighted field) is equal to 5, the approval process work as expected.

However, we need to find a way for approval process to work with the condition when Project field (in red rectangle) is equal to "T12345".

SELECT DISTINCT 'TRUE'  from POR1 WHERE ($[$22.3.Project]) = 'T12345' 

Can you please guide us through the process.

[dineshsakthivadivel]

If the Project comes in multiple line, you will need to change '=' to 'IN' condition.