工作流实战_13_flowable 待办任务列表查询
生活随笔
收集整理的這篇文章主要介紹了
工作流实战_13_flowable 待办任务列表查询
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
| 代碼分支 | flowable-base |
| 視頻講解地址 | https://space.bilibili.com/485524575/channel/detail?cid=94579 |
| 0000001 | test |
| 0000002 | test |
| 0000003 | test |
| 0000004 | test |
文章目錄
- 1. 演示
- 2. 代碼分享
1. 演示
2. 代碼分享
這里我使用的sql查詢的,你也可以使用api接口
SELECT DISTINCTt1.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 startTimeFROMact_ru_task t1INNER 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_WHEREt2.BUSINESS_KEY_ IS NOT NULLAND (t1.ASSIGNEE_ = #{userCode}OR (t1.ASSIGNEE_ IN (SELECTG.group_id_FROMact_id_membership GWHEREG.user_id_ = #{userCode}))OR ((t1.ASSIGNEE_ IS NULLOR t1.ASSIGNEE_ = '')AND (t3.USER_ID_ = #{userCode}OR t3.GROUP_ID_ IN (SELECTg.group_id_FROMact_id_membership gWHEREg.user_id_ = #{userCode}))))總結
以上是生活随笔為你收集整理的工作流实战_13_flowable 待办任务列表查询的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: 负载均衡工具 haproxy 集群安装部
- 下一篇: 史上最详细的IDEA优雅整合Maven+