The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

IBK's avatar
IBK
New Contributor III
2 years ago
Solved

Sql Table Editor and Multiselect functionality

How can we  pass the selected row key using a bound parameter? I am trying to capture the selected row to a BR for further processing. I also have a supplied parameter to collect the bound parameter ...
dashboards
  • RobbSalzmann's avatar
    RobbSalzmann
    2 years ago

    The secret sauce is putting  [ square brackets ] around the parameter name that you want a delimited list from:

    {DBExtenderName}{FuncName}{CommaDelimitedListOfValues=[|!pm_multipleValuesParam!|]}

    Then inside your BR, parse the comma seperated list into an array or list, whatever suits:

    Dim arrValues As String() = args.NameValuePairs.XFGetValue("CommaDelimitedListOfValues", String.Empty).Trim().Split(","c)

     

     

     

     

RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
2 years ago

The secret sauce is putting  [ square brackets ] around the parameter name that you want a delimited list from:

{DBExtenderName}{FuncName}{CommaDelimitedListOfValues=[|!pm_multipleValuesParam!|]}

Then inside your BR, parse the comma seperated list into an array or list, whatever suits:

Dim arrValues As String() = args.NameValuePairs.XFGetValue("CommaDelimitedListOfValues", String.Empty).Trim().Split(","c)