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
2 years ago

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.