activity/flowable进行中实例用新的流程定义继续进行业务流程处理方法

select 
 concat('update ACT_GE_BYTEARRAY oldData,ACT_GE_BYTEARRAY newData set oldData.BYTES_ = newData.BYTES_ where oldData.DEPLOYMENT_ID_ =''',runData.ID_,''' and oldData.GENERATED_ =0 and newData.DEPLOYMENT_ID_ =''',lastdp2.ID_,''' and newData.GENERATED_ =0') 
 as sql_

from 
--运行中数据
(
select distinct dp.ID_  as ID_ ,dp.KEY_ as KEY_  from 
act_ru_actinst ins,
act_re_procdef def,
act_re_deployment dp
where ins.PROC_DEF_ID_=def.ID_ 
and def.DEPLOYMENT_ID_ =dp.ID_ 
) runData

,
--最新发版
(
	select  dp.ID_ as ID_ ,dp.key_  as KEY_ from act_re_deployment dp,
	(select KEY_  as key_ ,max(DEPLOY_TIME_) as dt from act_re_deployment ard  group by KEY_)lastdp
	where dp.KEY_ =lastdp.key_ and dp.DEPLOY_TIME_ =lastdp.dt
) lastdp2
where runData.KEY_=lastdp2.key_;