Flowable historyService.createHistoricTaskInstanceQuery() 执行的 SQL 语句

Flowable 的 historyService.createHistoricTaskInstanceQuery() 方法执行的 SQL 查询语句如下：

SELECT *
FROM ACT_HI_TASKINST
WHERE 1 = 1
  AND ID_ = #{taskId}
  AND NAME_ = #{name}
  AND PARENT_TASK_ID_ = #{parentTaskId}
  AND DESCRIPTION_ = #{description}
  AND OWNER_ = #{owner}
  AND ASSIGNEE_ = #{assignee}
  AND START_TIME_ = #{startTime}
  AND END_TIME_ = #{endTime}
  AND DURATION_ = #{duration}
  AND DELETE_REASON_ = #{deleteReason}
  AND PROCESS_DEFINITION_ID_ = #{processDefinitionId}
  AND TASK_DEFINITION_KEY_ = #{taskDefinitionKey}
  AND FORM_KEY_ = #{formKey}
  AND PRIORITY_ = #{priority}
  AND CATEGORY_ = #{category}
  AND TENANT_ID_ = #{tenantId}
  AND EXECUTION_ID_ = #{executionId}
  AND SCOPE_ID_ = #{scopeId}
  AND SCOPE_TYPE_ = #{scopeType}
  AND SCOPE_DEFINITION_ID_ = #{scopeDefinitionId}
  AND PROPAGATION_COUNTER_ = #{propagationCounter}
  AND IS_COUNT_ENABLED_ = #{isCountEnabled}
  AND IS_EVENT_SUBSCRIPTION_ENABLED_ = #{isEventSubscriptionEnabled}
  AND TASK_DEF_KEY_UPPER_ = #{taskDefKeyUpper}
  AND TASK_DEF_KEY_LOWER_ = #{taskDefKeyLower}
  AND TASK_NAME_UPPER_ = #{taskNameUpper}
  AND TASK_NAME_LOWER_ = #{taskNameLower}
  AND TASK_DESC_UPPER_ = #{taskDescUpper}
  AND TASK_DESC_LOWER_ = #{taskDescLower}
  AND PROC_INST_ID_ = #{processInstanceId}
  AND CASE_DEF_ID_ = #{caseDefinitionId}
  AND CASE_INST_ID_ = #{caseInstanceId}
  AND CASE_EXECUTION_ID_ = #{caseExecutionId}
  AND TENANT_ID_ = #{tenantId}
  AND PARENT_TASK_ID_ = #{parentTaskId}
  AND DELETE_REASON_ = #{deleteReason}
  AND DUE_DATE_ = #{dueDate}
  AND FOLLOW_UP_DATE_ = #{followUpDate}
  AND DELEGATION_STATE_ = #{delegationState}
  AND ASSIGNEE_ = #{assigneeLike}
  AND ASSIGNEE_ LIKE #{assigneeLikeLower}
  AND ASSIGNEE_ LIKE #{assigneeLikeUpper}
  AND DELETE_REASON_ LIKE #{deleteReasonLike}
  AND DELETE_REASON_ LIKE #{deleteReasonLikeLower}
  AND DELETE_REASON_ LIKE #{deleteReasonLikeUpper}
  AND DESCRIPTION_ LIKE #{descriptionLike}
  AND DESCRIPTION_ LIKE #{descriptionLikeLower}
  AND DESCRIPTION_ LIKE #{descriptionLikeUpper}
  AND EXECUTION_ID_ LIKE #{executionIdLike}
  AND EXECUTION_ID_ LIKE #{executionIdLikeLower}
  AND EXECUTION_ID_ LIKE #{executionIdLikeUpper}
  AND ID_ LIKE #{idLike}
  AND ID_ LIKE #{idLikeLower}
  AND ID_ LIKE #{idLikeUpper}
  AND NAME_ LIKE #{nameLike}
  AND NAME_ LIKE #{nameLikeLower}
  AND NAME_ LIKE #{nameLikeUpper}
  AND OWNER_ LIKE #{ownerLike}
  AND OWNER_ LIKE #{ownerLikeLower}
  AND OWNER_ LIKE #{ownerLikeUpper}
  AND PARENT_TASK_ID_ LIKE #{parentTaskIdLike}
  AND PARENT_TASK_ID_ LIKE #{parentTaskIdLikeLower}
  AND PARENT_TASK_ID_ LIKE #{parentTaskIdLikeUpper}
  AND PRIORITY_ = #{priority}
  AND PROCESS_DEFINITION_ID_ LIKE #{processDefinitionIdLike}
  AND PROCESS_DEFINITION_ID_ LIKE #{processDefinitionIdLikeLower}
  AND PROCESS_DEFINITION_ID_ LIKE #{processDefinitionIdLikeUpper}
  AND SCOPE_DEFINITION_ID_ LIKE #{scopeDefinitionIdLike}
  AND SCOPE_DEFINITION_ID_ LIKE #{scopeDefinitionIdLikeLower}
  AND SCOPE_DEFINITION_ID_ LIKE #{scopeDefinitionIdLikeUpper}
  AND SCOPE_ID_ LIKE #{scopeIdLike}
  AND SCOPE_ID_ LIKE #{scopeIdLikeLower}
  AND SCOPE_ID_ LIKE #{scopeIdLikeUpper}
  AND SCOPE_TYPE_ LIKE #{scopeTypeLike}
  AND SCOPE_TYPE_ LIKE #{scopeTypeLikeLower}
  AND SCOPE_TYPE_ LIKE #{scopeTypeLikeUpper}
  AND START_TIME_ >= #{startedAfter}
  AND START_TIME_ >= #{startedAfterLower}
  AND START_TIME_ >= #{startedAfterUpper}
  AND START_TIME_ <= #{startedBefore}
  AND START_TIME_ <= #{startedBeforeLower}
  AND START_TIME_ <= #{startedBeforeUpper}
  AND TASK_DEFINITION_KEY_ LIKE #{taskDefinitionKeyLike}
  AND TASK_DEFINITION_KEY_ LIKE #{taskDefinitionKeyLikeLower}
  AND TASK_DEFINITION_KEY_ LIKE #{taskDefinitionKeyLikeUpper}
  AND TASK_DEF_KEY_UPPER_ LIKE #{taskDefKeyUpperLike}
  AND TASK_DEF_KEY_UPPER_ LIKE #{taskDefKeyUpperLikeLower}
  AND TASK_DEF_KEY_UPPER_ LIKE #{taskDefKeyUpperLikeUpper}
  AND TASK_DEF_KEY_LOWER_ LIKE #{taskDefKeyLowerLike}
  AND TASK_DEF_KEY_LOWER_ LIKE #{taskDefKeyLowerLikeLower}
  AND TASK_DEF_KEY_LOWER_ LIKE #{taskDefKeyLowerLikeUpper}
  AND TASK_DESC_UPPER_ LIKE #{taskDescUpperLike}
  AND TASK_DESC_UPPER_ LIKE #{taskDescUpperLikeLower}
  AND TASK_DESC_UPPER_ LIKE #{taskDescUpperLikeUpper}
  AND TASK_DESC_LOWER_ LIKE #{taskDescLowerLike}
  AND TASK_DESC_LOWER_ LIKE #{taskDescLowerLikeLower}
  AND TASK_DESC_LOWER_ LIKE #{taskDescLowerLikeUpper}
  AND TASK_NAME_UPPER_ LIKE #{taskNameUpperLike}
  AND TASK_NAME_UPPER_ LIKE #{taskNameUpperLikeLower}
  AND TASK_NAME_UPPER_ LIKE #{taskNameUpperLikeUpper}
  AND TASK_NAME_LOWER_ LIKE #{taskNameLowerLike}
  AND TASK_NAME_LOWER_ LIKE #{taskNameLowerLikeLower}
  AND TASK_NAME_LOWER_ LIKE #{taskNameLowerLikeUpper}
  AND TENANT_ID_ LIKE #{tenantIdLike}
  AND TENANT_ID_ LIKE #{tenantIdLikeLower}
  AND TENANT_ID_ LIKE #{tenantIdLikeUpper}
  AND TENANT_ID_ = #{tenantId}
  AND DURATION_ >= #{minDuration}
  AND DURATION_ <= #{maxDuration}
  AND DURATION_ = #{duration}
  AND DUE_DATE_ >= #{dueAfter}
  AND DUE_DATE_ >= #{dueAfterLower}
  AND DUE_DATE_ >= #{dueAfterUpper}
  AND DUE_DATE_ <= #{dueBefore}
  AND DUE_DATE_ <= #{dueBeforeLower}
  AND DUE_DATE_ <= #{dueBeforeUpper}
  AND FOLLOW_UP_DATE_ >= #{followUpAfter}
  AND FOLLOW_UP_DATE_ >= #{followUpAfterLower}
  AND FOLLOW_UP_DATE_ >= #{followUpAfterUpper}
  AND FOLLOW_UP_DATE_ <= #{followUpBefore}
  AND FOLLOW_UP_DATE_ <= #{followUpBeforeLower}
  AND FOLLOW_UP_DATE_ <= #{followUpBeforeUpper}
  AND DELETE_REASON_ = #{deleteReason}
  AND DELEGATION_STATE_ = #{delegationState}

该查询语句支持多种查询条件，包括：

任务 ID
任务名称
父任务 ID
描述
所有者
受让人
开始时间
结束时间
持续时间
删除原因
流程定义 ID
任务定义键
表单键
优先级
类别
租户 ID
执行 ID
范围 ID
范围类型
范围定义 ID
传播计数器
是否启用计数
是否启用事件订阅
任务定义键（大写）
任务定义键（小写）
任务名称（大写）
任务名称（小写）
任务描述（大写）
任务描述（小写）
流程实例 ID
案例定义 ID
案例实例 ID
案例执行 ID
租户 ID
父任务 ID
删除原因
到期日期
跟进日期
委托状态

此外，还可以使用 like 运算符进行模糊匹配。例如，可以使用 assigneeLike 参数来模糊匹配受让人。

该方法允许您根据各种条件查询历史任务实例，方便您分析流程执行情况和历史数据。

Flowable historyService.createHistoricTaskInstanceQuery() 执行的 SQL 语句