User Update Page Exiting values not populating

[CR]

Hi Team,

When we are going to update exiting user, Manager and Department Manager attributes not populating in page view but able see in query execution time in values correctly Data Analyser.

Please can you help on above issue.

Using Query :

select distinct u2.username as ID, CONCAT_WS('',u2.firstname,u2.lastname) as inlinedescription from users u1,users u2 where u1.manager=u2.userkey and u2.statuskey=1 and u2.employeetype='Employee' and u1.userkey=${requestee}

Thanks,

Raghu

[Dhruv_S]

Hi @CR 

Could you please provide a screenshot. Is it happening for all the attributes or only these three attributes?

Regards,

Dhruv Sharma

[CR]

Thanks for response  Dhruv.

I facing below highlighted fields but wherever populating like country ,city,state..etc we not configured default  query in attribute creation form.

Note :if we pass default other coming fine , even if we pass default manager,department admin not populating.

[Dhruv_S]

Hi @CR 

Please make sure that these fields are correctly mapped with corresponding fields from user column.

Could you please share screenshot from the Register user form from Global configuration. Also, when you try to modify the user, do you see any error in logs.

Regards,

Dhruv Sharma

[CR]

Hi @Dhruv_S ,

We not seeing any error in logs,

Values: select distinct u2.username as ID, CONCAT_WS('',u2.firstname,u2.lastname) as inlinedescription from users u1,users u2 where u1.manager=u2.userkey and u2.statuskey=1 and u2.employeetype='Employee' order by ID

Default Value: select distinct u2.username as ID, CONCAT_WS('',u2.firstname,u2.lastname) as inlinedescription from users u1,users u2 where u1.manager=u2.userkey and u2.statuskey=1 and u2.employeetype='Employee' and u1.userkey=${requestee}

Please find mapping config :

Thanks,

Raghu

[yogesh]

I think the "manager" user column expects userkey not username, you should use the user column "owner" with the username.

I have used owner in past and it shows up correctly on update form, updating the owner field automatically sets the manager as well.

[CR]

Thank you!

@yogesh 

For Workday import we are getting Userkey , if use owner it will impact there it self.

any alternative solution please ?

[Dhruv_S]

Hi @CR 

As per the example in the below documentation, I can see the User Column: owner.

Setting Up Relationships Between Different Form Fields (saviyntcloud.com)

Can you try and confirm if it works.

Regards,

Dhruv Sharma

[CR]

Thanks you all.

I made the changes its working only Manager but similar issue happened below screenshot highlighted fields all:

Secondary manager and Vendor Manager also facing issue.

[Dhruv_S]

@CR 

Could you please check and confirm if you have mapped those fields- secondary manager, vendor manager etc. to some valid attributes in user column like custom property. If not, then please try now. If still an issue, please share the attribute screenshot for them.

Regards,

Dhruv Sharma

[CR]

@Dhruv_S,

Yes, but vendorManager and secondaryManager binding variable working on create user page but only issue for Update User Page,

As suggestion we can go with custom property data saving but again need to develop different format and re-update data based s4s connection in binding variables its big process , without custom-property alter souln and it will

VendorManager query  : select distinct u2.username as ID, CONCAT_WS('',u2.firstname,u2.lastname) as inlinedescription from users u1,users u2 where u1.vendorManager=u2.userkey and u2.statuskey=1 and u1.userkey=${requestee}

Column = vendorManager

Thanks for info

[Dhruv_S]

Hi @CR When you update an existing user, data should be picked from some user column, possibly this is the reason it won't work in user update without any user column mapped. Have you tested with custom property, and it works? Please confirm.

[CR]

@Dhruv_S  thanks for quick response.

With custom property its working we tested in 23.6v it self and present our prod also we using saving data in cp only(23.6v manager,vendorManager,secondaryManager binding variable not worked ,Saviynt team say temparory fix cp's data saving , it will support next version confirmed).

but 23.9 Saviynt team confirmed above binding variable working now, we tested create new user data also inserted in User table columns correctly.

i requesting , it should work user update page or not ? thinking create user page working means same columns data fetching based on above query based requestee. can you confirm it will work 23.9v or can we go with 23.6v tempary fix?

[Dhruv_S]

Hi @CR 

It should work in user update page. Let us know if you face any issues.

Regards,

Dhruv Sharma

[rushikeshvartak]

For mentioned attributes you need to key columns , refer users tables to identify correct user column to be added in dynamic attribute user column

[CR]

Thank you @rushikeshvartak ,

Yes it working for Create User Page think so using correct columns but not working update user page above screenshot highlighted values

[CR]

@rushikeshvartak,

Waiting for input, its working create user page means it working right, i was raised question for Update User Page highlighted fields not populating?