清理流程查看日志

15
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')

 

本文发布于 130 天前,内容时效性较低
这篇文章对你有帮助吗?