Issue with populating default value for the endpoint dynamic attributes

[gokul]

I have created 2 dynamic attributes (role_name & languagecode) at the endpoint level and I'm using them while requesting an account through ARS. My goal is to populate a default value for languagecode based on the value of role_name.

I attempted this by using an SQL query in the default value. However, when I use a binding variable to retrieve the value of role_name in that query, the default value doesn't work. But, when I hard-code the value in the query, the default value functions correctly.

I have set the 'Parent Change Action' as 'Mapping' for both role_name and languagecode, and I have also specified the 'Parent Attribute' value as role_name for languagecode.

Any assistance with this issue is highly appreciated.

Note: Both role_name and languagecode value are derived from the dataset using the 'Attribute Type' as 'Single Select From SQL Query'

Query used in the default value:
select dv.ATTRIBUTE7 as ID from dataset_values dv where dv.datasetname = 'B_Roles' and dv.ATTRIBUTE1 = ${role_name}

  

[SumathiSomala]

@gokul Could you please try with below queries

select distinct dv.ATTRIBUTE1 as ID from dataset_values dv where dv.datasetname = 'B_Roles'

select distinct dv.ATTRIBUTE7 as ID from dataset_values dv where dv.datasetname = 'B_Roles' and dv.ATTRIBUTE1 = ${role_name}

Also refer below doc for more details

• Setting Up Relationships Between Different Form Fields

[gokul]

Thanks for the quick response @SumathiSomala 

I've tried by adding the distinct keyword but still the issue is same - It's not defaulting the value.

[SumathiSomala]

@gokul Could you please share all queries you have been used in value and default values fields for parent and child DAs.

and also share the sample dataset file

[gokul]

@SumathiSomala  Please find the below details.

Parent Attribute: role_name
Value: select dv.ATTRIBUTE1 as ID from dataset_values dv where dv.datasetname = 'B_Roles'
Default Value:

Child Attribute: languagecode
Value: select dv.ATTRIBUTE7 as ID from dataset_values dv where dv.datasetname = 'B_Roles' and dv.ATTRIBUTE1 = ${role_name}
Default Value: select distinct dv.ATTRIBUTE7 as ID from dataset_values dv where dv.datasetname = 'B_Roles' and dv.ATTRIBUTE1 = ${role_name}

Dataset Name : B_Roles

[naveenss]

Hi @gokul  are you seeing this issue during new account request or modify account request?

[gokul]

@naveenss I'm facing this issue on new account request.

[Saathvik]

@gokul : Make below modification on  child attribute: languagecode 

1. Use this query: select distinct ATTRIBUTE7 as ID from dataset_values where datasetname='B_Roles' and ATTRIBUTE1=${role_name} in both value and default value
2. Also remove Mapping from What action to perform when Parent attribute changes? and see if that works. If it didn't work then update it as Refresh

[gokul]

@Saathvik I have tried updating the child attribute as per your comment, but I'm still facing the issue. Value is not defaulted.

[Saathvik]

What is the behaviour you are seeing? It is not just defaulting the value or value is not changing as per parent?

[gokul]

@Saathvik It is not defaulting the value itself.

[rushikeshvartak]

Default value only populated on parent attribute and not on child attributes