SQL query not identifying requestee and requestor objects

[varunpuri]

Hi,

We have a requirement to create a custom User Creation/Update form for external users. A few questions around the same

1. Can we create separate forms for Create User and Update User operations ?

2. For the Update User form, we need to read certain values from existing user's customproperties for which we are using a MultiSelect SQL query like :

select SUBSTRING_INDEX(SUBSTRING_INDEX(q.roles, ',', numbers.n), ',', -1) as ID from
(select substr((select distinct customproperty8 from users where userkey = ${requestee}),position(':' in (select distinct customproperty8 from users where userkey = ${requestee}))+1) as roles)q join
(select 1 n union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9 union all select 10 union all select 11 union all select 12 union all select 13 union all select 14 union all select 15 union all select 16 union all select 17 union all select 18 union all select 19 union all select 20)numbers on
CHAR_LENGTH(q.roles) - CHAR_LENGTH(REPLACE(q.roles, ',', '')) >= numbers.n-1

While this query is successfully fetching the desired result and displaying it as :

What we want to achieve is that - when a particular user's Update User form is opened, then the existing values of its customproperty should get displayed upfront (as shown above), but there are another set of values also which should appear as multiselect options in the same field (eg : Application 5 Access), those values should not be visible upfront, but when the requester clicks inside the multiselect box then those values should start appearing. Is this possible ?

Best Regards,
Varun

[Darshanjain]

Hi @varunpuri 

Please find the answers below

. Can we create separate forms for Create User and Update User operations ?- Yes , you can configure in the dyanmic attributes to be visible in create or update user form or both.

2. For the Update User form, we need to read certain values from existing user's customproperties for which we are using a MultiSelect SQL query like :

Requestee /requestor variable doesnt work in Multi select sql , you can try with single select sql.

3. What we want to achieve is that - when a particular user's Update User form is opened, then the existing values of its customproperty should get displayed upfront (as shown above), but there are another set of values also which should appear as multiselect options in the same field (eg : Application 5 Access), those values should not be visible upfront, but when the requester clicks inside the multi select box then those values should start appearing. Is this possible ?- 

yes this is exactly how it works, in the user update form you need to have the customproperty in user column in DA which will populate in user udpate form.

Let me know if you need any more details.

Thanks

Darshan

[rushikeshvartak]

In case of existing user values are populated from users custom property not from query