Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement 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 this 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.