Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Reroute Access Add Workflow to manager of the manager

ray
Regular Contributor
Regular Contributor

Hello, I want to send the request to the manager of the manager if the first manager is inactive.

I put this workflow below and when i test it, when the first manager is inactive, the approval request is going to admin admin instead of the manager of the manager.

 

anyone can help please?

ray_0-1712836939662.png

in the custom assignment :  (in the data analyzer i am getting the correcte userkey for the manager of the manager)
SELECT userkey AS userkey_managerN2
FROM users
WHERE userkey = (
SELECT u3.userkey
FROM users AS u1
JOIN users AS u2 ON u1.manager = u2.userkey
JOIN users AS u3 ON u2.manager = u3.userkey
WHERE u1.username = '${users.username}'
)

thanks in advance,

Ray

1 REPLY 1

rushikeshvartak
All-Star
All-Star

SELECT u3.userkey
FROM users AS u1
JOIN users AS u2 ON u1.manager = u2.userkey
JOIN users AS u3 ON u2.manager = u3.userkey
WHERE u1.username = '${users.username}'


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.