工作流任务后台处理命令

1.查看工作流任务

select * from T_WFR_Assign？？where fbizobjid？？in ("单据id")

delete from T_WFR_Assign？？where fbizobjid？？in ("单据id")

--2.删除工作流实例

select * from T_WFR_ProcInst where fprocinstid in (select fprocinstid from t_wfr_procinstref

where frefid='单据id')

delete from T_WFR_ProcInst where fprocinstid in (select fprocinstid from t_wfr_procinstref

where frefid='单据id')

3.删除即时消息

T_BAS_Message ftitle_l2 标题 fsender_l2 发送人作为条件

4.根据主题和当前处理人来删除或隐藏待办任务

select * from t_wfr_assign where fsubject_l2 like '消息主题'and fpersonusername_l2='职员名

称'

delete from t_wfr_assign where fsubject_l2 like '消息主题'and fpersonusername_l2='职员名

称'

update t_wfr_assign set fstate='4' where fsubject_l2 like '委托%'and fpersonusername_l2='职员名称'

5.人工终止工作流

select * from t_wfr_procinst where fcode='流程编码'

update t_wfr_procinst set fstate='closed.terminated' where fcode='流程编码'