Delete Activiti History

[mangar]

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!

[sujaypillai]

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.

[mangar]

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.