SELECT DISTINCT
t1.ID_ AS taskId,
t1.NAME_ AS taskName,
t2.NAME_ AS formName,
t2.TENANT_ID_ AS systemSn,
t2.BUSINESS_KEY_ AS businessKey,
t2.PROC_INST_ID_ AS processInstanceId,
t1.CREATE_TIME_ AS startTime,
t2.START_TIME_ AS flowStartTime,
t2.START_USER_ID_ AS startUserId,
t4.NAME_ AS modelName,
t1.PRIORITY_ AS priority,
t1.PROC_DEF_ID_ AS processDefinitionId,
t1.EXECUTION_ID_ AS executionId,
t1.ASSIGNEE_ as assignee,
t4.KEY_ AS modelKey,
t1.TASK_DEF_KEY_ as nodeId
FROM
act_ru_task t1
INNER JOIN act_ru_execution t2 ON t1.PROC_INST_ID_ = t2.PROC_INST_ID_
LEFT JOIN act_re_procdef t4 ON t4.ID_ = t1.PROC_DEF_ID_
LEFT JOIN act_ru_identitylink t3 ON t3.TASK_ID_ = t1.ID_
WHERE
t2.START_USER_ID_ =#{userNameId}
AND t2.BUSINESS_KEY_ IS NOT NULL
flowable在办任务查询
最新推荐文章于 2024-08-21 07:53:57 发布