泛微OA清理人员抄送待办
创建查询,链接ecology数据库,解决人员ID为6的抄送数据
--1。备份wf_curr0724bak自定义 select * into wf_curr0724bak from workflow_currentoperator
--2查询 替换userid select * from workflow_currentoperator a where isremark in (8,9) and isremark in (8,9) and isLastTimes=1 and userid=6
--3--更新 update a set a.isremark=2,viewtype=-2 from workflow_currentoperator a where isremark in (8,9) and isremark in (8,9) and isLastTimes=1 and userid=6