Acitiviti工作流实现查询待办、已办、办结、撤销等任务

2024年1月23日发(作者：)

SELECT cast(_INST_ID_ as nvarchar2(255)) PROC_INST_ID_, cast('' as nvarchar2(255)) END_ACT_ID_, cast(_ as nvarchar2(255)) actName, cast(_ as nvarchar2(255)) actName_T, cast(EE_ as nvarchar2(255)) assignee, cast( as nvarchar2(255)) candidate, 2 AS taskstatus, cast('' as DATE) bltime, cast(_ as nvarchar2(255)) prdekey, cast(_ as nvarchar2(255)) prdenameFROM _RU_TASK ALEFT OUTER JOIN _RE_PROCDEF PRDE ON _DEF_ID_ = _LEFT OUTER JOIN _RU_IDENTITYLINK IDEN ON _ID_ = _LEFT OUTER JOIN ERREF R ON _ID_ = 1.4 V_TASKLIST_YB 已办任务视图表SELECT DISTINCT cast(_INST_ID_ as nvarchar2(255)) PROC_INST_ID_, cast(_ACT_ID_ as nvarchar2(255)) END_ACT_ID_, cast(_ as nvarchar2(255)) actName, cast(_ as nvarchar2(255)) actName_T, cast(EE_ as nvarchar2(255)) assignee, cast('' as nvarchar2(255)) candidate, 2 AS taskstatus, _TIME_ bltime, cast(_ as nvarchar2(255)) prdekey, cast(_ as nvarchar2(255)) prdenameFROM _HI_PROCINST HLEFT OUTER JOIN _HI_TASKINST T ON _INST_ID_ = _INST_ID_LEFT OUTER JOIN _RE_PROCDEF PRDE ON H .PROC_DEF_ID_ = _LEFT OUTER JOIN _RU_TASK A ON _INST_ID_ = _INST_ID_WHERE (_TIME_ IS NULL)AND (_TIME_ IS NOT NULL)1.5 V_TASKLIST_SYYB 所有已办任务视图表

SELECT DISTINCT cast(_INST_ID_ as nvarchar2(255)) PROC_INST_ID_, cast(_ACT_ID_ as nvarchar2(255)) END_ACT_ID_, cast(NVL(_,NVL2(_ACT_ID_, '任务完结','撤销完结')) as nvarchar2(255)) AS actName, cast(_ as nvarchar2(255)) AS actName_T, cast(EE_ as nvarchar2(255)) AS assignee, cast('' as nvarchar2(255)) AS candidate, 2 AS taskstatus, _TIME_ AS bltime, cast(_ as nvarchar2(255)) AS prdekey, cast(_ as nvarchar2(255)) AS prdenameFROM _HI_PROCINST HLEFT OUTER JOIN _HI_TASKINST T ON _INST_ID_ = _INST_ID_LEFT OUTER JOIN _RE_PROCDEF PRDE ON _DEF_ID_ = _LEFT OUTER JOIN _RU_TASK A ON _INST_ID_ = _INST_ID_WHERE (_TIME_ IS NOT NULL)AND ( NOT EXISTS ( SELECT PROC_INST_ID_ FROM ASSETSMETADATA.V_TASKLIST_DB D WHERE (PROC_INST_ID_ = _INST_ID_) AND (candidate = EE_) AND (actName_T = _) OR ( PROC_INST_ID_ = _INST_ID_ ) AND (actName_T = _) AND (assignee = EE_) OR (PROC_INST_ID_ = _INST_ID_) AND (candidate = EE_) AND (actName LIKE '%上报%') AND (_ LIKE '%上报%') OR (PROC_INST_ID_ = _INST_ID_) AND (assignee = EE_) AND (actName LIKE '%上报%') AND (_ LIKE '%上报%') ))ORDER BY bltime DESC1.5 V_TASKLIST_BJ 办结任务视图表

SELECT DISTINCT cast(_INST_ID_ as nvarchar2(255)) PROC_INST_ID_, cast(_ACT_ID_ as nvarchar2(255)) END_ACT_ID_, cast('结束' as nvarchar2(255)) actName, cast('结束' as nvarchar2(255)) actName_T, cast(EE_ as nvarchar2(255)) assignee, cast('' as nvarchar2(255)) candidate, 3 taskstatus, _TIME_ bltime, cast(_ as nvarchar2(255)) prdekey, cast(_ as nvarchar2(255)) prdenameFROM _HI_PROCINST HLEFT OUTER JOIN

(SELECT * FROM _HI_TASKINST)TON _INST_ID_ = _INST_ID_LEFT OUTER JOIN

(SELECT * FROM _RE_PROCDEF)PRDE

ON _DEF_ID_ = _WHERE (_TIME_ IS NOT NULL) AND (_ACT_ID_ IS NOT NULL)1.6 V_TASKLIST_CX 撤销任务视图表SELECT DISTINCT cast(_INST_ID_ as nvarchar2(255)) PROC_INST_ID_, cast(_ACT_ID_ as nvarchar2(255)) END_ACT_ID_, cast('结束' as nvarchar2(255)) AS actName, cast('结束' as nvarchar2(255)) AS actName_T, cast(EE_ as nvarchar2(255)) AS assignee, cast('' as nvarchar2(255)) AS candidate, 5 AS taskstatus, _TIME_ AS bltime, cast(_ as nvarchar2(255)) AS prdekey, cast(_ as nvarchar2(255)) AS prdenameFROM _HI_PROCINST HLEFT OUTER JOIN _HI_TASKINST T ON _INST_ID_ = _INST_ID_LEFT OUTER JOIN _RE_PROCDEF PRDE ON _DEF_ID_ = _WHERE (_TIME_ IS NOT NULL)AND (_ACT_ID_ IS NULL)2.后台代码逻辑 @Override public ArrayList findActList(Integer rows,Integer page, HashMap paramMap) { String sql = ""; if(("checkmessage")!=null&&mpty(("checkmessage").toString())){// sql = "select * from ASSETSMETADATA.V_ACTLIST V where PROCINSTID= ? and clyj is not null and clyj <> '完成' ORDER BY START_TIME_"; sql = "select * from ASSETSMETADATA.V_ACTLIST V where PROCINSTID= ? and clyj is not null ORDER BY START_TIME_"; }else{ sql = "SELECT V.*" + " FROM ASSETSMETADATA.V_ACTLIST V WHERE procInstId = ? ORDER BY _TIME_"; } List