Using custom logic to return approvers in AME
We are using an 'Approver group' that uses a dynamic query for Purchase requisitions. The query reads our custom table and returns list of multiple approvers. The custom table contains list of approvers based on amount ranges and account code ranges. e.g. upto 10K approver 1, 10k to 20k approver 2, etc. If amount is between 10 k and 20 k, we want it to go to first approver 1 and then approver 2.
Our current query returns both approvers. The problem is we are unable to sequence them based on amount ranges. The sql in AME only allows to select one column (person_id) and sort by that. But we want to sort by Amount Ranges.