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
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 but it does not seem to work as a delimited list.
The active selected items will be passed to the defined Bound Parameter
field as a comma delimited list. The Bound Parameter format will be as: item1, Item2, Item3.
Please advise.
Thank You,
Indu
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)
1 Reply
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)