获取工作流审批意见原创
2人赞赏了该文章
734次浏览
编辑于2022年01月19日 15:02:38
FOBJECTTYPEID:业务对象标识
FKEYVALUE:单据主键
FNUMBER:流程实例ID
FSTATUS:流程实例状态(1:完成,2:运行,4:终止)
select a.FOBJECTTYPEID,a.FKEYVALUE,replace(wm_concat(to_char('【' || a.FDISPOSITION || '】' || chr(13) || chr(10) || c.FNAME || ':' || to_char(FDEALTIME,'yyyy-mm-dd hh24:mi:ss'))),',',chr(13) || chr(10)) FDISPOSITION from T_WF_APPROVALASSIGN a left join T_WF_APPROVALITEM b on a.FAPPROVALASSIGNID = b.FAPPROVALASSIGNID left join T_WF_ASSIGN aa on a.FASSIGNID = aa.FASSIGNID left join T_WF_PROCINST p on aa.FPROCINSTID = p.FPROCINSTID left join T_SEC_USER c on b.FRECEIVERID = c.FUSERID where a.FRESULT is not null and a.FOBJECTTYPEID='CN_PAYAPPLY' and p.FSTATUS in (1,2) group by a.FOBJECTTYPEID,a.FKEYVALUE
推荐阅读