清理流程查看日志

7
57字 · 1分钟
SELECT * FROM workflow_requestviewlog
where viewer in (SELECT ID FROM HrmResource WHERE lastname='XXX')

DELETE FROM workflow_requestviewlog
where viewer in (SELECT ID FROM HrmResource WHERE lastname='XXX')

SELECT * FROM workflow_communicationreadlog
WHERE readUser IN (SELECT ID FROM HrmResource WHERE lastname='XXX')

DELETE FROM workflow_communicationreadlog
WHERE readUser IN (SELECT ID FROM HrmResource WHERE lastname='XXX')

 

本文发布于 85 天前,内容仍有参考价值