查看某个用户的代办列表

查看某个应用或某些应用中我办理的流程信息。

userTenantId:用户所属租户ID
userId：用户ID

select
    task.PROC_INST_ID_ as instanceId, -- 流程实例ID
    task.ID_ as taskId, -- 任务ID
    hp.NAME_ as title, -- 流程标题
    rp.NAME_ as processName, -- 流程类型名称
    extend.DISPLAY_ALIAS_ AS processNameAlias, -- 流程类型别名
    task.NAME_ as stepName, -- 当前步骤
    task.ASSIGNEE_ as currentUser, -- 任务办理人
    IFNULL( task.ASSIGNEE_,hp.START_USER_ID_) AS lastStepUser, -- 上一步办理人
    IFNULL( task.CREATE_TIME_,hp.START_TIME_) AS lastStepDate, -- 上一步办理时间
    hp.START_TIME_ as createDate, -- 流程发起时间
    hp.START_USER_ID_ as creator -- 流程发起人
 from  ACT_RU_TASK task
    LEFT JOIN ACT_HI_PROCINST hp on  task.PROC_INST_ID_= hp.PROC_INST_ID_
    LEFT JOIN ACT_RE_PROCDEF rp on rp.ID_ = task.PROC_DEF_ID_
    LEFT JOIN DN_ACT_RE_EXTEND extend ON rp.KEY_ = extend.KEY_ and rp.TENANT_ID_ = extend.TENANT_ID_ 
    LEFT JOIN DN_ACT_USER_TASK_PROMPT pmt on  task.ID_ = pmt.TASK_ID_ AND task.PROC_INST_ID_ = pmt.PROC_INST_ID_
 where
    task.TENANT_ID_ = {userTenantId}
    and  task.SUSPENSION_STATE_ = 1
    and (task.ID_ IN (
            SELECT TASK_ID_
            FROM ACT_RU_IDENTITYLINK ident
            WHERE ident.USER_ID_ = '{userId}'
            and ident.TYPE_ = 'candidate' )
            and task.ASSIGNEE_ IS NULL
            AND  task.DELEGATION_ is null )
    or  task.ASSIGNEE_ = '{userId}'
    or (task.OWNER_= '{userId}'
        AND task.DELEGATION_ != 'RESOLVED')
order by `pmtTime` DESC,`createDate` DESC;

查看某个用户某个应用中的代办列表

可通过应用中流程定义对象和流程发布表关联，查询某些应用中的用户代办信息：
查看某个应用或某些应用中我办理的流程信息。

userTenantId:用户所属租户ID
userId：用户ID
volumeId：流程所属应用ID

select
    task.PROC_INST_ID_ as instanceId,
    task.ID_ as taskId,
    hp.NAME_ as title,
    rp.NAME_ as processName,
    extend.DISPLAY_ALIAS_ AS processNameAlias,
    task.NAME_ as stepName,
    task.ASSIGNEE_ as currentUser,
    IFNULL( task.ASSIGNEE_,hp.START_USER_ID_) AS lastStepUser,
    IFNULL( task.CREATE_TIME_,hp.START_TIME_) AS lastStepDate,
    hp.START_TIME_ as createDate,
    hp.START_USER_ID_ as creator
 from  ACT_RU_TASK task
    LEFT JOIN ACT_HI_PROCINST hp on  task.PROC_INST_ID_= hp.PROC_INST_ID_
    LEFT JOIN ACT_RE_PROCDEF rp on rp.ID_ = task.PROC_DEF_ID_
    LEFT JOIN DN_ACT_RE_EXTEND extend ON rp.KEY_ = extend.KEY_ and rp.TENANT_ID_ = extend.TENANT_ID_ 
    LEFT JOIN DN_ACT_USER_TASK_PROMPT pmt on  task.ID_ = pmt.TASK_ID_ AND task.PROC_INST_ID_ = pmt.PROC_INST_ID_
 where
    task.TENANT_ID_ = {userTenantId}
    and  task.SUSPENSION_STATE_ = 1
    and (task.ID_ IN (
            SELECT TASK_ID_
            FROM ACT_RU_IDENTITYLINK ident
            WHERE ident.USER_ID_ = '{userId}'
            and ident.TYPE_ = 'candidate' )
            and task.ASSIGNEE_ IS NULL
            AND  task.DELEGATION_ is null )
    or  task.ASSIGNEE_ = '{userId}'
    or (task.OWNER_= '{userId}' AND task.DELEGATION_ != 'RESOLVED')
    AND rp.KEY_  in (
        SELECT act_re_procdef.KEY_ from dn_file_property
        INNER JOIN act_re_procdef
        where dn_file_property.EXTRA_ like concat('%',act_re_procdef.KEY_,'%')
        and dn_file_property.VOLUME_ID in ('{volumeId}'))
order by `pmtTime` DESC,`createDate` DESC;