14.flowable 已办任务列表查询

项目地址：https://gitee.com/lwj/flowable.git 分支flowable-base
视频讲解地址
https://space.bilibili.com/485524575/channel/detail?cid=94579

1、演示

2、代码

这里也是通过sql来查询的

SELECT DISTINCTt1.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 endTimeFROMact_hi_taskinst t1LEFT 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_WHEREt1.END_TIME_ is not nullAND t1.ASSIGNEE_ = #{userCode}