14.flowable 已办任务列表查询

智者不为愚者谋，勇者不为怯者死。这篇文章主要讲述14.flowable 已办任务列表查询相关的知识，希望能为你提供帮助。

?
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