eip项目中审批流删除sql

 
   //人员培训记录更新表
   update blade_employee_training_record_detail a,blade_employee_training_user_dept b set a.dept_name=b.user_dept,a.parent_dept=b.user_parent_dept  where a.user_name=b.user_name
   
   
  代办事务表  act_ru_task  act_ru_actinst   办结事务 act_hi_varinst  act_hi_taskinst  已发事务表 act_hi_procinst
  //删除流程信息
 select a.* from bladex_flow.act_ru_task a LEFT JOIN bladex.blade_process_purchase_request b on a.PROC_INST_ID_=b.process_instance_id where b.apply_time<'2021-05-10'

select a.* from bladex_flow.act_ru_actinst a LEFT JOIN bladex.blade_process_purchase_request b on a.PROC_INST_ID_=b.process_instance_id where b.apply_time<'2021-05-10'

select a.* from bladex_flow.act_hi_varinst a LEFT JOIN bladex.blade_process_purchase_request b on a.PROC_INST_ID_=b.process_instance_id where b.apply_time<'2021-05-10'

select a.* from bladex_flow.act_hi_taskinst a LEFT JOIN bladex.blade_process_purchase_request b on a.PROC_INST_ID_=b.process_instance_id where b.apply_time<'2021-05-10'

select a.* from bladex_flow.act_hi_procinst a LEFT JOIN bladex.blade_process_purchase_request b on a.PROC_INST_ID_=b.process_instance_id where b.apply_time<'2021-05-10'

act_hi_procinst 发起的流程信息
act_hi_actinst 流程审批信息详细
act_hi_varinst 流程变量历史表

//获取流程实例id 
select process_instance_id from blade_process_purchase_request where order_code='2021060400002'
 //删除流程信息
delete bladex_flow.act_ru_task ,bladex_flow.act_ru_actinst ,bladex_flow.act_hi_varinst ,bladex_flow.act_hi_taskinst ,bladex_flow.act_hi_procinst 
from bladex_flow.act_ru_task,
	bladex_flow.act_ru_actinst,
	bladex_flow.act_hi_varinst,
	bladex_flow.act_hi_taskinst,
	bladex_flow.act_hi_procinst
where bladex_flow.act_ru_task.PROC_INST_ID_ = '2d361f7a-c488-11eb-866c-000c29e1f9a5' 
and bladex_flow.act_ru_actinst.PROC_INST_ID_ ='2d361f7a-c488-11eb-866c-000c29e1f9a5'
and bladex_flow.act_hi_varinst.PROC_INST_ID_ ='2d361f7a-c488-11eb-866c-000c29e1f9a5'
and bladex_flow.act_hi_taskinst.PROC_INST_ID_ ='2d361f7a-c488-11eb-866c-000c29e1f9a5' 
and bladex_flow.act_hi_procinst.PROC_INST_ID_ ='2d361f7a-c488-11eb-866c-000c29e1f9a5'