1、演示
2、代码
这里也是通过sql来查询的
SELECT DISTINCT
t1.ID_ AS taskId,
t1.NAME_ AS taskName,
t2.FIRST_ AS approver,
t2.ID_ AS approverId,
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
FROM
act_hi_taskinst t1
LEFT JOIN act_id_user t2 ON t1.ASSIGNEE_ = t2.ID_
LEFT JOIN act_hi_procinst t3 ON t1.PROC_INST_ID_ = t3.PROC_INST_ID_
WHERE
t1.END_TIME_ is not null
AND t1.ASSIGNEE_ = #{userCode}