Retrive user customproperty value to multiselect dynamic attribute on update user form

[sandeepsingh]

Need to retrieve the value from a user customproperty that was stored using multi-select sql query with create user request form. 

[nimitdave]

You can query it from users table for the column name mapped in the create user form for that field.

[sandeepsingh]

Single-select values get auto-populated without query but multi-select values does not.

Even if I query it, if we want to modify or add more values to it as we added in the create user form. 

Scenario: A user can be part of a department and there are many sub-departments. If there are 4 sub-departments selected initially and now we want to retrieve the same in the update user form, also want to add/delete subdepartments. This is what is required to achieve.

[nimitdave]

So right now the user not able to determine the existing sub department in the update user form?

If this is the case you can have 2 DAs, one has exiting sub departments and will not be editable another DA will show all sub departments minus the existing ones and is editable in update user form and will be used by user to Add the departments.

[nimitdave]

But when I tries its showing the existing ones too.

Here, the DA is mapped to cp12 and A,B,C are existing values. D,E are new ones.

[sandeepsingh]

In Create form its visible but not getting retrived in update form.

Can you put some snapshots of DA configs as well? Also, once the details are saved using "user column" in DA, is that is visible in update user form as well.

[rushikeshvartak]

can you share values stored in user's CP

[sandeepsingh]

A snapshot of stored values in CP is in the first thread. It's a multi-select DA (from SQL) and is stored in CP 65 using user column mapping. 

Ex: CP65 value is "IRISBUS::WEILAND BOOTE GMBH,IRISBUS::firstname". Its comma seperated value.

[nimitdave]

Yes, in the update form it will only show value which is stored in the user column mapped in the create form DA.

If DA in create form has user column as nothing then nothing will be displayed in update form.

[ejeong]

Default value seems not available for multi select query.