Skip to Content
0
Former Member
Jan 23, 2013 at 02:40 AM

Query for Authorization

18 Views

Hi Experts,

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.

Regards,

Lean