E9回收站相关说明

说明：E9回收站不会自动进行清理，标准产品上不提供删除回收站相应流程功能。

回收站查询以及清空回收站脚本。

1、相关的表查询SQL

select * from workflow_logviewusers_dellog 
select * from workflow_nownode_dellog  
select * from Workflow_SubwfRequest_dellog
select * from workflow_requestbase_dellog;
select * from workflow_curroperator_dellog;
select * from workflow_requestdeletelog;
select * from workflow_requestLog_dellog;

2、delete相关表操作

delete请慎重执行！！！

--根据requestid删除回收站指定流程
delete from workflow_requestLog_dellog where requestid=?;
delete from  workflow_requestbase_dellog where requestid=?;
delete from workflow_curroperator_dellog where requestid=?;
delete from workflow_requestdeletelog where request_id=?;
delete from workflow_logviewusers_dellog where request_id=?;
delete from workflow_nownode_dellog where request_id=?;
--清理整个回收站
delete from workflow_requestbase_dellog;
delete from workflow_curroperator_dellog;
delete from workflow_requestdeletelog;
delete from workflow_requestLog_dellog;
delete from workflow_logviewusers_dellog 
delete from workflow_nownode_dellog 

特别注意：delete 操作无条件，执行后会直接导致回收站清空，从而无法恢复。建议清空前，进行相应的数据备份后执行，谢谢!!!