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_REASON_. but it does not delete the data permanently from database table (ACT_HI_PROCINST).
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.
Thanks in Advance,