状态描述
1正在执行 4准备停止 5停止 6失败 7成功
解决编写触发器
元数据表解析
t_ds_process_instance 任务实列
t_ds_task_instance 工作流实例
t_ds_task_instance 的 process_instance_id 字段 ,和 t_ds_process_instance id 是关联的
DELIMITER //
CREATE TRIGGER update_process_state BEFORE UPDATE ON t_ds_process_instance
FOR EACH ROW
BEGIN
IF OLD.state = 4 OR OLD.state = 5 THEN
SET NEW.state = 6;
UPDATE t_ds_task_instance
SET state = 6
WHERE process_instance_id = NEW.id;
END IF;
END //
DELIMITER ;