Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/06/2024 01:13 PM
Hello,
I'm using the below email generation rule to generate an email that requires the first letter of firstname and lastname to be uppercase. When it gets imported into the users table the email is still all in lower case.
CASE WHEN (users.lastname is null) THEN CASE WHEN (LENGTH(users.firstname) <= 21) THEN CONCAT(UPPER(SUBSTRING(users.firstname,1,1)),SUBSTRING(users.firstname,2,LENGTH(users.firstname)), '@domain') ELSE CONCAT(UPPER(SUBSTRING(users.firstname,1,1)),SUBSTRING(users.firstname, 2, 21), '@domain') END WHEN (users.firstname is null) THEN CASE WHEN (LENGTH(users.lastname) <= 21) THEN CONCAT(UPPER(SUBSTRING(users.lastname,1,1)),SUBSTRING(users.lastname,2,LENGTH(users.lastname)), '@domain') ELSE CONCAT(UPPER(SUBSTRING(users.lastname,1,1)),SUBSTRING(users.lastname, 2, 21), '@domain') END ELSE CASE WHEN (LENGTH(users.firstname) + LENGTH(users.lastname) <= 20) THEN CONCAT(UPPER(SUBSTRING(users.firstname,1,1)),SUBSTRING(users.firstname,2,LENGTH(users.firstname)), '.',UPPER(SUBSTRING(users.lastname,1,1)),SUBSTRING(users.lastname,2,LENGTH(users.lastname)),'@domain') ELSE CONCAT(UPPER(SUBSTRING(users.firstname,1,1)),SUBSTRING(users.firstname,2,LENGTH(users.firstname)),'.',UPPER(SUBSTRING(users.lastname,1,1)),SUBSTRING(users.lastname, 2, 20 - LENGTH(users.firstname)),'@domain') END END #
In the log snippet here the rule is generated properly, but looks like the email field is being populated as lowercase. Why does this happen?
06/06/2024 01:19 PM
Its not impacting anything
06/06/2024 03:27 PM
Hey @rushikeshvartak , so then why does it show as lowercase? I'm using the UPPER method on the first character of firstname and lastname. Is there anything wrong with my syntax above?
06/06/2024 07:24 PM
There nothing wrong in syntax but internally code making it lower case. Which does not look issue other than UI view issue
06/07/2024 05:25 AM
Yeah it looks like it is forcing it to lower case, if I pass it to an application the email is still in lower case.
06/07/2024 03:40 AM
Ah, so you are saying it should actually be uppercase if I pass the variable to other applications? This still may be confusing for the client, maybe a support case to Saviynt support could fix it. It should display as formulated.
06/07/2024 05:26 AM
It will be product fix as its not configuration
08/05/2024 10:24 PM
Hi @aundreb, We are also experiencing the same issue. If you found any solution, please share it here.
Thank you.
08/06/2024 10:26 AM
Raise support ticket
08/06/2024 10:30 AM
Hi Deepa_Vimal,
There is no solution from Saviynt. Raised an idea ticket for Saviynt to allow inserting into the email field with uppercase letters.
08/06/2024 10:35 AM
Share idea ticket number