Requestor's manager in workflow

[km]

Hi,

We have a requirement to send the approval to requestor's manager. We can do it via custom query in Workflows but how to fetch the requestor's manager so that the approval can be sent.

Thanks!

[ejeong]

Tried like this 

select u.manager as userkey from users u where u.username = '${requestedby.username}'

[rushikeshvartak · Accepted solution]

select manager as userkey from users where userkey =${ARSREQUEST.requestor}

[rushikeshvartak]

@km Does above solution worked if yes you can mark working solution as accepted 🙂 

[km]

@rushikeshvartak : For requestee's manager i used 

select manager as userkey from users where userkey =${ARSREQUEST.requestee} and it didnt seem to work. 

When a user selects "Request Access for Others", in that case the requestor is someone else (requestee) and the approval should go to their manager.  Any ideas?