We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Mapping manager using USERKEY is not working rather with USERNAME its working

Diptansu1
Regular Contributor
Regular Contributor

Hello , 

We had one requirement to map users manager with email id field provided while doing flatfile import .

Using below preprocessor JSON it is working :

UPDATE NEWUSERDATA SET NEWUSERDATA.MANAGER=(select CURRENTUSERS.USERNAME from CURRENTUSERS where CURRENTUSERS.EMAIL=NEWUSERDATA.MANAGER)

Need to understand why it is so ?

e.g.

SET MANAGER=CURRENTUSERS.USERKEY ( not working )

SET MANAGER= CURRENTUSERS.USERNAME (working)

From the user table we can see manager field holds only integer (i.e. userkey value) then ideally first logic should have worked . But it is not working . Please suggest .

2 REPLIES 2

rushikeshvartak
All-Star
All-Star

Saviynt internally correlated manager key when user name is provided


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

dgandhi
All-Star
All-Star

Manager field of users table holds the userkey of the username.

Thanks

Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.