You are viewing limited content. For full access, please sign in.

Question

Question

Script to clear out old Form Instances from the Forms database

Forms Version 10
Updated May 30, 2016
asked on May 25, 2016 • Show version history

We have a user that has a Forms database (mdf) that is reaching up to 78 GB. They are about to run out of space.

We were hoping to clear out older form instances from the database to reduce the size of the file. I understand that we may need to shrink and reindex the database. We would like an official script provided by Laserfiche Developers.

We also need confirmation that by clearing out the form instance, it will also clear out the attachments that were submitted with the form. 

3 0

Replies

replied on May 26, 2016 • Show version history

Can you please upgrade to Forms 10.1? With Forms 10.1,if you delete that instance, all the related data include attachment will be removed from database. You can perform bulk deletion from instances page

0 0
View 3 previous replies
replied on May 26, 2016

Just to confirm, we will be performing a "delete" statement (include where clause) within the instances table. After we have updated the table, all related data will be removed with the instances, Correct? 

Will this be an immediate update? Also, could you confirm the instances table name? 

0 0
replied on May 26, 2016

I think they meant if you delete an instance through the Forms 10.1 interface it will delete all related data in the database, so there is no need to perform a delete statement on the database table itself.

0 0
replied on May 26, 2016 • Show version history

Gotcha Blake. The last sentence threw me off. 

0 0
replied on May 26, 2016

Laserfiche,

Our client had already performed a bulk deletion from within Forms 10.0. 

They tried clearing instances from over a year ago.

If we upgrade to 10.1, will the attachment data from those instances be removed from the database?

0 0
replied on May 26, 2016

Yes, when you upgrade to 10.1, it will clean up the database during update database: clear all the instances related data for deleted instances and deleted processes.

0 0
replied on May 26, 2016

I updated my last sentence which cause misunderstanding.

0 0
replied on May 30, 2016

You can also refer to the SQL script posted https://answers.laserfiche.com/questions/98078/Clear-Forms-Results if you want to remove the data from database directly.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...