08-29-2017 03:00 AM
请问一下如何删除ACT_HI_ACTINS中的一条记录,我并没有找到Activiti内部有提供相应的接口?
I would like to ask how to delete a record in ACT_HI_ACTINS, I did not find Activiti internal to provide the appropriate interface?
09-01-2017 12:00 PM
I don't think there are APIs to delete a record from ACT_HI_ACTINST. You can use the delete methods in HistoryService to delete a process or task instance which will in-turn delete all the associated records from respective tables including ACT_HI_ACTINST
Ciju
09-01-2017 12:00 PM
I don't think there are APIs to delete a record from ACT_HI_ACTINST. You can use the delete methods in HistoryService to delete a process or task instance which will in-turn delete all the associated records from respective tables including ACT_HI_ACTINST
Ciju
09-11-2017 03:48 AM
thanks for your answer Sincerely !!! I have find another way to solve this problem .
09-11-2017 08:35 AM
Hey Kim - Can you let us know what you did to resolve? It may be helpful to another user later!
10-19-2017 04:00 AM
i don't know how to describe the process, so i will show the code directly . hope it will help another user.
public interface HistoryActivitiInstanceMapper {
@Delete(" delete from act_hi_actinst where ID_ = #{id}")
public Integer deleteHistoricActivitiInstanceById(String id);
}
CustomSqlExecution<HistoryActivitiInstanceMapper, Integer> sqlExecution =
new AbstractCustomSqlExecution<HistoryActivitiInstanceMapper, Integer>(HistoryActivitiInstanceMapper.class) {
@Override
public Integer execute(HistoryActivitiInstanceMapper mapper) {
return mapper.deleteHistoricActivitiInstanceById(currentId);
}
};
09-18-2017 01:06 PM
There is a Rest Api available for deleting the historic process instance.
DELETE history/historic-task-instances/{taskId}
You can refer the user guide for more information.
Or in case you are looking for a Java Api, i recommend you visit the corresponding git repo module.
10-19-2017 04:01 AM
thanks for your help !!!
06-20-2018 11:16 AM
Have any one found a way to retrieve the entire tree of the process instance, including all task details, once the instance goes to completed state? and moving them to an archive table from the ACT_HI?
06-20-2018 11:22 AM
The Activiti 7 work is doing that via different micro services. You can find more about Activiti 7 at Introduction · Activiti 7 & Activiti Cloud Developers Guide .
If you are using Activiti 5.x, I once did a project that moves everything from Activiti tables to Elasticsearch, it is available at GitHub - cijujoseph/activiti-analytics-spring-boot: A standalone app (ETL pattern using spring-boot)...
06-20-2018 12:15 PM
Thank you for the reply. checking....
Instead of getting all the instances, is there any way to get only completed instances, irrespective of the processKey?
history/historic-process-instances?endTime!=null&size=100 -- ignoring the "endTime"
Explore our Alfresco products with the links below. Use labels to filter content by product module.