I encountered a problem with editable tables.
My table shows entities with a required field. It is set to be editable and the columns are also set to be editable.
If I select an entity that is already saved in the database the remove action gets enabled.
After this if I delete the required fields (name) content and choose the remove action I get an exception:
SQLIntegrityConstraintViolationException: integrity constraint violation: NOT NULL check constraint; SYS_CT_10390 table: UNTITLED_NEW_ENTITY column: NAME
As I understand the remove action just runs an update on the database with the deleted_by and delete_ts set. So the problem is the other fields value are not those saved in the database but the ones shown in the table.
Can you suggest a way to avoid this error?