Activiti记录

Activii 使用记录 –持续更新

1. 根据流程实例 ID 删除正在运行的流程 以及流程所有数据

DELETE FROM ACT_HI_ATTACHMENT T WHERE T.PROC_INST_ID_='7426459';
DELETE FROM ACT_HI_COMMENT T WHERE T.PROC_INST_ID_='7426459';
DELETE FROM ACT_HI_ACTINST T WHERE T.PROC_INST_ID_='7426459';
DELETE FROM ACT_HI_DETAIL T WHERE T.PROC_INST_ID_='7426459';
DELETE FROM ACT_HI_IDENTITYLINK T WHERE T.TASK_ID_ IN (
   SELECT T.ID_ FROM ACT_RU_TASK T WHERE T.PROC_INST_ID_='7426459'
    UNION ALL
   SELECT T.ID_ FROM ACT_HI_TASKINST T WHERE T.PROC_INST_ID_ ='7426459'
) OR T.PROC_INST_ID_ ='7426459';
DELETE FROM ACT_HI_TASKINST T WHERE T.PROC_INST_ID_='7426459';
DELETE FROM ACT_HI_PROCINST T WHERE T.PROC_INST_ID_='7426459';
DELETE FROM ACT_HI_VARINST T WHERE T.PROC_INST_ID_='7426459';
DELETE FROM ACT_RU_EVENT_SUBSCR T WHERE T.PROC_INST_ID_='7426459';
DELETE FROM ACT_RU_IDENTITYLINK T WHERE T.TASK_ID_ IN (
  SELECT T.ID_ FROM ACT_RU_TASK T WHERE T.PROC_INST_ID_='7426459'
) OR  T.PROC_INST_ID_='7426459';
DELETE FROM ACT_RU_VARIABLE T WHERE T.PROC_INST_ID_='7426459';
DELETE FROM ACT_RU_TASK T WHERE T.PROC_INST_ID_='7426459';
DELETE FROM ACT_RU_EXECUTION T WHERE T.PROC_INST_ID_='7426459';

2. 清除所有流程数据

DELETE  FROM  ACT_HI_ATTACHMENT WHERE 1=1;
DELETE  FROM  ACT_HI_COMMENT WHERE 1=1;
DELETE  FROM  ACT_HI_DETAIL WHERE 1=1;
DELETE  FROM  ACT_HI_ACTINST WHERE 1=1;
DELETE  FROM  ACT_HI_IDENTITYLINK WHERE 1=1;
DELETE  FROM  ACT_HI_PROCINST WHERE 1=1;
DELETE  FROM  ACT_HI_TASKINST WHERE 1=1;
DELETE  FROM  ACT_HI_VARINST WHERE 1=1;
DELETE  FROM  ACT_RU_IDENTITYLINK WHERE 1=1;
DELETE  FROM  ACT_RU_TASK WHERE 1=1;
DELETE  FROM  ACT_RU_VARIABLE WHERE 1=1;
DELETE  FROM  ACT_RU_EXECUTION WHERE PARENT_ID_ IS NOT NULL AND IS_SCOPE_=0 ;
DELETE  FROM  ACT_RU_EXECUTION WHERE PARENT_ID_ IS NOT NULL AND IS_SCOPE_=1 ;
DELETE  FROM  ACT_RU_EXECUTION WHERE 1=1;

3. 待办待签收结合视图

CREATE or replace VIEW V_TASKLIST AS
SELECT A.ID_           AS TASK_ID,
       A.PROC_INST_ID_    PROC_INST_ID,
       A.TASK_DEF_KEY_ AS ACT_ID,
       A.NAME_         AS ACT_NAME,
       A.ASSIGNEE_     AS ASSIGNEE,
       A.DELEGATION_   AS DELEGATION_ID,
       A.DESCRIPTION_  AS DESCRIPTION,
       A.CREATE_TIME_  AS CREATE_TIME,
       A.DUE_DATE_     AS DUE_DATE,
       I.USER_ID          CANDIDATE
FROM ACT_RU_TASK A
         LEFT JOIN (SELECT DISTINCT *
                    FROM (SELECT TASK_ID_, (USER_ID_) USER_ID
                          FROM ACT_RU_IDENTITYLINK I,
                               ACT_RU_TASK T
                          WHERE TASK_ID_ IS NOT NULL
                            AND USER_ID_ IS NOT NULL
                            AND I.TASK_ID_ = T.ID_
                            AND T.ASSIGNEE_ IS NULL
                            AND TYPE_ = 'candidate'
                          UNION
                          SELECT TASK_ID_, R.USER_ID
                          FROM ACT_RU_IDENTITYLINK I,
                               sys_user_role R,
                               ACT_RU_TASK T
                          WHERE I.TASK_ID_ IS NOT NULL
                            AND I.GROUP_ID_ IS NOT NULL
                            AND I.TASK_ID_ = T.ID_
                            AND T.ASSIGNEE_ IS NULL
                            AND TYPE_ = 'candidate'
                            AND I.GROUP_ID_ = R.ROLE_ID) U) I

                   ON A.ID_ = I.TASK_ID_;