In user create form we have organization selection dynamic attribute which needed to be mapped into user’s customer column.
In organization selection at ARS, we are getting organization name and user’s customer column stores key so added one more dynamic attribute which will convert customer key to customer name and map into user’s customer column.
Eg: org_selection will have organization name and org_key will store customer key in ‘customer’ column.
We are storing manager value in similar way there it is successfully getting mapped. Attribute ‘manager’ lists user in ARS form and managerid stored it in user’s manager column as id
Hi @Sucheta please try mapping the organization name itself to the user's customer attribute. This is working in v2021. I'm expecting this to work in your version also.
Quick question, are you trying this user creation from a custom SAV role?
@Sucheta The configurations seems to be correct. I saw an error in the logs. Do you have any custom JAR deployed? Below is the error found in the logs.
"2023-07-28T07:22:38.995+00:00","ecm","","","","28-Jul-2023 07:22:38.499 WARNING [http-nio-8080-exec-15] groovy.sql.Sql$AbstractQueryCommand.execute Failed to execute: select (concat(SUBSTRING( firstname, 1,1), lastname,'-') as property from users users where users.USERKEY=3441 because: 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 'as property from users users where users.USERKEY=3441' at line 1" "2023-07-28T07:22:38.500+00:00","ecm","services.SaviyntCommonUtilityService","http-nio-8080-exec-15","ERROR","Error in running Advanced Config Query rule: " "2023-07-28T07:22:38.995+00:00","ecm","","","","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 'as property from users users where users.USERKEY=3441' at line 1 at com.mysql.jdbc.Util.handleNewInstance(Util.java:408) at com.mysql.jdbc.Util.getInstance(Util.java:383) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4208) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4140) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2597) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2758) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2820) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2769) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1569) at com.saviynt.ecm.services.SaviyntCommonUtilityService$_getUniqueSystemUserName_closure7.doCall(SaviyntCommonUtilityService.groovy:592) at
Also, just to test a simple organization dynamic attribute, can you please create the below and let me know the result?
dynamic attribute name: userOrg
attribute type: Single Select from SQL Query
Value: select customername as ID from customer
user column: customer
Editable on create: true