Activiti工作流根据代办sql查询代办任务

最新推荐文章于 2024-08-22 00:13:17 发布

何超杰

最新推荐文章于 2024-08-22 00:13:17 发布

阅读量7.2k

点赞数

分类专栏： activiti

本文链接：https://blog.csdn.net/hechaojie_com/article/details/82382610

版权

activiti 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

1.代办sql如下：

SELECT * FROM (
    SELECT DISTINCT 
    RES1.*
    FROM ACT_RU_TASK RES1 inner join ACT_RE_PROCDEF D on RES1.PROC_DEF_ID_=D.ID_   
    inner join ACT_RU_VARIABLE V ON V.PROC_INST_ID_=RES1.PROC_INST_ID_
    WHERE RES1.ASSIGNEE_ = 'EMP2016112314173715944824' 
UNION ALL 
    SELECT DISTINCT
    RES1.*
        FROM ACT_RU_TASK RES1  inner join ACT_RE_PROCDEF D on RES1.PROC_DEF_ID_=D.ID_ 
        inner join ACT_RU_VARIABLE V ON V.PROC_INST_ID_=RES1.PROC_INST_ID_
        LEFT JOIN ACT_RU_IDENTITYLINK I ON I.TASK_ID_ = RES1.ID_
    WHERE RES1.ASSIGNEE_ IS NULL
        AND I.TYPE_ = 'candidate'
        AND I.USER_ID_ = 'EMP2016112314173715944824' 
    ) as tasktmp
ORDER BY CREATE_TIME_ DESC