act_hi_detail

历史详情表

核心API: HistoryService

结构

案例

案例 3：查询【某个用户】在【某时间段】修改的所有流程变量（审计追责）。

SELECT 
    PROC_INST_ID_ AS 流程实例ID,
    NAME_ AS 变量名,
    TEXT_ AS 变量值,
    TIME_ AS 修改时间
FROM act_hi_detail
WHERE USER_ID_ = '1003'
  AND TYPE_ = 'VariableUpdate'
  AND TIME_ BETWEEN '2026-01-01 00:00:00' AND '2026-01-06 23:59:59'
ORDER BY TIME_ DESC;