Problem on Dynamic Attribute - User register form Parent/Child

[moosam2]

Hi, i have problem to Test New Dynamic Attribute using Child / Parent relationship.

1. What i needed from user side experience

  1) Select parent (Kyle Test parent): ENUM from SQL Query - from Data Set.

   - Query : select attribute1 as ID from dataset_values where datasetname like 'CS_CPLIST'

   - Setting

     

  2) Child(Kyle Test Child) will be selected automatically followed Parent's selection for key on dataset.

   - Query : SELECT CP30 as ID from dataset_values where DATASETNAME='CS_CPLIST' and DEPARTMENT = (${KyleTestParent})

   - Setting

     

  3) After Submit, want to update User.Customproperty30 by Child value.

2. Symptom : When i select Parent, there are no change on Child.

Is there any mistake on my set-up? Thank you...

[rushikeshvartak · Accepted solution]

  2) Child(Kyle Test Child) will be selected automatically followed Parent's selection for key on dataset.

   - Query : SELECT customproperty30 as ID from dataset_values where DATASETNAME='CS_CPLIST' and DEPARTMENT = ${KyleTestParent}

And Select below option - 

• Required.
• Editable on create 
• Editable on update
• Also add query in default value

[moosam2]

Finally i found solution! also containing your recomendation.

SELECT customproperty30 as ID from dataset_values where DATASETNAME='CS_CPLIST' and ${KyleTestParent} = DEPARTMENT <-Works!

SELECT customproperty30 as ID from dataset_values where DATASETNAME='CS_CPLIST' and DEPARTMENT = ${KyleTestParent} <- Doesn't works..

Weired... haha.

Anyway Thank you!

[NM]

Hi @moosam2 ,

Customproperty 30 mapping doesn't exist until an account is created.

Dataset table doesn't have any customproperty 30 use value from dataset table like you used for parent attribute.

Plus add a query in default.