Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/11/2024 05:03 AM - last edited on 10/11/2024 07:52 AM by Dave
Hello,
For some reason my email generation rule is removing the apostrophe out of the users firstname and I do not have any replace function in my email generation rule. I may be overlooking something below is my current rule.
case
when (select count(*) from users where concat(users.firstname,'.',users.lastname,'@domain.com') = users.email) then concat(users.firstname,".",users.lastname,'@domain.com')
when (select count(*) from users where concat(users.firstname,'.',substring(users.middlename,1,1),'.',users.lastname,'@domain.com') = users.email) then concat(users.firstname,'.',substring(users.middlename,1,1),'.',users.lastname,'@domain.com')
when (select count(*) from users where concat(users.firstname,'.',users.lastname,'1','@domain.com') = users.email) then concat(users.firstname,'.',users.lastname,'1','@domain.com')
when (select count(*) from users where concat(users.firstname,'.',users.lastname,'2','@domain.com') = users.email) then concat(users.firstname,users.lastname,'2','@domain.com')
when (select count(*) from users where concat(users.firstname,'.',users.lastname,'3','@domain.com') = users.email) then concat(users.firstname,'.',users.lastname,'3','@domain.com')
when (select count(*) from users where concat(users.firstname,'.',users.lastname,'4','@domain.com') = users.email) then concat(users.firstname,'.',users.lastname,'4','@domain.com')
when (select count(*) from users where concat(users.firstname,'.',users.lastname,'5','@domain.com') = users.email) then concat(users.firstname,users.lastname,'5','@domain.com')
ELSE concat(users.firstname,'.',users.lastname,'6','@domain.com')
end
[This post has been edited by a Moderator to remove sensitive information.]
10/11/2024 05:38 AM
Hi @cdavis2 if you try adding an email directly in UI to a user profile does it allow you?
10/11/2024 06:27 AM
Yes it allows me to add the email manually and even modify the existing email.
10/11/2024 08:22 AM
Please share logs