用友U8手工清除工作流资料

最新推荐文章于 2022-03-24 17:18:18 发布

Vinnking

最新推荐文章于 2022-03-24 17:18:18 发布

阅读量1.3k

点赞数

分类专栏：信息化

原文链接：https://blog.csdn.net/apollokk/article/details/72793616?locationNum=9&fps=1

版权

信息化专栏收录该内容

3 篇文章

订阅专栏

DECLARE @deleteBefore DATETIME;
 
SET @deleteBefore = '2017-1-1';
 
--工作流日志，这个表有可能很大，记录了工作流计算的过程，如果工作流没出错的话其实没啥用，直接清空即可
DELETE  FROM WF_CurrentLog
WHERE   CreateTime < @deleteBefore;
 
--流程实例锁定表
DELETE  FROM WF_PILock
WHERE   PIID IN ( SELECT    PIID
                  FROM      WF_ActiveFlow
                  WHERE     StartTime < @deleteBefore ); 
 
--历史状态表
DELETE  FROM WF_FlowState
WHERE   PIID IN ( SELECT    PIID
                  FROM      WF_ActiveFlow
                  WHERE     StartTime < @deleteBefore ); 
 
--工作流任务逻辑关系
DELETE  FROM Table_Task_Relation
WHERE   cTK_ID IN ( SELECT  cTK_ID
                    FROM    Table_Task
                    WHERE   cCreateTime < @deleteBefore ); 
 
--工作流任务表
DELETE  FROM Table_Task
WHERE   cCreateTime < @deleteBefore;
 
--流程实例表
DELETE FROM WF_ActiveFlow
WHERE   StartTime < @deleteBefore;