Orbeon form builder - form version

Could you please let me know if this is normal behavior in form builder

1- Create a form in Orbeon form builder
2- Save and publish the form for fist time  - version 1
3- the form is inserted in orbeon_form_data table with form_version =1

Then I change the form in Orbeon form builder

4- Save and publish the form and I select to overwrite with version 1 (not create new version)
3- then a new form is inserted in orbeon_form_data table with form_version =1

and I end up to have two rows however I select to overwrite and not to have new version why it didn't update the first row with changes and create new rows  

Hi Pouyan,

Yes, this is how it is expected to work. Data in orbeon_form_data isn't overwritten or deleted (except for drafts), and instead new rows are added. In a way it acts as a journal, which allows auditing and recovery.

Alex

Hi Alex

Thank you for your information , so just in case if I want to clean up the table , is it safe to delete old rows for same form and keep only latest row

Hi Pouyan,

Yes, done properly, it is safe to delete this "journal" data. And this is especially interesting if it causes some issue as far as space usage or performance is concerned.

Alex