Click HERE to see how Saviynt Intelligence is transforming the industry. |
04/23/2024 12:14 AM
Hi, I need to create account name rule for the condition:
Prefix (8661) 1st 5 letters of lastname and 1st letter of Firstname. eg for user:
Firstname: Alexandra and Lastname: Hernandez
Account name should be: 8661hernaA
Solved! Go to Solution.
04/23/2024 12:47 AM
Can you share what you have built?
Sample for some :
Solved: Accountname generation rules - Saviynt Forums - 67847
Accountname Rule via advanced query - Saviynt Forums - 86141
How to write User Account Correlation Rule - SQL &... - Saviynt Forums - 34827
04/23/2024 01:00 AM
concat(8661,(substring(users.lastname,1,5),substring(users.firstname,1,1))
I have tried this.
04/23/2024 03:19 AM
@RutujaM try below i tested as above example word designed below it working :
Firstname: Alexandra and Lastname: Hernandez
FirstName : A
LastName: herna
Account name should be: 8661hernaA
concat('8661',(substring(Lower(users.lastname),1,5)),substring(users.firstname,1,1))
04/23/2024 03:52 AM
I need first name's first character also small. eg. 8661hernaa
Can you modify a little?
04/23/2024 03:56 AM
concat('8661',(substring(Lower(users.lastname),1,5)),substring(Lower(users.firstname,1,1)))
check this
04/23/2024 03:59 AM - edited 04/23/2024 04:01 AM
use below and try @RutujaM
concat('8661',(substring(Lower(users.lastname),1,5)),substring(Lower(users.firstname),1,1))
04/23/2024 04:17 AM
This one is not working.
04/23/2024 04:37 AM
this one i tested it is working
concat('8661',(substring(Lower(users.lastname),1,5)),substring(Lower(users.firstname),1,1))
04/23/2024 04:39 AM
@RutujaM i tested in lab and it works.