泛微OA清理人员抄送待办

发布时间 2023-08-05 10:11:27作者: 冷溪凌寒

创建查询,链接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