activiti视图查询待办

海蓝遇到鲸

已于 2022-02-28 15:55:59 修改

阅读量279

点赞数 1

分类专栏： Mysql 文章标签： mysql

于 2022-02-28 15:52:15 首次发布

本文链接：https://blog.csdn.net/qq_41021000/article/details/123184384

版权

Mysql 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

该SQL查询用于获取Activiti工作流中的待办任务信息，包括任务ID、流程实例ID、流程定义ID、任务定义键、任务名称、指派人、委托信息、描述、创建时间和到期时间等。同时，通过LEFT JOIN操作结合了用户候选人数据，确保未分配的任务能显示候选人的信息，并关联了流程定义表以获取流程定义的关键信息。

摘要由CSDN通过智能技术生成

activiti视图查询待办

SELECT
	`a`.`ID_` AS `TASK_ID`,
	`a`.`PROC_INST_ID_` AS `PROC_INST_ID`,
	`a`.`PROC_DEF_ID_` AS `PROC_DEF_ID_`,
	`a`.`TASK_DEF_KEY_` AS `ACT_ID`,
	`a`.`NAME_` AS `ACT_NAME`,
	`a`.`ASSIGNEE_` AS `ASSIGNEE`,
	`a`.`DELEGATION_` AS `DELEGATION_ID`,
	`a`.`DESCRIPTION_` AS `DESCRIPTION`,
	`a`.`CREATE_TIME_` AS `CREATE_TIME`,
	`a`.`DUE_DATE_` AS `DUE_DATE`,
	`i`.`USER_ID` AS `CANDIDATE`,
	`f`.`KEY_` AS `KEY_` 
FROM
	((
			`act_ru_task` `a`
			LEFT JOIN (
			SELECT DISTINCT
				`u`.`TASK_ID_` AS `TASK_ID_`,
				`u`.`USER_ID` AS `USER_ID` 
			FROM
				(
				SELECT
					`i`.`TASK_ID_` AS `TASK_ID_`,
					`i`.`USER_ID_` AS `USER_ID` 
				FROM
					( `act_ru_identitylink` `i` JOIN `act_ru_task` `t` ) 
				WHERE
					((
							`i`.`TASK_ID_` IS NOT NULL 
							) 
						AND ( `i`.`USER_ID_` IS NOT NULL ) 
						AND ( `i`.`TASK_ID_` = `t`.`ID_` ) 
						AND isnull( `t`.`ASSIGNEE_` ) 
					AND ( `i`.`TYPE_` = 'candidate' )) UNION
				SELECT
					`i`.`TASK_ID_` AS `TASK_ID_`,
					`r`.`USER_ID_` AS `USER_ID` 
				FROM
					(( `act_ru_identitylink` `i` JOIN `act_id_membership` `r` ) JOIN `act_ru_task` `t` ) 
				WHERE
					((
							`i`.`TASK_ID_` IS NOT NULL 
							) 
						AND ( `i`.`GROUP_ID_` IS NOT NULL ) 
						AND ( `i`.`TASK_ID_` = `t`.`ID_` ) 
						AND isnull( `t`.`ASSIGNEE_` ) 
						AND ( `i`.`TYPE_` = 'candidate' ) 
					AND ( `i`.`GROUP_ID_` = `r`.`GROUP_ID_` ))) `u` 
				) `i` ON ((
					`a`.`ID_` = `i`.`TASK_ID_` 
				)))
		LEFT JOIN `act_re_procdef` `f` ON ((
			`a`.`PROC_DEF_ID_` = `f`.`ID_` 
	)))