How to remove special characters while generating system user name

[Community_User]

Originally posted on November 26 2020 at 14:01 UTC

Hello All,

Can we remove the special characters while generating the system user name? We tried using the mysql function REGEXP '[_]' however it does not work in rule config.

Following error is seen the logs:

2020-11-25 19:06:12,517 [https-jsse-nio-443-exec-10] ERROR services.SaviyntCommonUtilityService - Error in running Advanced Config Query rule:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(case when (users.employeetype = 'Managed Service') AND (users.lastname REGEXP '' at line 5
at com.mysql.jdbc.Util.handleNewInstance(Util.java:408)

Thanks,

Pallavi

[Community_User]

Originally posted on November 27 2020 at 05:10 UTC

While configuring the systemusernamrule there is an textbox where in you provide the list of allowed special characters.This would enable to have systemusername with list of special characters required.

Thanks

Ajay

[Community_User]

Originally posted on November 27 2020 at 05:12 UTC

Hello Ajay, We do not want any special characters only alphanumeric values to be allowed. How do we specify that? Thanks, Pallavi

[Community_User]

Originally posted on November 27 2020 at 05:21 UTC

I would suggest to use inline-preprocessor which enables you to use mysql functions and custom jar.

Thanks

Ajay

[Community_User]

Originally posted on November 27 2020 at 05:27 UTC

Can we invoke mysql functions from system user name generation rules config to check for special characters?

[Community_User · Accepted solution]

Originally posted on December 14 2020 at 03:37 UTC

Hi, Yes My sql functions like concat,substring are supported.

Thanks

Ajay