ACTIVITI6直接从库中读取历史审批意见,不通过原生api的方式
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