工作流任务后台处理命令

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 f