Request Roles Query To Filter Roles Based on Requestee / Requestor Accounts

[narendranegi]

Hi

can anyone please suggest a way to filter role based on accounts presence?

For Example:

If user has account in an endpoint assume endpointkey=95, then show the firefighter role(XYZ).

also, can we use Requestee in the filter rather then currentUser?

Regards

Narendra Negi

[rushikeshvartak]

You can use requestor ${requestor}

Sample query 

and
( substring_index (rl.customproperty1,',',1) = (select users.departmentname from Users users where users.id={requestor} ) or (substring_index(substring_index (rl.customproperty1,',',2),',',-1)=(select users.departmentname from Users users where users.id={requestor} )) or (substring_index(substring_index (rl.customproperty1,',',3),',',-1)=(select users.departmentname from Users users where users.id={requestor} ))
)

https://forums.saviynt.com/t5/identity-governance/request-roles-query/m-p/59933#M36839