Picking specific values from the .recordUpdates property

Including only the fields you want updated

If you want to make sure only certain fields get updated for performance or safety reasons do this. Be sure to include the primary key in the array.

{{tblInvoices.recordUpdates.map(row => _.pick(row, ["invoice_id",'status_id']))}}

Excluding columns from update

If your query is from a join and you have columns that are not part of the table you are updating, you need to strip them out.

{{tblProducts.recordUpdates.map(row => _.omit(row, ["product_type","town_name"]))}}

Both of these tips make use of Lodash, which comes preinstalled with Retool.

(from @bradlymathews)