What happens with a row when it is deleted when "Hide" deletion mode is selected?
By default, Deletion is set to Delete
.
In Delete
mode, rows are instantly deleted without the possibility of recovery.
There is no undo
. For critical tables, you can set a deletion timer or attach a linkToInput call to the deletion trigger, requesting a PIN code input and throwing an errorException if it is incorrect.
But if you switch it to Hide
, the rows will not be deleted — they will be marked as deleted.
Can it be restored?
Yes, by clicking the restore button. This feature can be restricted by roles.
What happens with a Select that uses a hidden value?
His display will be strikethrough.
What happens with codes that take values from a hidden row?
Values from the hidden row can only be taken if the query is where: 'id' = VALUE
.
What should be done with the role, for the user to be able to duplicate rows in the table?