topic Re: Historic Data Cleanup in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/historic-data-cleanup/m-p/15927#M7030 <HTML><HEAD></HEAD><BODY><SPAN>Currently, it' only possible to remove HistoricTaskInstances (runtimeService.deleteHistoricTaskInstance).</SPAN><BR /><BR /><SPAN>Since there are timestamps included in all history tables (start/end times), you can perhaps create a batch-process that runs every day and cleans up the history for X days ago using plain old SQL <img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" /></SPAN></BODY></HTML> Fri, 14 Jan 2011 08:28:22 GMT frederikherema1 2011-01-14T08:28:22Z Historic Data Cleanup https://connect.hyland.com/t5/alfresco-archive/historic-data-cleanup/m-p/15926#M7029 Is there any guideline on how to clean up the audit data rows saved in Historic tables? Thanksā€¦ Fri, 14 Jan 2011 03:22:41 GMT https://connect.hyland.com/t5/alfresco-archive/historic-data-cleanup/m-p/15926#M7029 lojian 2011-01-14T03:22:41Z Re: Historic Data Cleanup https://connect.hyland.com/t5/alfresco-archive/historic-data-cleanup/m-p/15927#M7030 <HTML><HEAD></HEAD><BODY><SPAN>Currently, it' only possible to remove HistoricTaskInstances (runtimeService.deleteHistoricTaskInstance).</SPAN><BR /><BR /><SPAN>Since there are timestamps included in all history tables (start/end times), you can perhaps create a batch-process that runs every day and cleans up the history for X days ago using plain old SQL <img id="smileywink" class="emoticon emoticon-smileywink" src="https://connect.hyland.com/i/smilies/16x16_smiley-wink.png" alt="Smiley Wink" title="Smiley Wink" /></SPAN></BODY></HTML> Fri, 14 Jan 2011 08:28:22 GMT https://connect.hyland.com/t5/alfresco-archive/historic-data-cleanup/m-p/15927#M7030 frederikherema1 2011-01-14T08:28:22Z Re: Historic Data Cleanup https://connect.hyland.com/t5/alfresco-archive/historic-data-cleanup/m-p/15928#M7031 <HTML><HEAD></HEAD><BODY><SPAN>Great idea!</SPAN><BR /><BR /><SPAN>Every routine job could be described in work flow <span class="lia-unicode-emoji" title=":winking_face:">šŸ˜‰</span></SPAN><BR /><BR /><SPAN>Thanksā€¦</SPAN></BODY></HTML> Fri, 14 Jan 2011 09:33:17 GMT https://connect.hyland.com/t5/alfresco-archive/historic-data-cleanup/m-p/15928#M7031 lojian 2011-01-14T09:33:17Z