oa流程发起后错误数据删除

//oa流程发起后错误数据删除

SELECT c.* FROM bladex_flow.act_ru_task  a ,  bladex.blade_process_oa_authority_management c 
where c.process_instance_id = a.PROC_INST_ID_ 
and c.application_person = ‘姚欣秀‘
and a.PROC_INST_ID_ not in (‘bb2e9604-735c-11eb-a09a-000c296ce21a‘);

SELECT a.* FROM bladex_flow.act_ru_actinst  a ,  bladex.blade_process_oa_authority_management c 
where c.process_instance_id = a.PROC_INST_ID_ 
and c.application_person = ‘姚欣秀‘
and a.PROC_INST_ID_ not in (‘bb2e9604-735c-11eb-a09a-000c296ce21a‘);