Forum Discussion

ResmiKR's avatar
ResmiKR
New Contributor III
1 year ago

Pass sql editor values in dashboard to Business rules

Dear Community, I have a SQL Table Editor on a Dashboard and a button. When user select (click on a row/record) on the SQL Table Editor and then click the button, I need to pass the data in the sel...
Dashboards
RobbSalzmann's avatar
RobbSalzmann
Valued Contributor II
1 year ago

Consider using a GridView - better choice for your requirement.  You won't need a button.  As soon as the user selects a row, it fires the Server Task.  Use a Bound Parameter to associate the ID column in the table/grid.  Pass the value of that parameter into the rule and use it to query the table to lookup the rest of the values.  If you must use a button, be sure to pass in the value of the bound paramater in the GridView to the rule the button calls.