select*from act_ru_identitylink where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187';select*from act_ru_task where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187';select*from act_ru_actinst where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187';select*from ACT_RU_EXECUTION where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187';select*from act_ru_variable where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187';select*from act_hi_identitylink where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187';select*from act_hi_taskinst where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187';select*from act_hi_actinst where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187';select*from act_hi_detail where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187';select*from act_hi_procinst where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187';``select*from act_ru_identitylink where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187'or task_id_='1a0102dd-56bf-11ee-bd0b-a6db891ed187';select*from act_ru_task where execution_id_='a247d8f4-56b9-11ee-bd0b-a6db891ed187';select*from act_ru_actinst where execution_id_='a247d8f4-56b9-11ee-bd0b-a6db891ed187';select*from act_ru_variable where execution_id_='a247d8f4-56b9-11ee-bd0b-a6db891ed187';select long_,text_ from act_ru_variable where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187'and name_='nrOfInstances';select long_,text_ from act_ru_variable where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187'and name_='nrOfActiveInstances';select*from ACT_RU_EXECUTION where id_='a247d8f4-56b9-11ee-bd0b-a6db891ed187';select*from act_hi_identitylink where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187'or task_id_='1a0102dd-56bf-11ee-bd0b-a6db891ed187';select*from act_hi_taskinst where execution_id_='a247d8f4-56b9-11ee-bd0b-a6db891ed187';select*from act_hi_actinst where execution_id_='a247d8f4-56b9-11ee-bd0b-a6db891ed187';``select*from act_ru_identitylink where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187'or task_id_='1a0102dd-56bf-11ee-bd0b-a6db891ed187';select*from act_ru_task where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187'and id_='1a0102dd-56bf-11ee-bd0b-a6db891ed187';select*from act_ru_actinst where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187'and task_id_='1a0102dd-56bf-11ee-bd0b-a6db891ed187';select*from act_hi_identitylink where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187'or task_id_='1a0102dd-56bf-11ee-bd0b-a6db891ed187';select*from act_hi_taskinst where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187'and id_='1a0102dd-56bf-11ee-bd0b-a6db891ed187';select*from act_hi_actinst where proc_inst_id_='baadc7cb-56be-11ee-bd0b-a6db891ed187'and task_id_='1a0102dd-56bf-11ee-bd0b-a6db891ed187';
删除方法
运行中数据
@Delete(value ="delete from act_ru_identitylink where task_id_=#{taskId}")voiddeleteRunIdentitylink(@Param("taskId")String taskId);@Delete(value ="delete from act_ru_task where proc_inst_id_=#{processInstanceId} and id_=#{taskId}")voiddeleteRunTask(@Param("processInstanceId")String processInstanceId,@Param("taskId")String taskId);@Delete(value ="delete from act_ru_actinst where proc_inst_id_=#{processInstanceId} and task_id_=#{taskId}")voiddeleteRunActinst(@Param("processInstanceId")String processInstanceId,@Param("taskId")String taskId);@Delete(value ="delete from ACT_RU_EXECUTION where id_=#{executionId}")voiddeleteRunExecution(@Param("executionId")String executionId);@Delete(value ="delete from act_ru_variable where execution_id_=#{executionId}")voiddeleteRunVariable(@Param("executionId")String executionId);@Update(value ="UPDATE act_ru_variable set long_=long_-1,text_=text_-1 where proc_inst_id_=#{processInstanceId} and name_=#{name}")voidupdateRunVariable(@Param("processInstanceId")String processInstanceId,@Param("name")String name);
历史数据
@Delete(value ="delete from act_hi_identitylink where task_id_=#{taskId}")voiddeleteHisIdentitylink(@Param("taskId")String taskId);@Delete(value ="delete from act_hi_taskinst where proc_inst_id_=#{processInstanceId} and id_=#{taskId}")voiddeleteHisTask(@Param("processInstanceId")String processInstanceId,@Param("taskId")String taskId);@Delete(value ="delete from act_hi_actinst where proc_inst_id_=#{processInstanceId} and task_id_=#{taskId}")voiddeleteHisActinst(@Param("processInstanceId")String processInstanceId,@Param("taskId")String taskId);