two level workflow for role owner rank 1 and rank 2

[SwagatDas13]

Hello All,

We are setting up a workflow to be sent to role owner rank 1 first and then rank 2. What is the query we can use in custom query. Can anyone help on it.

select userkey from role_owners where rank = 1 and rolekey in (select distinct r.rolekey from roles r)

This doesn't work for me.

[rushikeshvartak · Accepted solution]

Rank 1

select userkey from role_owners where rolekey=${REQUESTACCESSOBJ.id} and rank in (1) 

select userkey from role_owners where rolekey=${REQUESTACCESSOBJ.id} and rank in (2)