I would like to ask help to create a query for authorization, I have two approver which will aprrove inventory documents that will be triggered when satifies the query if the item is set to property 20 it will be approve by approver B if not the approver A will be the approver.
Here's my query for approver B: for approver template B
SELECT CASE WHEN Qrygroup20='Y' THEN 'TRUE' ELSE 'FALSE' END
and for approver A: for approver tempale A
SELECT CASE WHEN Qrygroup20='N' THEN 'TRUE' ELSE 'FALSE' END
But it doesn't work.