Global configuration - Register user form

[Jillustre]

Hey ,

Someone know why we can't select Owner or Manager field for the user column  on the Register form configuration intho the global configuration - Life cycle?

Right now we are stocking it into customproperty then with a connection and job, we fill out the owner and manager field

We can do it for firstname and lastname, why not with manager or owner field?

thanks

[pruthvi_t]

Hi,

In the 'Register user form' attributes, you can use manager in the user column. Kindly provide more insight if you're facing any issue doing so.

[rushikeshvartak · Accepted solution]

Refer 

https://forums.saviynt.com/t5/identity-governance/in-quot-register-user-form-quot-custom-quot-users-...

[Jillustre]

@rushikeshvartak instead of doing Single select from sql: SELECT distinct owner as ID from USERS where statuskey=1 is there any way I can do something like this to include the first name and lastname on the manager selection? try different way yesterday with no success

select concat(u.firstname,' ', u.lastname,' (',u.username,')') as ID from users u where u.statuskey=1

[sk]

Since you are concatenating first name and lastname and mapping it to owner column it won't work.

Owner attributes only hold username of the manager. So when you mapping an attribute to owner you should pass the value as username.

If you want to display Manager first name, last name and username then like mentioned in thread you may need to use another dynamic attribute and there you translate your concat logic to user name something like below

DA1: select concat(u.firstname,' ', u.lastname,' (',u.username,')') as ID 

DA2: SELECT username as ID from USERS where  username=SUBSTRING_INDEX(SUBSTRING_INDEX(${DA1}, "(", -1), ")",1)

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

[Jillustre]

So in the Attribute type I select multiple select from sql query and enter both like you mention in the values?

[sk]

Attribute type will be Single select from sql only, You will just create two dynamic attributes one will hold the manager first name, lastname, username and another will hold only username and this is child to first dynamic attribute. On selecting manager from DA1 it will auto populate DA2

DA1- single select from sql - select concat(u.firstname,' ', u.lastname,' (',u.username,')') as ID from users u where u.statuskey=1

DA2- single select from sql - 

SELECT username as ID from USERS where  username=SUBSTRING_INDEX(SUBSTRING_INDEX(${DA1}, "(", -1), ")",1)

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

[Jillustre]

@sk I have the following and when I tried to create the user is nothing is in owner field

[Jillustre]

@rushikeshvartak Same issue when trying to save the secondaryEmail, here is our current config

 

 

  

 

[sk]

You don't need pass Mapping in what action to perform since you are not dependent on any parent attribute so remove it. Also in user column use secondaryemail

[Jillustre]

I tried that and it dosen't save into the secondaryemail field

[rushikeshvartak]

What’s error in log

[Jillustre]

@rushikeshvartak When I search for secondaryEmail in the log for the 15 last minute, I get this

same thing for cost center, we don't receive it on creation

[sk]

Can you try without hiding the Manager2 field. If you hide it will not populate the data.

[Jillustre]

Oh ok. I dont want to show it to user... will try

[Jillustre]

same, nothing goes into owner field

[sk]

But on the UI do you see that manager2 is populating username on UI or not?

[Jillustre]

@sk Manager2 is not rendered on the selection of the Manager field