SELECT DISTINCT
t1.ID_ AS taskId,
t1.NAME_ AS taskName,
t3.NAME_ AS formName,
t3.BUSINESS_KEY_ AS businessKey,
t3.PROC_INST_ID_ AS processInstanceId,
t3.TENANT_ID_ AS systemSn,
t1.START_TIME_ AS startTime,
t1.END_TIME_ AS endTime,
t5.KEY_ AS modelKey,t3.PROC_DEF_ID_ as processDefinitionId
FROM
act_hi_taskinst t1
JOIN act_hi_procinst t3 ON t1.PROC_INST_ID_ = t3.PROC_INST_ID_
LEFT JOIN act_re_procdef t5 ON t3.PROC_DEF_ID_ = t5.ID_
WHERE
t1.END_TIME_ IS NOT NULL
AND t1.ASSIGNEE_ = #{userNameId}
flowable已办任务查询
最新推荐文章于 2024-08-21 08:16:57 发布