Skip to main content
September 30, 2020

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

  • September 30, 2020
  • 2 replies
  • 0 views
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?

2 replies

September 30, 2020
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.

OneStream Employee
October 18, 2021

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 ].