"Using commas in parameter values? I've got a literal parameter that may include commas, for example"" |!comment!| = 1,2,3"

[OSAdmin]

Originally posted by Cosimo Palmisano

3/16/2020

When I then try to use this parameter in an XFBR call, the NameValuePair dictionary doesn't contain the full string value and it only contains the 1. Everything after the 1st comma gets truncated. Is there a workaround to this issue?

[OSAdmin]

Originally posted by Cosimo Palmisano

I found another way to read the content of the bound parameter used with the text box:
Dim initCommentContent As String = args.SelectionChangedTaskInfo.CustomSubstVars(""0_txt_CommentBox_Content_ST"")
Using args.SelectionChangedTaskInfo.CustomSubstVars is pretty sweet since it provides all current values of dashboard parameters.

[ChristianW]

You can encapsulate the parameter with brackets like this: parameter=[|!comment!|].

Onestream will replace the parameter during execution to parameter=[1,2,3], the commas won't be interpreted as delimiter until it reaches the closing ].