Forum Discussion

IBK's avatar
IBK
New Contributor III
2 years ago

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)