Create User form - Populating an attribute value by concatenating the other dynamic attribute values

[kunal_saxena]

Hi,

I have a use case where I need to concatenate the values from 2 fields on the create user request form and populate it in a 3rd field.

There are 2 fields (dynamic attributes) - "createCWLedger" & "createCWActivityCenter". These are of type String and the requestor can type any value in these fields.

There is a 3rd field - "createCWCostcenter" whose value should be the concatenation of the values entered in createCWLedger & createCWActivityCenter.

I have tried the below 2 approaches but both of them are giving error:

1st approach:

"createCWCostcenter" of type "Single select from SQL query" and default value:
select concat(${if(binding.variables.containsKey('createCWLedger')) {createCWLedger} else {''}},${if(binding.variables.containsKey('createCWActivityCenter')) {createCWActivityCenter} else {''}}) as ID

Reference - https://docs.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Chapter13-Access-Requests/ars-mang-...

Error - No such property: variables for class: java.lang.String. Stacktrace follows:

2nd approach:

"createCWCostcenter" of type "Single select from SQL query" and default value:
select concat(${createCWLedger},${createCWActivityCenter}) as ID

Reference - https://forums.saviynt.com/t5/identity-governance/retrieving-attribute-value-in-user-request-form/m-...

Solution provided by @ GOE

Error - No such property: createCWLedger for class: SimpleTemplateScript2. Stacktrace follows:

Can anyone identify what the issue might be with the above mentioned approaches? Also, is there some other setting that needs to be configured while establishing such a relationship between dynamic attributes?

Thanks,
Kunal

[This message has been edited by moderator to remove @ mention]

[Saathvik · Accepted solution]

Did you make createCWCostcenter as child attribute for "createCWLedger" or "createCWActivityCenter" using 2nd approach if not make that configuration then see if that works.

To do so go to "createCWLedger" & "createCWActivityCenter" 

update What action to perform when Parent attribute changes? as Refresh

Go to createCWCostcenter and choose Parent Attribute as createCWLedger and in What action to perform when Parent attribute changes? Mapping 

[kunal_saxena]

Thanks @Saathvik , The configuration suggested by you worked.