ACTIVITI sql查询待办、已办业务

最新推荐文章于 2024-11-07 09:08:11 发布

cxy_jzli

最新推荐文章于 2024-11-07 09:08:11 发布

阅读量1.3k

点赞数

文章标签： sql 数据库

本文链接：https://blog.csdn.net/cxy_jzli/article/details/127527047

版权

查询待办业务：

select

v.*, t.id_ as taskid

from

act_ru_task t

inner join

act_ru_execution e on t.proc_inst_id_ = e.proc_inst_id_

inner join

act_re_procdef p on e.proc_def_id_ = p.id_

left join

provider v on v.id = e.business_key_

where

e.parent_id_ is null

and e.business_key_ is not null

and t.assignee_ ='admin'

//基于用户组来查询

SELECT DISTINCT
	RES.*
FROM
	ACT_RU_TASK RES
INNER JOIN ACT_RU_IDENTITYLINK I ON I.TASK_ID_ = RES.ID_
INNER JOIN ACT_RE_PROCDEF D ON RES.PROC_DEF_ID_ = D.ID_
WHERE
	D.KEY_ = "gwzc"
AND RES.ASSIGNEE_ IS NULL
AND I.TYPE_ = 'candidate'
AND (I.GROUP_ID_ IN("4"))

查询已办业务：

//需要通过business key关联到业务表

SELECT DISTINCT
	RES.*
FROM
	ACT_HI_TASKINST RES
INNER JOIN ACT_RE_PROCDEF D ON RES.PROC_DEF_ID_ = D.ID_
WHERE
	D.KEY_ = 'sjwf'
AND RES.ASSIGNEE_ = '56060'
AND RES.END_TIME_ IS NOT NULL