Loop through changesetArray in a stored procedure

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}}
)

Hi @NoahCameron,

Just to confirm, this is an example of a single row update, and you want to change it to a bulk update via stored procedure?

You could use a Javascript query to iterate through the changeset and trigger a single update for each row, as you have now, but this could be pretty slow if you have a lot of changes.