getting error in Multiple dropdown field.

Question

Hi Team, 
 Below is my code snippet, i hope i have handled the null but still am getting. can you please guide where it went wrong. 
 
 local!salesReps:index(rule!GSE_SCL_QRY_getViewIntakeDetails(
region:local!region,
sipYear:local!year,
pagingInfo:a!pagingInfo(1,-1)
).data,"Name",null),
local!repChoice:{union(local!salesReps,local!salesReps)},
local!salesRepName: if(a!isNullOrEmpty(local!repChoice),"None","All reps"),

a!multipleDropdownField(
label:"Sales rep name",
choiceLabels: if(a!isNullOrEmpty(local!repChoice),
{"No reps"},
{"All reps",local!repChoice},
),
choiceValues: if(a!isNullOrEmpty(local!repChoice),
{"None"},
{"All reps",local!repChoice},
),
value:local!salesRepName,
saveInto: local!salesRepName
)

Harshmodi · Answer

Hi Anitha Dharmalingam , In the given code, I noticed that the local variables you created are not wrapped inside the localVariable() function. Additionally, the local variable: salesReps contains null values, which is causing an error. Please add proper null handling and check this after making the changes.

Harshmodi · Answer

Can take reference from this code: a!localVariables(
 /*----- reject function will remove null values from the list ----------*/
local!salesReps:reject(fn!isnull,{"A","B","C",null}),
local!repChoice:{union(local!salesReps,local!salesReps)},
local!salesRepName: if(a!isNullOrEmpty(local!repChoice),"None","All reps"),

a!multipleDropdownField(
 label:"Sales rep name",
 choiceLabels: if(a!isNullOrEmpty(local!repChoice),
 {"No reps"},
 {"All reps",local!repChoice},
 ),
 choiceValues: if(a!isNullOrEmpty(local!repChoice),
 {"None"},
 {"All reps",local!repChoice},
 ),
 value:local!salesRepName,
 saveInto: local!salesRepName
)
)

Shyam Bommakanti · Answer

Anitha Dharmalingam Choice values cannot be null, in the code you shared it's covering one of the scenarios where the whole GSE_SCL_QRY_getViewIntakeDetails returns no values. But some of the Name are null and causing the error. I would suggest to update GSE_SCL_QRY_getViewIntakeDetails to filter out null names and or iterate thru the salesReps and remove nulls before using as choicevalues, I recommend former.