工作流實戰_13_flowable 待辦任務清單查詢

項目位址	​​https://gitee.com/lwj/flowable.git​​
代碼分支	flowable-base
視訊講解位址	​​https://space.bilibili.com/485524575/channel/detail?cid=94579​​

使用者名	密碼
0000001	test
0000002	test
0000003	test
0000004	test

文章目錄

• ​​1. 示範​​
• ​​2. 代碼分享​​

1. 示範

2. 代碼分享

SELECT DISTINCT
            t1.ID_ AS taskId,
            t1.NAME_ AS taskName,
            t2.NAME_ AS formName,
            t2.TENANT_ID_ AS systemSn,
            t2.BUSINESS_KEY_ AS businessKey,
            t2.PROC_INST_ID_ AS processInstanceId,
            t1.CREATE_TIME_ AS startTime
        FROM
            act_ru_task t1
        INNER JOIN act_ru_execution t2 ON t1.PROC_INST_ID_ = t2.PROC_INST_ID_
        LEFT JOIN act_ru_identitylink t3 ON t3.TASK_ID_ = t1.ID_
        WHERE
            t2.BUSINESS_KEY_ IS NOT NULL
        AND (
            t1.ASSIGNEE_ = #{userCode}
            OR (
                t1.ASSIGNEE_ IN (
                    SELECT
                        G.group_id_
                    FROM
                        act_id_membership G
                    WHERE
                        G.user_id_ = #{userCode}
                )
            )
            OR (
                (
                    t1.ASSIGNEE_ IS NULL
                    OR t1.ASSIGNEE_ = ''
                )
                AND (
                    t3.USER_ID_ = #{userCode}
                    OR t3.GROUP_ID_ IN (
                        SELECT
                            g.group_id_
                        FROM
                            act_id_membership g
                        WHERE
                            g.user_id_ = #{userCode}
                    )
                )
            )
        )