Email Generation rule case sensitivity being ignored

[aundreb]

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?

[rushikeshvartak]

Its not impacting anything 

• email address can be anything
• full upper case
• full lower case
• camel case

[aundreb]

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?

[rushikeshvartak]

There nothing wrong in syntax but internally code making it lower case. Which does not look issue other than UI view issue

[aundreb]

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.

[aundreb]

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.

[rushikeshvartak]

It will be product fix as its not configuration 

[Deepa_Vimal]

Hi @aundreb, We are also experiencing the same issue. If you found any solution, please share it here.

Thank you.

[rushikeshvartak]

Raise support ticket

[aundreb]

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.

[rushikeshvartak]

Share idea ticket number