清理流程查看日志

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