Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/21/2024 06:21 AM
Hello,
I'm trying to find a way to assign the "ROLE_ENDUSER" SAV role for users who are active and do not currently have that role.
This is what I was trying eariler.
Advanced config:
u.id IN (SELECT u.id FROM Users u WHERE u.statuskey = 1 AND u.id NOT IN (SELECT ur.userkey FROM user_savroles ur WHERE ur.rolekey = 'ROLE_EndUser'));
Could you cross check where I'm missing out on.
Thanks,
10/21/2024 06:45 AM
10/21/2024 07:27 AM
Hi @rushikeshvartak
We are looking to assign the role for re-hires in this case.
10/21/2024 07:29 AM
But user is already exists isn't it ?
10/21/2024 07:41 AM
@rushikeshvartak Yes,
Got your point,
Could you share the query for this? "users who are active and do not currently have "ROLE_ENDUSER" SAV role, so that it only filters out the users who do not have the particular sav role. ( we have a user update rule in place which checks on the status, and will call the technical rule if the user gets active.)
Another related question,
In the case of only using something like this,
if the user already has it, does the task get created?
10/21/2024 07:44 AM