flowable已办任务查询

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}