流程数据清理

表结构

清理引擎数据

该操作正常 不允许

数据库表：FLOW_ENGINE

DELETE  FROM FLOW_ENGINE where '根据实际情况删除';

清理流程实例

该操作正常 不建议

数据库表：FLOW_TASK

DELETE  FROM FLOW_TASK where '根据实际情况删除';

完整示例

全清理

可一次执行

DELETE  FROM FLOW_ENGINE;             - 删除工作流引擎
DELETE  FROM FLOW_ENGINEVISIBLE;      - 删除引擎可见范围
DELETE  FROM FLOW_TASK                - 删除流程实例
DELETE  FROM FLOW_TASKNODE;           - 删除实例节点
DELETE  FROM FLOW_TASKOPERATOR;       - 删除实例操作
DELETE  FROM FLOW_TASKOPERATORRECORD; - 删除实例操作记录
DELETE  FROM FLOW_TASKCIRCULATE;      - 删除实例传阅
DELETE  FROM FLOW_PAUSE_LOG;          - 删除实例暂缓日志
DELETE  FROM FLOW_BIZ_API;            - 删除工作流引擎业务接口
DELETE  FROM FLOW_BIZ_API_LOG;        - 删除工作流引擎业务接口调用记录
DELETE  FROM FLOW_DELEGATE;           - 删除流程委托
DELETE  FROM FLOW_DELEGATE_RECORD;    - 删除流程委托记录
DELETE  FROM FLOW_TIP;                - 删除审批提示语

删除引擎

需逐条执行

- 删除工作流引擎
DELETE  FROM FLOW_ENGINE where '根据实际情况删除';      
- 删除引擎可见范围       
DELETE  FROM FLOW_ENGINEVISIBLE t WHERE t.F_FLOWID NOT IN (SELECT F_ID FROM FLOW_ENGINE);
- 删除 无流程引擎 的流程实例
DELETE  FROM FLOW_TASK t WHERE t.F_FLOWID NOT IN (SELECT F_ID FROM FLOW_ENGINE);          
- 删除 无流程实例 的实例节点      
DELETE  FROM FLOW_TASKNODE n where n.F_TASKID not in (select F_ID from FLOW_TASK);
- 删除 无流程实例 的实例操作        
DELETE  FROM FLOW_TASKOPERATOR o where o.F_TASKID not in (select F_ID from FLOW_TASK);
- 删除 无流程实例 的实例操作记录       
DELETE  FROM FLOW_TASKOPERATORRECORD  r where r.F_TASKID not in (select F_ID from FLOW_TASK);
- 删除 无流程实例 的实例传阅 
DELETE  FROM FLOW_TASKCIRCULATE c where c.F_TASKID not in (select F_ID from FLOW_TASK);  
- 删除 无流程实例 的实例暂缓日志    
DELETE  FROM FLOW_PAUSE_LOG p where p.F_TASK_ID not in (select F_ID from FLOW_TASK);
- 删除 无流程引擎 的业务接口         
DELETE  FROM FLOW_BIZ_API t WHERE t.F_FLOWID NOT IN (SELECT F_ID FROM FLOW_ENGINE); 
- 删除 无业务接口 的业务接口调用记录           
DELETE  FROM FLOW_BIZ_API_LOG t WHERE t.F_BIZ_API_ID NOT IN (SELECT F_ID FROM FLOW_BIZ_API); 
- 删除 无流程引擎 的流程委托      
DELETE  FROM FLOW_DELEGATE t WHERE t.F_FLOWID NOT IN (SELECT F_ID FROM FLOW_ENGINE);   
- 删除 无委托的 的流程委托记录        
DELETE  FROM FLOW_DELEGATE_RECORD t WHERE t.F_BIZ_API_ID NOT IN (SELECT F_ID FROM FLOW_DELEGATE);

删除流程实例

需逐条执行

- 删除流程实例
DELETE  FROM FLOW_TASK WHERE '根据实际情况删除';                                               
- eg
- 根据时间删除：
- DELETE  FROM  flow_Task WHERE F_CREATORTIME<=TO_DATE('2023-04-07', 'yyyy-mm-dd');
- 按用户删除流：
- DELETE  FROM  flow_Task WHERE F_CREATORUSERID='admin'


- 删除 无流程实例 的实例节点
DELETE  FROM FLOW_TASKNODE n where n.F_TASKID not in (select F_ID from FLOW_TASK); 
- 删除 无流程实例 的实例操作
DELETE  FROM FLOW_TASKOPERATOR o where o.F_TASKID not in (select F_ID from FLOW_TASK);       
- 删除 无流程实例 的实例操作记录  
DELETE  FROM FLOW_TASKOPERATORRECORD  r where r.F_TASKID not in (select F_ID from FLOW_TASK); 
- 删除 无流程实例 的实例传阅 
DELETE  FROM FLOW_TASKCIRCULATE c where c.F_TASKID not in (select F_ID from FLOW_TASK);      
- 删除 无流程实例 的实例暂缓日志
DELETE  FROM FLOW_PAUSE_LOG p where p.F_TASK_ID not in (select F_ID from FLOW_TASK);

删除提示语

DELETE  FROM FLOW_TIP where F_USERID = '用户id';                - 删除审批提示语

其他

会涉及催办消息提醒，即使未删除，不影响正常使用

DELETE  FROM BASE_MESSAGE;
DELETE  FROM BASE_MESSAGERECEIVE where F_MESSAGEID not in (select F_ID from BASE_MESSAGE);