lowcoder icon indicating copy to clipboard operation
lowcoder copied to clipboard

[Feat]: Table - Mark column as excluded from toUpdateRows

Open beatles1 opened this issue 1 year ago • 1 comments
trafficstars

Is there an existing issue for this?

  • [X] I have searched the existing issues

Current Behavior

When an editable table has a column manually added (in my case for a button to delete the row) that value is included in the toUpdateRows property. This means that if you use the GUI Mode Bulk Update option you get an error about this column. Screenshot 2024-06-20 170722

Expected Behavior

There should be a setting for the column to not include it in the toUpdateRows property.

Steps to reproduce

Create a table from some data, add a custom column not from the data, make some of the columns editable, add a query using the GUI Mode and the Bulk Update option to update the values in the DB and pass in the table toUpdateRows property.

Environment

Lowcoder 2.4.1 - Docker Compose All in One

Additional Information

Initial thread on Discord: https://discord.com/channels/1096896040159957084/1253378632555167886

beatles1 avatar Jun 20 '24 16:06 beatles1

We agree to change this behaviour - but we see it as enhancement. How so? Generally Lowcoder has all tools on board to deal with such cases too. For example, you can use a data-transformer to "clean" your data fro. toUpdateRows before the GUI Mode Query. But indeed - we understand the need by itself and will work on it.

FalkWolsky avatar Jul 21 '24 15:07 FalkWolsky