topic Re: Delete Activiti History in Alfresco Archive

Delete Activiti History

mangar — Mon, 17 Mar 2014 05:42:18 GMT

How do I delete all history of all completed workflows? I assume it's some tables in the DB, but I don't want to go around truncating tables that I don't know what they do!

Re: Delete Activiti History

sujaypillai — Mon, 24 Mar 2014 05:21:29 GMT

Could you please let us know the reason for deleting the history of completed workflows OR what you are trying to achieve?

As a best practice you shouldn't touch the Alfresco DB, specially for DELETE operation.

Re: Delete Activiti History

mangar — Tue, 25 Mar 2014 03:29:21 GMT

I have written code that displays workflow history. And on my DEV box, I just want to clean it up from time to time when I re factor my code.

I truncated all tables that begin with: act_hi_* and that seems to do the trick. But according to the documentation, a row is written to that table as soon as a task is started, then updated from there, so make sure all your workflows are complete before you do this.