代办任务SQL查询
基于用户ID查询
SELECT DISTINCT
RES.*
FROM
ACT_RU_TASK RES
LEFT JOIN ACT_RU_IDENTITYLINK I ON I.TASK_ID_ = RES.ID_
INNER JOIN ACT_RE_PROCDEF D ON RES.PROC_DEF_ID_ = D.ID_
WHERE
D.KEY_ = 'sjwf'
AND (
RES.ASSIGNEE_ = '55312'
OR (
RES.ASSIGNEE_ IS NULL
AND I.TYPE_ = 'candidate'
AND (I.USER_ID_ = '55312')
)
)
说明:sjwf 为 流程key;55312为用户ID。
基于角色ID查询
SELECT DISTINCT
RES.*
FROM
ACT_RU_TASK RES
INNER JOIN ACT_RU_IDENTITYLINK I ON I.TASK_ID_ = RES.ID_
INNER JOIN ACT_RE_PROCDEF D ON RES.PROC_DEF_ID_ = D.ID_
WHERE
D.KEY_ = "gwzc"
AND RES.ASSIGNEE_ IS NULL
AND I.TYPE_ = 'candidate'
AND (I.GROUP_ID_ IN("4"))
说明:gwzc为 流程key;4为角色ID。
已办任务SQL查询
SELECT DISTINCT
RES.*
FROM
ACT_HI_TASKINST RES
INNER JOIN ACT_RE_PROCDEF D ON RES.PROC_DEF_ID_ = D.ID_
WHERE
D.KEY_ = 'sjwf'
AND RES.ASSIGNEE_ = '56060'
AND RES.END_TIME_ IS NOT NULL
说明:sjwf为 流程key;56060为用户ID。