ACTIVITI6直接从库中读取历史审批意见,不通过原生api的方式

1136

ACTIVITI6的部分原生api过于难用,为了方便与业务表想契合,直接进行读库操作来获取审批意见

SELECT
	t1.ACT_ID_ AS activityId,
	t1.ACT_NAME_ AS activityName,
	t2.MESSAGE_ AS `comment`,
	t2.PROC_INST_ID_ AS instanceId,
	t2.TASK_ID_ AS taskId,
	t2.TIME_ AS endTime,
	t3.`name` AS assigneeName 
FROM
	act_hi_actinst t1
	LEFT JOIN act_hi_comment t2 ON t1.TASK_ID_ = t2.TASK_ID_
	LEFT JOIN #{你的用户表} t3 ON t1.ASSIGNEE_ = #{你的用户表关联账号} 
WHERE
	t1.PROC_INST_ID_ = #{实例id}
	AND t1.ACT_TYPE_ = 'userTask' 
	AND t2.TIME_ IS NOT NULL 
ORDER BY
	t2.TIME_ DESC