Skip to main content
Sep 30, 2020 1:56 PM UTC

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

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

Sep 30, 2020 2:24 PM UTC
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
Employee - Advisor
Employee - Advisor
Oct 18, 2021 12:13 PM UTC

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