Skip to main content
R
ResmiKR
March 11, 2024

Pass sql editor values in dashboard to Business rules

  • March 11, 2024
  • 2 replies
  • 0 views

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 selected row to a business rule. Is it possible?

Thank you in advance!

2 replies

R
RobbSalzmann
March 11, 2024

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.


RobbSalzmann_1-1710200272074.png

 

 

R
ResmiKRAuthor
March 13, 2024

Thank you for it, 

I need to make modifications to the database table, which is why I'm using the SQL table editor. Is it possible to use GridView for the purpose of modifying data?

R
ResmiKRAuthor
March 13, 2024

Thank you for it, 

I need to make modifications to the database table, which is why I'm using the SQL table editor. Is it possible to use GridView for the purpose of modifying data?

R
RobbSalzmann
March 13, 2024

Once you’re in a BR you can modify a database table anyway you want.  
originally you wanted the user to “select a row and click a- button”. Is the user supplying the new/changed values?  If yes, STE. If no, Gridview

Terms & ConditionsAccessibility statement