查询历史记录

• 历史综合信息：HistoricTaskInstance
• 历史变量：HistoricVariableInstance

  -- 历史流程实例信息
  select * from act_hi_procinst;
  -- 历史节点
  SELECT * from act_hi_actinst;
  -- 这里记录的是：每一个任务环节到底由谁去操作
  select * from act_hi_identitylink;
  -- 历史任务的相关信息
  select * from act_hi_taskinst;
  -- 历史变量
  SELECT * from act_hi_varinst;

  ```java package com.torey.activiti7_workflow;

import org.activiti.engine.HistoryService; import org.activiti.engine.history.HistoricTaskInstance; import org.junit.jupiter.api.Test; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context.SpringBootTest;

import java.util.List;

@SpringBootTest public class Part5_HistoricTaskInstance { @Autowired private HistoryService historyService; /**

 * 根据用户名查询历史记录
 */
@Test
public void HistoricTaskInstanceByUser(){
    List<HistoricTaskInstance> list = historyService.createHistoricTaskInstanceQuery()
            .taskAssignee("bajie")
            .orderByHistoricTaskInstanceStartTime()
            .asc()
            .list();
    for (HistoricTaskInstance historicTaskInstance: list) {
        System.out.println("====历史任务===");
        System.out.println("id:"+historicTaskInstance.getId());
        System.out.println("processInstanceId流程实例Id:"+historicTaskInstance.getProcessInstanceId());
        System.out.println("name:"+historicTaskInstance.getName());
    }
}
/**
 * 根据流程实例ID查询历史
 */
@Test
public void HistoricTaskInstanceByPiID(){
    List<HistoricTaskInstance> list = historyService.createHistoricTaskInstanceQuery()
            .processInstanceId("d15e979c-2111-11eb-8532-603a7c6bd5e8")
            .orderByHistoricTaskInstanceStartTime()
            .asc()
            .list();
    for (HistoricTaskInstance historicTaskInstance: list) {
        System.out.println("====历史任务===");
        System.out.println("id:"+historicTaskInstance.getId());
        System.out.println("processInstanceId流程实例Id:"+historicTaskInstance.getProcessInstanceId());
        System.out.println("name:"+historicTaskInstance.getName());
    }
}

}

```