Forum Discussion

VENKAB05's avatar
VENKAB05
New Contributor III
3 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
Icon for OneStream Employee rankOneStream Employee
3 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
3 years ago

Thanks a lot Christian.