Hi team,
We have the requirement to assign the one Sav role when new delegate has been created in the system and the user manager.
We have a custom query to assign the Sav role to the user for Delegate but the Custom query Job is no longer in the latest version. Can any one please help us how we can assign the Sav roles automatically to the users.
Custom Query:
INSERT INTO USER_SAVROLES(USERKEY,ROLEKEY) SELECT USERKEY,(select rolekey from savroles where ROLENAME='ROLE_CAMPAIGN_OWNER') FROM USERS where USERKEY in (select userkey from users where userkey in (select userkey from delegates) and userkey not in (select userkey from user_savroles where ROLEKEY in (select rolekey from savroles where ROLENAME='ROLE_CAMPAIGN_OWNER')}}}
Thank You,
Chakritha
