Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/24/2024 12:02 PM - edited 10/24/2024 12:03 PM
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.
Solved! Go to Solution.
10/24/2024 12:08 PM
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)