Leveraging Intelligent Recommendations for Operational Transformation. AMS Partners click HERE | EMEA/APJ Partners click HERE |
03/15/2024 03:16 AM
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.
Solved! Go to Solution.
03/15/2024 04:39 AM
@anujapawar refer this article for creating user via UI with DA usage
Configuring Create/Register User form in EIC - Saviynt Forums - 50744
03/15/2024 05:55 AM
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=''
03/17/2024 10:30 PM
In which field are we supposed to write this query on UI?
03/17/2024 10:38 PM
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}
03/18/2024 08:13 PM
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?
03/18/2024 08:15 PM
Use preprocessor in connection MODIFYUSERJSON
(Please find same in previous response)
03/18/2024 10:00 PM
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!
03/18/2024 10:07 PM
Refer how to create dynamic attributes on documentation
03/17/2024 06:39 PM
03/19/2024 01:36 PM
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
03/19/2024 10:38 PM - edited 03/19/2024 10:39 PM
Hi @PremMahadikar ,
Thank you for helping! It is finally working.