Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/04/2023 05:50 AM
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}
10/04/2023 06:35 AM - edited 10/04/2023 06:43 AM
@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
10/04/2023 08:09 AM
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.
10/04/2023 09:50 AM
@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
10/04/2023 10:59 AM
@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
10/05/2023 12:11 AM
Hi @gokul are you seeing this issue during new account request or modify account request?
10/05/2023 01:06 AM
@naveenss I'm facing this issue on new account request.
10/05/2023 09:39 AM - edited 10/05/2023 09:40 AM
@gokul : Make below modification on child attribute: languagecode
10/06/2023 01:46 AM
@Saathvik I have tried updating the child attribute as per your comment, but I'm still facing the issue. Value is not defaulted.
10/06/2023 06:10 AM
What is the behaviour you are seeing? It is not just defaulting the value or value is not changing as per parent?
10/06/2023 08:04 AM
@Saathvik It is not defaulting the value itself.
12/16/2023 09:42 AM
Default value only populated on parent attribute and not on child attributes