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?
Forum Discussion
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.
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)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
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.So it is ok to leave it blank? I dont need to display it but pass it to the buttonClick as you have shown it in the post before.
Thank You,
Indu