03-11-2024 06:23 AM
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!
03-11-2024 07:35 PM - edited 03-11-2024 07:38 PM
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.
03-13-2024 02:21 AM
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?
03-13-2024 02:21 AM
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?
03-13-2024 06:14 AM
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