Evening all,

I'm thinking about creating a workflow that runs on a routine schedule and searches the cf_bp_main_instances table for specific forms over a predetermined timeframe.  In theory, this would allow me to create retention periods for all my forms.  I plan on having the WF update the status to 99 on the entries that are over the timeframe that I determine for retention.  Now, I'm running LF 10.2 and was wondering if there were going to be any issues that can come from this approach.  I'm obviously being a bit cautious.  I do recall that  older version of forms needed to have execute Forms_MigrationDeleteMainInstances in order for the cleanup to take place, but thought that it was more automated in 10.2. If necessary, I do know that I can run the executable on a task or possibly as a script in the Retention Workflow. 

Any suggestions?

In all honesty, this seems like a really simple process, I'm surprised that Laserfiche has left the only real options as a delete all instances, or delete 100 at a time.  Or, code your way out of the problem.  Well, I need to keep 3 months worth of forms so I'm stuck deleting 70,000 forms by hand or individually scripting the 80 sum forms processes I use. 

Feature Request,  Add retentions!!! or possibly turn that 100 into 1000 at least. This stuff gets tuff when you have over 100,000 forms, and growing, a processing through with a mix of retentions every year.