Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Email Generation rule case sensitivity being ignored

aundreb
Regular Contributor II
Regular Contributor II

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 #

aundreb_0-1717704738281.png

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?

aundreb_1-1717704815504.png

 

 

6 REPLIES 6

rushikeshvartak
All-Star
All-Star

Its not impacting anything 

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

Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

aundreb
Regular Contributor II
Regular Contributor II

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?

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


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

aundreb
Regular Contributor II
Regular Contributor II

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
Regular Contributor II
Regular Contributor II

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.

It will be product fix as its not configuration 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.