Forward Slash in System Username Generation Rule

[Mah]

Hi All, 

We have a requirement from client on user creation request to use users' first name and last name for username generation. We do have a list of words need to remove during username generation. However, we are not able to include forward slash in advanced query and we are getting error message "Operation not allowed as you are entering a value that resembles or contains script code" The query we have as below:

concat(substring(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(upper(users.lastname),'BIN',''),'BT.',''),'BINTI',''),'A/L',''),'A/P',''),' ',''),'!',''),'@',''),',',''),'?',''),':',''),'-',''),'$',''),'=',''),' ',''),'''',''),1,1),substring(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(upper(users.firstname),'BIN',''),'BT.',''),'BINTI',''),'A/L',''),'A/P',''),' ',''),'!',''),'@',''),',',''),'?',''),':',''),'-',''),'$',''),'=',''),' ',''),'''',''),1,7))

May I know is there any way we can include the forward slash in the query. Appreciated in advance.

Thanks.

[rushikeshvartak]

concat(substring(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(upper(users.lastname),'BIN',''),'BT.',''),'BINTI',''),'A/L',''),'A/P',''),' ',''),'!',''),'@',''),',',''),'?',''),':',''),'-',''),'$',''),'=',''),' ',''),'''',''),1,1),substring(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(upper(users.firstname),'BIN',''),'BT.',''),'BINTI',''),'A/L',''),'A/P',''),' ',''),'!',''),'@',''),',',''),'?',''),':',''),'-',''),'$',''),'=',''),' ',''),'''',''),1,7))

[Mah]

Hi Rushikesh, 

The query you share was the same as per my query, may I know have you updating anything on the query?

Thanks.

[rushikeshvartak]

Are you getting any error ?

[Mah]

Hi, 

I am getting operation not allow as below.

Thanks.

[rushikeshvartak]

Please raise support ticket for same. 

Refer similar issue report in email template https://ideas.saviynt.com/ideas/EIC-I-5590