In "register User form" custom "users manager" dynamic attribute not able to map with u.manager

[indrahema95]

Hi,

I have created a custom dynamic attribute "user manager" in "register user form". So that user can choose any user as a manager. But as manager attribute is big int and it stores the userkey value so I tried with two dynamic attribute approach. One takes the user name and another calculates the users userkey and store it in the u.manager attribute. 

DynamicAttr1: Single select from sql: SELECT username as ID from USERS where statuskey=1

DynamicAttr2: Single select from sql: SELECT userkey as ID from USERS where username=${DynamicAttr1}
user column: manager
Parent attribute: DynamicAttr1
What action to perform when Parent attribute changes?: Mapping

It is not storing the data. I have tried to store in a cp also but it's not working. Any inputs here? 

[avinashchhetri · Accepted solution]

@indrahema95,

You can use the "owner" attribute in Saviynt for your use case. This stores the username of the manager. Once you map that back to the owner attribute in your form, the Manager attribute should be auto populated.

[rushikeshvartak · Accepted solution]

DynamicAttr1: Single select from sql: SELECT distinct owner as ID from USERS where statuskey=1

user column: owner
Parent attribute: 
What action to perform when Parent attribute changes?: Mapping

[indrahema95]

Thanks Avinash & Rushi. This worked. Likewise I was trying to select & save the value for organization also. But it stores the customerkey value. Do you have any suggestion for that?

[avinashchhetri · Accepted solution]

@indrahema95,

Try select customername as ID from customer and map it to the customer column

I'd suggest you to go through the Schema documentations shared below and also utilize Data Analyzer to help you understand the underlying tables.

https://docs.saviyntcloud.com/bundle/SSM-DB-Schema-Reference-v55x/page/Content/Identity-Repository-S...

[indrahema95]

Hi @avinashchhetri ,

Yes, I have tried the same thing, but the problem is customer column is bigint which stores the customerkey, so it is unable to store the customername.  

[avinashchhetri]

@indrahema95,

I just tried in my local v2021 instance and works fine for me.