How can we generate the full name of the user using the pre-existing firstname and lastname ?

[anujapawar]

How to generate any new attribute using the existing attribute values?

Ex: 1 . I need to generate the "display name" for John Doe as JohnD, how can we do this on saviynt ui?

Ex: 2 . Need to generate "full name" using the firstname and lastname which we have uploaded during csv file import. Also, I don't want to pass fullname as a column in csv file.

[Manu269]

@anujapawar refer this article for creating user via UI with DA usage

Configuring Create/Register User form in EIC - Saviynt Forums - 50744

[CR]

Below query fetch data and upload:

1.

select concat(u.firstname,substring(u.lastname,1,2)) as 'Displayname' from users where u.userkey=''

2.

select firstname,lastname,concat(u.firstname,' ',u.lastname) as 'Fullname' from users u where u.userkey=''

[anujapawar]

In which field are we supposed to write this query on UI?

[CR]

you create Dynamic attribute pass sql query like below

1.

select concat(u.firstname,substring(u.lastname,1,2)) as ID from users where u.userkey=${requestee}

2.

select firstname,lastname,concat(u.firstname,' ',u.lastname) as ID  from users u where u.userkey=${requestee}

[anujapawar]

Is this the dynamic attribute field that you are referring to?  

If yes, can you help me fill these fields so as to get the required fullname attribute?

[rushikeshvartak]

Use preprocessor in connection MODIFYUSERJSON

(Please find same in previous response)

[anujapawar]

I created the following dynamic attribute. Now where can I see the reflected changes?

Let me know if I am missing some parameters to be added!

[rushikeshvartak]

Refer how to create dynamic attributes on documentation

https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter17-EIC-Analytics/Managing-An...

[rushikeshvartak]

{

"ADDITIONALTABLES": {

"USERS": "SELECT USERNAME , MANAGER, OWNER, JOBCODE, STATUSKEY, CUSTOMPROPERTY13, CUSTOMPROPERTY64,DISPLAYNAME,OWNERONTERMINATE,FIRSTNAME,LASTNAME FROM USERS"

},

"COMPUTEDCOLUMNS": [

"CUSTOMPROPERTY64",

"CUSTOMPROPERTY8",

"OWNERONTERMINATE",

"DISPLAYNAME"

],

"PREPROCESSQUERIES": [

"ALTER TABLE NEWUSERDATA ADD INDEX `idx_USERNAME` (`USERNAME` ASC)",

"ALTER TABLE NEWUSERDATA ADD INDEX `idx_OWNER` (`OWNER` ASC)",

"ALTER TABLE NEWUSERDATA ADD INDEX `idx_JOBCODE` (`JOBCODE` ASC)",

"ALTER TABLE CURRENTUSERS ADD INDEX `idx_USERNAME` (`USERNAME` ASC)",

"ALTER TABLE CURRENTUSERS ADD INDEX `idx_JOBCODE` (`JOBCODE` ASC)",

"ALTER TABLE CURRENTUSERS ADD INDEX `idx_OWNER` (`OWNER` ASC)",

"ALTER TABLE CURRENTUSERS ADD INDEX `idx_MANAGER` (`MANAGER` ASC)",

"ALTER TABLE CURRENTUSERS ADD INDEX `idx_STATUSKEY` (`STATUSKEY` ASC)",

"ALTER TABLE CURRENTUSERS ADD INDEX `idx_DISPLAYNAME` (`DISPLAYNAME` ASC)",

"ALTER TABLE CURRENTUSERS ADD INDEX `idx_OWNERONTERMINATE` (`OWNERONTERMINATE` ASC)",

"ALTER TABLE CURRENTUSERS ADD INDEX `idx_FIRSTNAME` (`FIRSTNAME` ASC)",

"ALTER TABLE CURRENTUSERS ADD INDEX `idx_LASTNAME` (`LASTNAME` ASC)",

"UPDATE NEWUSERDATA NU1 INNER JOIN CURRENTUSERS CU1 ON CU1.USERNAME=NU1.USERNAME SET NU1.DISPLAYNAME = CONCAT(CU1.FIRSTNAME, ' ', CU1.LASTNAME)

]

}

[PremMahadikar · Accepted solution]

Hi @anujapawar , Is this ask answered?

If not, Let me share this below;

As you have used/using .csv for importing users, we can achieve this during file import only. If the data is already in Saviynt. Please upload the data once again as one time activity to populate displayname and fullname

Admin -> Identity Repository -> users -> Actions: Upload user - add pre-processor config script after selecting file and other configs.

I have tested the below, and it works for me: Please try

{
   "ADDITIONALTABLES":{
      "USERS":"SELECT USERKEY,firstname, lastname,displayname,customproperty1 FROM USERS"
   },
   "COMPUTEDCOLUMNS":[
      "displayname",
      "customproperty1"
   ],
   "PREPROCESSQUERIES":[
      "UPDATE NEWUSERDATA SET displayname = CONCAT(firstname,substring(lastname,1,2))",
      "UPDATE NEWUSERDATA SET customproperty1 = CONCAT(firstname,',',lastname)"
   ]
}

Another sample JSON config from documentation link - Inline preprocessor

And how to use it - section COMPUTEDCOLUMNS, PREPROCESSQUERIES, ADDITIONALTABLES explained

Best practises of inline-preprocessor

If this solution answers your questions, please consider selecting Accept As Solution and hit kudos

[anujapawar]

Hi @PremMahadikar , 

Thank you for helping! It is finally working.