We are using Stored Procedures to update data as we often use joins from multiple tables and so the GUI bulk update doesn't work as you have to select a single table. We would like to use the table components changesetArray to not have users go into a modal to update two fields on many different rows, while retaining the stored procedure usage.
I'd like to iterate through the changesetArray within the Stored Procedure. Any advice or alternative methods on how to do that?
A typical stored procedure for us may look like this:
CALL public.a_stored_procedure(
{{table1.selectedRow.id}}
{{textInput.value}},
{{selectInput.selectedLabel}},
{{currencyInput.value}},
{{dateInput.value}}
)