topic How can i delete workflow permanenently from database by using ActivitiRestClientService. Please help! in Alfresco Forum https://connect.hyland.com/t5/alfresco-forum/how-can-i-delete-workflow-permanenently-from-database-by-using/m-p/30650#M13042 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a requirement to delete all old closed workflow from on some routine basis using ActivitiRestClientService method.</P><P>I am unable to do it and i am not able to find any method that delete a workflow from database. there is a service that delete workflow by changing the status in DELETE_REASON_. but it does not delete the data permanently from database table (ACT_HI_PROCINST).</P><P></P><P>actually this table(ACT_HI_PROCINST) we are using to display all closed workflow in GUI. but due to it does not delete the data permanently from table is causing performance issue as it loads all workflow during load time and we have to filter it programmatically after all data loaded in resultset. and due to this we are getting performance issue.</P><P></P><P>Thanks in Advance,</P><P>Best regards,</P><P>Shashi</P></BODY></HTML> Thu, 13 Jul 2017 13:00:50 GMT alfresco_shashi 2017-07-13T13:00:50Z How can i delete workflow permanenently from database by using ActivitiRestClientService. Please help! https://connect.hyland.com/t5/alfresco-forum/how-can-i-delete-workflow-permanenently-from-database-by-using/m-p/30650#M13042 Hi All,I have a requirement to delete all old closed workflow from on some routine basis using ActivitiRestClientService method.I am unable to do it and i am not able to find any method that delete a workflow from database. there is a service that delete workflow by changing the status in DELETE_REA Thu, 13 Jul 2017 13:00:50 GMT https://connect.hyland.com/t5/alfresco-forum/how-can-i-delete-workflow-permanenently-from-database-by-using/m-p/30650#M13042 alfresco_shashi 2017-07-13T13:00:50Z Re: How can i delete workflow permanenently from database by using ActivitiRestClientService. Please help! https://connect.hyland.com/t5/alfresco-forum/how-can-i-delete-workflow-permanenently-from-database-by-using/m-p/30651#M13043 <HTML><HEAD></HEAD><BODY><P>Have you tried the <A href="https://www.activiti.org/userguide/index.html#_delete_a_historic_process_instance" rel="nofollow noopener noreferrer">delete api</A>&nbsp;?</P></BODY></HTML> Mon, 17 Jul 2017 20:01:30 GMT https://connect.hyland.com/t5/alfresco-forum/how-can-i-delete-workflow-permanenently-from-database-by-using/m-p/30651#M13043 cjose 2017-07-17T20:01:30Z Re: How can i delete workflow permanenently from database by using ActivitiRestClientService. Please help! https://connect.hyland.com/t5/alfresco-forum/how-can-i-delete-workflow-permanenently-from-database-by-using/m-p/30652#M13044 <HTML><HEAD></HEAD><BODY><P>Thank you Joseph,</P><P></P><P>Yes, I cheked the delete api. but all the delete method of this api it only disable the workflow(it fills the column with DELETE_REASON with Deleted by user). it do not delete workflow from database.</P><P>But our requirements is completely delete the all closed work flow from Table (ACT_HI_PROCINST) which is causing performance issue.</P><P></P><P>Best regards,</P><P>Shashi</P></BODY></HTML> Fri, 11 Aug 2017 12:47:45 GMT https://connect.hyland.com/t5/alfresco-forum/how-can-i-delete-workflow-permanenently-from-database-by-using/m-p/30652#M13044 alfresco_shashi 2017-08-11T12:47:45Z