Forum Discussion

VENKAB05's avatar
VENKAB05
New Contributor III
2 years ago

Default Value of a Delimited List Parameter Not Working

Hello Everyone, I am using a Delimited List Parameter which results a list of comma separated values from SQL through XFBR. When i use this parameter in Dashboard, it always shows as blank when...
Parameters
ChristianW's avatar
ChristianW
Valued Contributor

In the past, I also used xfbr to create comma separated lists for Delimited List Parameters. I did it to overcome problems I had with dynamic Bound List Parameters, if they needed parameters to query the database as well.

The error was caused because the custom parameter dictionary was not yet populated. To avoid the problem, you just need to test, if the custom parameter dictionary has data, before you run your code.

I‘m not at my desk, I will post a sample Monday.

ChristianW's avatar
ChristianW
Valued Contributor
2 years ago

And here is the code sample:

For Each paramValue As String In args.NameValuePairs.Values
	If StringHelper.DoesStringHaveCustomSubstVars(paramValue) Then Return Nothing
Next

You have to place it after this

Case Is = DashboardDataSetFunctionType.GetDataSet

and before any other if or select statementIf any argument contains unresolved parameters, it won't continue.

I hope this helps and cheers

 

  • VENKAB05's avatar
    VENKAB05
    New Contributor III
    2 years ago

    Thanks a lot Christian.