select count(1) as "count",type_id_ as "typeId" from ( SELECT * FROM bpm_definition ${ew.customSqlSegment} WHERE AND def_key_ in(${ew.paramNameValuePairs.defKeys}) AND 1=0 ORDER BY create_time_ DESC ) temp group by type_id_ SELECT * FROM bpm_definition where def_key_ = #{defKey} order by version_ SELECT * FROM bpm_definition where def_key_ = #{defKey} and is_main_ = 'N' order by version_ SELECT * FROM bpm_definition WHERE def_key_=#{defKey} and IS_MAIN_='Y' SELECT def_id_ FROM bpm_definition WHERE BPMN_DEF_ID_=#{bpmnDefId} SELECT * FROM bpm_definition WHERE BPMN_DEF_ID_=#{bpmnDefId} SELECT * FROM bpm_definition WHERE BPMN_DEPLOY_ID_=#{bpmnDeployId} select max(version_) from bpm_definition where def_key_= #{defKey} SELECT * FROM bpm_definition WHERE def_id_=#{id} and REV_=#{rev} UPDATE bpm_definition SET status_=#{status,jdbcType=VARCHAR} WHERE def_id_=#{defId} UPDATE bpm_definition SET is_main_='N',main_def_id_=#{defId} where def_key_ in ( select def_key_ from ( select def_key_ from bpm_definition where def_id_=#{defId}) tmp) and def_id_!=#{defId} UPDATE bpm_definition SET is_main_='Y',main_def_id_='0' where def_id_=#{defId} UPDATE bpm_definition SET type_id_=#{typeId},type_name_=#{typeName} where def_key_ in ( SELECT a.DEF_KEY_ FROM( SELECT DEF_KEY_ FROM bpm_definition WHERE def_id_ IN #{defId} ) a ) DELETE FROM bpm_definition WHERE def_key_=#{defKey} SELECT * FROM bpm_definition WHERE def_key_=#{defKey} DELETE FROM ACT_RE_DEPLOYMENT WHERE ID_ IN (SELECT DEPLOYMENT_ID_ FROM ACT_RE_PROCDEF WHERE KEY_=#{defKey}) DELETE FROM ACT_GE_BYTEARRAY WHERE DEPLOYMENT_ID_ IN (SELECT DEPLOYMENT_ID_ FROM ACT_RE_PROCDEF WHERE KEY_=#{defKey}) DELETE FROM ACT_RE_PROCDEF WHERE KEY_=#{defKey} DELETE FROM ACT_RU_EXECUTION WHERE ACT_RU_EXECUTION.PROC_DEF_ID_ in (select ID_ from ACT_RE_PROCDEF WHERE KEY_=#{defKey}) DELETE from ACT_RU_IDENTITYLINK where ACT_RU_IDENTITYLINK.PROC_INST_ID_ in ( select ACT_RU_EXECUTION.ID_ FROM ACT_RU_EXECUTION WHERE ACT_RU_EXECUTION.PROC_DEF_ID_ in (select ID_ from ACT_RE_PROCDEF WHERE KEY_=#{defKey})) DELETE from ACT_RU_VARIABLE where ACT_RU_VARIABLE.EXECUTION_ID_ in ( select ACT_RU_EXECUTION.ID_ FROM ACT_RU_EXECUTION WHERE ACT_RU_EXECUTION.PROC_DEF_ID_ in (select ID_ from ACT_RE_PROCDEF WHERE KEY_=#{defKey})) DELETE FROM ACT_RU_TASK WHERE PROC_DEF_ID_=#{defId} DELETE FROM ACT_RE_DEPLOYMENT WHERE ID_ in (select t.bpmn_deploy_id_ from bpm_definition t where t.def_id_=#{defId} ) DELETE FROM ACT_RE_PROCDEF where ID_ in (select def.bpmn_def_id_ from bpm_definition def where def.def_id_=#{defId} ) DELETE FROM ACT_GE_BYTEARRAY WHERE DEPLOYMENT_ID_ IN (select t.bpmn_deploy_id_ from bpm_definition t where t.def_id_=#{defId}) SELECT DEF_KEY_ FROM bpm_definition WHERE is_main_='Y' AND create_by_=#{userId} SELECT DEF_KEY_ FROM bpm_definition WHERE is_main_ = 'Y' AND type_id_ in #{typeId} SELECT * FROM bpm_definition WHERE is_main_='Y' and status_='deploy' and type_id_=#{typeId} and name_ like #{name} order by create_time_ desc SELECT DISTINCT bpm.def_id_ AS "def_id_", bpm.name_ AS "name_", bpm.DEF_KEY_ AS "def_key_", bpm.VERSION_ AS "version_", bpm.IS_MAIN_ AS "is_main_" FROM bpm_definition bpm INNER JOIN bpm_pro_bo bo ON bo.PROCESS_ID_ = bpm.DEF_ID_ WHERE bo.BO_NAME_ = #{alias} UPDATE bpm_definition SET TYPE_ID_=#{typeId} UPDATE bpm_pro_inst SET TYPE_ID_=#{typeId} WHERE PROC_DEF_KEY_=#{defKey} UPDATE bpm_pro_inst_hi SET TYPE_ID_=#{typeId} WHERE PROC_DEF_KEY_=#{defKey} UPDATE bpm_task SET TYPE_ID_=#{typeId} WHERE PROC_DEF_KEY_=#{defKey} UPDATE bpm_task_notice SET TYPE_ID_=#{typeId} WHERE PROC_DEF_ID_ in (select def_id_ from bpm_definition WHERE DEF_KEY_=#{defKey})