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

SeanV's avatar
SeanV
New Contributor III
3 years ago

SQL Table Editor - Set selected record from a rule?

I have a SQL Table Editor on a dashboard, I would like a row to be "pre-selected" from code instead of through a user action (manually clicking on the record). Is this possible?  
dashboards
ckattookaran's avatar
ckattookaran
Valued Contributor
2 years ago

I'm not sure you can do that. However, you can set the parameter value the SQL editor is bound to and achieve similar results. That could lead to other issues if you are not actively clearing the parameter since it'll always remember your selection.

IBK's avatar
IBK
New Contributor III
2 years ago

Hello,

I have a similar requirement where the Bound Parameter has to return a comma delimited list of the selected row column. The bound column has been defined in the sql table editor. I also have a Supplied Parameter to collect the selected rows and pass it to the bound parameter and then to a BR for further processing. I am not sure how to format the Delimited list. Any help would be appreciated.

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    2 years ago

    Use  [ 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)

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

      Hi Robb,

      Thank You very much. But one question I have is when I declare the Parameter what should I use for the Display Items and the Value Items? Right now I have it blank. But I think that is an issue.

      Thank You,

      Indu

      • RobbSalzmann's avatar
        RobbSalzmann
        Valued Contributor II
        2 years ago

        Bound list and Member list combo boxes don't seem to want to display the default parameter value by default.  I think there is an enhancement request in the works for this, since last ~April.

        You can set the value of the parameter bound to the combobox in a BR before displaying the dashboard with that combobox - this will cause it to display what you want.