租户级

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

我发起的流程（全部）

SELECT
    hp.ID_ AS instanceId,
    hp.NAME_ AS title,
    rp.NAME_ AS processName,
    extend.DISPLAY_ALIAS_ AS processNameAlias,
    hp.END_TIME_ AS endDate,
    hp.DELETE_REASON_ AS state,
    hp.START_TIME_ AS createDate,
    hp.START_USER_ID_ AS creator
  FROM ACT_HI_PROCINST hp
    LEFT JOIN ACT_RE_PROCDEF rp ON rp.ID_ = hp.PROC_DEF_ID_
    LEFT JOIN DN_ACT_RE_EXTEND extend ON rp.KEY_=extend.KEY_ and rp.TENANT_ID_=extend.TENANT_ID_
  WHERE
    hp.TENANT_ID_ = '{userTenantId}'
    AND hp.START_USER_ID_ = '{userId}'
  order by `createDate` DESC

我发起的流程（办理中）

SELECT
    hp.ID_ AS instanceId,
    hp.NAME_ AS title,
    rp.NAME_ AS processName,
    extend.DISPLAY_ALIAS_ AS processNameAlias,
    hp.END_TIME_ AS endDate,
    hp.DELETE_REASON_ AS state,
    hp.START_TIME_ AS createDate,
    hp.START_USER_ID_ AS creator
  FROM ACT_HI_PROCINST hp
    LEFT JOIN ACT_RE_PROCDEF rp ON rp.ID_ = hp.PROC_DEF_ID_
    LEFT JOIN DN_ACT_RE_EXTEND extend ON rp.KEY_=extend.KEY_ and rp.TENANT_ID_=extend.TENANT_ID_
  WHERE
    hp.TENANT_ID_ = '{userTenantId}'
    AND hp.START_USER_ID_ = '{userId}'
    AND END_TIME_ is null
  order by `createDate` DESC

我发起的流程（已办结）

SELECT
    hp.ID_ AS instanceId,
    hp.NAME_ AS title,
    rp.NAME_ AS processName,
    extend.DISPLAY_ALIAS_ AS processNameAlias,
    hp.END_TIME_ AS endDate,
    hp.DELETE_REASON_ AS state,
    hp.START_TIME_ AS createDate,
    hp.START_USER_ID_ AS creator
  FROM ACT_HI_PROCINST hp
    LEFT JOIN ACT_RE_PROCDEF rp ON rp.ID_ = hp.PROC_DEF_ID_
    LEFT JOIN DN_ACT_RE_EXTEND extend ON rp.KEY_=extend.KEY_ and rp.TENANT_ID_=extend.TENANT_ID_
  WHERE
    hp.TENANT_ID_ = '{userTenantId}'
    AND hp.START_USER_ID_ = '{userId}'
    AND END_TIME_ is not null
 order by `createDate` DESC

应用级

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

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

我发起的流程（全部）

SELECT
    hp.ID_ AS instanceId,
    hp.NAME_ AS title,
    rp.NAME_ AS processName,
    extend.DISPLAY_ALIAS_ AS processNameAlias,
    hp.END_TIME_ AS endDate,
    hp.DELETE_REASON_ AS state,
    hp.START_TIME_ AS createDate,
    hp.START_USER_ID_ AS creator
  FROM ACT_HI_PROCINST hp
    LEFT JOIN ACT_RE_PROCDEF rp ON rp.ID_ = hp.PROC_DEF_ID_
    LEFT JOIN DN_ACT_RE_EXTEND extend ON rp.KEY_=extend.KEY_ and rp.TENANT_ID_=extend.TENANT_ID_
  WHERE
    hp.TENANT_ID_ = '{userTenantId}'
    AND hp.START_USER_ID_ = '{userId}'
    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 `createDate` DESC

我发起的流程（办理中）

SELECT
    hp.ID_ AS instanceId,
    hp.NAME_ AS title,
    rp.NAME_ AS processName,
    extend.DISPLAY_ALIAS_ AS processNameAlias,
    hp.END_TIME_ AS endDate,
    hp.DELETE_REASON_ AS state,
    hp.START_TIME_ AS createDate,
    hp.START_USER_ID_ AS creator
  FROM ACT_HI_PROCINST hp
    LEFT JOIN ACT_RE_PROCDEF rp ON rp.ID_ = hp.PROC_DEF_ID_
    LEFT JOIN DN_ACT_RE_EXTEND extend ON rp.KEY_=extend.KEY_ and rp.TENANT_ID_=extend.TENANT_ID_
  WHERE
    hp.TENANT_ID_ = '{userTenantId}'
    AND hp.START_USER_ID_ = '{userId}'
    AND END_TIME_ is not null
    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 `createDate` DESC

我发起的流程（已办结）

SELECT
    hp.ID_ AS instanceId,
    hp.NAME_ AS title,
    rp.NAME_ AS processName,
    extend.DISPLAY_ALIAS_ AS processNameAlias,
    hp.END_TIME_ AS endDate,
    hp.DELETE_REASON_ AS state,
    hp.START_TIME_ AS createDate,
    hp.START_USER_ID_ AS creator
  FROM ACT_HI_PROCINST hp
    LEFT JOIN ACT_RE_PROCDEF rp ON rp.ID_ = hp.PROC_DEF_ID_
    LEFT JOIN DN_ACT_RE_EXTEND extend ON rp.KEY_=extend.KEY_ and rp.TENANT_ID_=extend.TENANT_ID_
  WHERE
    hp.TENANT_ID_ = '{userTenantId}'
    AND hp.START_USER_ID_ = '{userId}'
    AND END_TIME_ is not null
    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 `createDate` DESC