Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
5 years ago

"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

  • ChristianW's avatar
    ChristianW
    Valued Contributor

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

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor II
    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.