清理流程查看日志

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

 

本文发布于约 8 个月前,请注意内容时效性
这篇文章对你有帮助吗?