Orbeon form builder - form version

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Orbeon form builder - form version

pouyan
This post was updated on .
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  
Reply | Threaded
Open this post in threaded view
|

Re: Orbeon form builder - form version

Alessandro  Vernet
Administrator
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
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet
Reply | Threaded
Open this post in threaded view
|

Re: Orbeon form builder - form version

pouyan
This post was updated on .
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

Reply | Threaded
Open this post in threaded view
|

Re: Orbeon form builder - form version

Alessandro  Vernet
Administrator
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
--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet