Multi select from SQL query DA in update user form

[SumathiSomala]

Hi team,

I have created one dynamic attribute with type multi select from SQL Query for custom user form.

while creating user i have selected few values in DA .

But in user update form I remove all values for the DA and submitted the request

No request ID generated.

What can be the reason for this?

It is working as expected when we keep at least on value in DA.

Any help would be appreciated.

[Dhruv_S]

Hi @SumathiSomala,

Could you please share the query you are using in DA.

Regards,

Dhruv Sharma

[SumathiSomala]

@Dhruv_S I have used dataset for this

select distinct attribute1 as ID from dataset_values where dataset_values.datasetname ='AD Groups'

[Dhruv_S]

Hi @SumathiSomala 

Replicated the scenario with below queries. I got the same error firs time when there was one value and then removed it and submitted the request. However next time it worked. 

Test Query in multi select dynamic attribute

select distinct city as ID from users where country in ('US', 'India', 'China')

Test case 1: User created with one value in dynamic attribute. Removed the value during modification. Kept no values in selection. Got same error.

Test case 2:  User created with three values in dynamic attribute. Removed one value during modification. Worked successfully.

Test case 3: User existing with two values in dynamic attribute. Removed both values during modification. Worked successfully.

There is no bug/misconfiguration, but it intermittently gives error if submitted immediately. As per my analysis, it expects some time before submitting post emptying the values from DA.

Please try again multiple times to validate if you get an error.

Regards,
Dhruv Sharma
If this reply answered your question, please accept it as Solution to help others who may have a similar problem.

[SumathiSomala]

@Dhruv_S i have tried multiple times still getting the same, no request created.

Working as expected when I keep atleast one value.

@rushikeshvartak No error in the logs

[rushikeshvartak]

Do you see any error in logs

[Dhruv_S]

Hi @SumathiSomala 

I tried twice without any values, and it gave the same error in 1st attempt and worked fine in 2nd attempt. The version I had tried tested it was V23.10. Is it possible for you to test in another version? Also please check if you get any error in logs. Else I would recommend you raise a support ticket.

Regards,
Dhruv Sharma
If this reply answered your question, please accept it as Solution to help others who may have a similar problem.

[SumathiSomala]

@Dhruv_S I have only one version i.e V23.7.

I will raise support ticket.

[SumathiSomala]

@Dhruv_S I have raised support ticket.

[#2006319] V23.7 | Unable to remove all existing values(Multi select from SQL query DA) in update us...