Reroute Access Add Workflow to manager of the manager

[ray]

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?

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

[rushikeshvartak · Accepted solution]

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}'