Package org.flowable.cmmn.api.history
Interface HistoricCaseInstanceQuery
- All Superinterfaces:
org.flowable.common.engine.api.query.BatchDeleteQuery<HistoricCaseInstanceQuery>
,org.flowable.common.engine.api.query.DeleteQuery<HistoricCaseInstanceQuery,
,HistoricCaseInstance> org.flowable.common.engine.api.query.Query<HistoricCaseInstanceQuery,
HistoricCaseInstance>
public interface HistoricCaseInstanceQuery
extends org.flowable.common.engine.api.query.Query<HistoricCaseInstanceQuery,HistoricCaseInstance>, org.flowable.common.engine.api.query.DeleteQuery<HistoricCaseInstanceQuery,HistoricCaseInstance>, org.flowable.common.engine.api.query.BatchDeleteQuery<HistoricCaseInstanceQuery>
- Author:
- Joram Barrez, Tijs Rademakers
-
Nested Class Summary
Nested classes/interfaces inherited from interface org.flowable.common.engine.api.query.Query
org.flowable.common.engine.api.query.Query.NullHandlingOnOrder
-
Method Summary
Modifier and TypeMethodDescriptionactivePlanItemDefinitionId
(String planItemDefinitionId) Select the historic case instances with an active plan item definition id equal to the provided definition id.activePlanItemDefinitionIds
(Set<String> planItemDefinitionIds) Select the historic case instances with an active plan item definition id equal to one of the provided definition ids.caseDefinitionCategory
(String caseDefinitionCategory) Only select historic case instances with the given case definition category.caseDefinitionCategoryLike
(String caseDefinitionCategoryLike) Only select historic case instances with a case definition category like the given value.caseDefinitionCategoryLikeIgnoreCase
(String caseDefinitionCategoryLikeIgnoreCase) Only select historic case instances with a case definition category like the given value, ignoring upper/lower case.caseDefinitionId
(String caseDefinitionId) Only select historic case instances with the given case definition identifier.caseDefinitionIds
(Set<String> caseDefinitionIds) Only select historic case instances with the given case definition ids.caseDefinitionKey
(String caseDefinitionKey) Only select historic case instances with the given key.caseDefinitionKeyLike
(String caseDefinitionKeyLike) Only select historic case instances with a definition key like the given value.caseDefinitionKeyLikeIgnoreCase
(String caseDefinitionKeyLikeIgnoreCase) Only select historic case instances with a definition key like the given value, ignoring upper/lower case.caseDefinitionKeys
(Set<String> caseDefinitionKeys) Only select historic case instances with the given keys.caseDefinitionName
(String caseDefinitionName) Only select historic case instances with the given case definition name.caseDefinitionNameLike
(String caseDefinitionNameLike) Only select historic case instances with a case definition name like the given value.caseDefinitionNameLikeIgnoreCase
(String caseDefinitionNameLikeIgnoreCase) Only select historic case instances with a case definition name like the given value, ignoring upper/lower case.caseDefinitionVersion
(Integer caseDefinitionVersion) Only select historic case instances with the given case definition version.caseInstanceBusinessKey
(String caseInstanceBusinessKey) Only select historic case instances with the given business key.caseInstanceBusinessKeyLike
(String caseInstanceBusinessKeyLike) Only select historic case instances with a business key like the given value.caseInstanceBusinessKeyLikeIgnoreCase
(String caseInstanceBusinessKeyLikeIgnoreCase) Only select historic case instances with a business key like the given value, ignoring upper/lower case.caseInstanceBusinessStatus
(String caseInstanceBusinessStatus) Only select historic case instances with the given business status.caseInstanceBusinessStatusLike
(String caseInstanceBusinessStatusLike) Only select historic case instances with a business status like the given value.caseInstanceBusinessStatusLikeIgnoreCase
(String caseInstanceBusinessStatusLikeIgnoreCase) Only select historic case instances with a business status like the given value, ignoring upper/lower case.caseInstanceCallbackId
(String callbackId) Only select historic case instances that have the provided callback identifier.caseInstanceCallbackType
(String callbackType) Only select historic case instances that have the provided callback type.caseInstanceId
(String caseInstanceId) Only select historic case instances with the given identifier.caseInstanceIds
(Set<String> caseInstanceIds) Only select historic case instances with one the given identifiers.caseInstanceName
(String caseInstanceName) Only select historic case instances with the given name.caseInstanceNameLike
(String caseInstanceNameLike) Only select historic case instances like the given name.caseInstanceNameLikeIgnoreCase
(String nameLikeIgnoreCase) Only select case instances that have a name like (case insensitive) the given name.caseInstanceParentId
(String parentId) Only select historic case instances with the parent identifier.caseInstanceParentScopeId
(String parentScopeId) Only select historic case instances with the given case instance parent scope id.caseInstanceReferenceId
(String referenceId) Only select historic case instance that have the provided reference identifier.caseInstanceReferenceType
(String referenceType) Only select historic case instance that have the provided reference type.caseInstanceRootScopeId
(String rootScopeId) Only select historic case instances with the given case instance root scope id.caseInstanceTenantId
(String tenantId) Only select historic case instances that have the tenant identifier.caseInstanceTenantIdLike
(String tenantIdLike) Only select historic case instances with a tenant identifier like the given value.caseInstanceTenantIdLikeIgnoreCase
(String tenantIdLikeIgnoreCase) Only select historic case instances with a tenant identifier like the given value, ignoring upper/lower case.Only select historic case instances that have no tenant identifier.deploymentId
(String deploymentId) Only select historic case instances that are defined by a case definition with the given deployment identifier.deploymentIds
(List<String> deploymentIds) Only select historic case instances that are defined by a case definition with one of the given deployment identifiers.endOr()
End an OR statement.finished()
Only select historic case instances that are finished.finishedAfter
(Date afterTime) Only select historic case instances that are finished after the provided date time.finishedBefore
(Date beforeTime) Only select historic case instances that are finished before the provided date time.Include historic case variables in the historic case query resultinvolvedGroup
(String groupId, String identityLinkType) Select the historic case instances with which the group with the given id and identity link type are involved.involvedGroups
(Set<String> groupIds) Select the historic case instances with which the groups with the given ids are involved.involvedUser
(String userId) Select the historic case instances with which the user with the given id is involved.involvedUser
(String userId, String identityLinkType) Select the historic case instances with which the user with the given id and identity link type are involved.lastReactivatedAfter
(Date afterTime) Only select historic case instance that are reactivated after the provided date time.lastReactivatedBefore
(Date beforeTime) Only select historic case instance that are reactivated before the provided date time.lastReactivatedBy
(String userId) Only select historic case instances that are reactivated by the provided user identifier.Localize case name to specified locale.or()
Begin an OR statement.startedAfter
(Date afterTime) Only select historic case instances that are started after the provided date time.startedBefore
(Date beforeTime) Only select historic case instances that are started before the provided date time.Only select historic case instances that are started by the provided user identifier.Only select historic case instances that have a state that is equal to the provided value.Only select historic case instances that are not finished.variableExists
(String name) Only select case instances which have a variable with the given name.variableNotExists
(String name) Only select case instances which does not have a variable with the given name.variableValueEquals
(Object value) Only select case instances which had at least one global variable with the given value when they ended.variableValueEquals
(String name, Object value) Only select case instances which had a global variable with the given value when they ended.variableValueEqualsIgnoreCase
(String name, String value) Only select historic case instances which have a string variable with the given value, case insensitive.variableValueGreaterThan
(String name, Object value) Only select case instances which had a global variable value greater than the passed value when they ended.variableValueGreaterThanOrEqual
(String name, Object value) Only select case instances which had a global variable value greater than or equal to the passed value when they ended.variableValueLessThan
(String name, Object value) Only select case instances which had a global variable value less than the passed value when the ended.variableValueLessThanOrEqual
(String name, Object value) Only select case instances which has a global variable value less than or equal to the passed value when they ended.variableValueLike
(String name, String value) Only select case instances which had global variable value like the given value when they ended.variableValueLikeIgnoreCase
(String name, String value) Only select case instances which had global variable value like (case insensitive) the given value when they ended.variableValueNotEquals
(String name, Object value) Only select case instances which had a global variable with the given name, but with a different value than the passed value when they ended.Instruct localization to fallback to more general locales including the default locale of the JVM if the specified locale is not found.Only select historic case instances that do not have a callback identifier.Only select historic case instances without a parent identifier.Methods inherited from interface org.flowable.common.engine.api.query.BatchDeleteQuery
deleteInParallelUsingBatch, deleteSequentiallyUsingBatch
Methods inherited from interface org.flowable.common.engine.api.query.DeleteQuery
delete, deleteWithRelatedData
Methods inherited from interface org.flowable.common.engine.api.query.Query
asc, count, desc, list, listPage, orderBy, orderBy, singleResult
-
Method Details
-
caseInstanceId
Only select historic case instances with the given identifier. -
caseInstanceIds
Only select historic case instances with one the given identifiers. -
caseInstanceName
Only select historic case instances with the given name. -
caseInstanceNameLike
Only select historic case instances like the given name. -
caseInstanceNameLikeIgnoreCase
Only select case instances that have a name like (case insensitive) the given name.- Parameters:
nameLikeIgnoreCase
- cannot be null. The string can include the wildcard character '%' to express like-strategy: starts with (string%), ends with (%string) or contains (%string%).
-
caseInstanceBusinessKey
Only select historic case instances with the given business key. -
caseInstanceBusinessKeyLike
Only select historic case instances with a business key like the given value. -
caseInstanceBusinessKeyLikeIgnoreCase
HistoricCaseInstanceQuery caseInstanceBusinessKeyLikeIgnoreCase(String caseInstanceBusinessKeyLikeIgnoreCase) Only select historic case instances with a business key like the given value, ignoring upper/lower case. -
caseInstanceRootScopeId
Only select historic case instances with the given case instance root scope id. -
caseInstanceParentScopeId
Only select historic case instances with the given case instance parent scope id. -
caseInstanceBusinessStatus
Only select historic case instances with the given business status. -
caseInstanceBusinessStatusLike
Only select historic case instances with a business status like the given value. -
caseInstanceBusinessStatusLikeIgnoreCase
HistoricCaseInstanceQuery caseInstanceBusinessStatusLikeIgnoreCase(String caseInstanceBusinessStatusLikeIgnoreCase) Only select historic case instances with a business status like the given value, ignoring upper/lower case. -
caseInstanceParentId
Only select historic case instances with the parent identifier. -
withoutCaseInstanceParent
HistoricCaseInstanceQuery withoutCaseInstanceParent()Only select historic case instances without a parent identifier. -
caseDefinitionKey
Only select historic case instances with the given key. -
caseDefinitionKeyLike
Only select historic case instances with a definition key like the given value. -
caseDefinitionKeyLikeIgnoreCase
Only select historic case instances with a definition key like the given value, ignoring upper/lower case. -
caseDefinitionKeys
Only select historic case instances with the given keys. -
caseDefinitionId
Only select historic case instances with the given case definition identifier. -
caseDefinitionIds
Only select historic case instances with the given case definition ids. -
caseDefinitionCategory
Only select historic case instances with the given case definition category. -
caseDefinitionCategoryLike
Only select historic case instances with a case definition category like the given value. -
caseDefinitionCategoryLikeIgnoreCase
HistoricCaseInstanceQuery caseDefinitionCategoryLikeIgnoreCase(String caseDefinitionCategoryLikeIgnoreCase) Only select historic case instances with a case definition category like the given value, ignoring upper/lower case. -
caseDefinitionName
Only select historic case instances with the given case definition name. -
caseDefinitionNameLike
Only select historic case instances with a case definition name like the given value. -
caseDefinitionNameLikeIgnoreCase
Only select historic case instances with a case definition name like the given value, ignoring upper/lower case. -
caseDefinitionVersion
Only select historic case instances with the given case definition version. -
includeCaseVariables
HistoricCaseInstanceQuery includeCaseVariables()Include historic case variables in the historic case query result -
deploymentId
Only select historic case instances that are defined by a case definition with the given deployment identifier. -
deploymentIds
Only select historic case instances that are defined by a case definition with one of the given deployment identifiers. -
finished
HistoricCaseInstanceQuery finished()Only select historic case instances that are finished. -
unfinished
HistoricCaseInstanceQuery unfinished()Only select historic case instances that are not finished. -
startedBefore
Only select historic case instances that are started before the provided date time. -
startedAfter
Only select historic case instances that are started after the provided date time. -
finishedBefore
Only select historic case instances that are finished before the provided date time. -
finishedAfter
Only select historic case instances that are finished after the provided date time. -
startedBy
Only select historic case instances that are started by the provided user identifier. -
state
Only select historic case instances that have a state that is equal to the provided value. -
lastReactivatedBefore
Only select historic case instance that are reactivated before the provided date time. -
lastReactivatedAfter
Only select historic case instance that are reactivated after the provided date time. -
lastReactivatedBy
Only select historic case instances that are reactivated by the provided user identifier. -
caseInstanceCallbackId
Only select historic case instances that have the provided callback identifier. -
caseInstanceCallbackType
Only select historic case instances that have the provided callback type. -
withoutCaseInstanceCallbackId
HistoricCaseInstanceQuery withoutCaseInstanceCallbackId()Only select historic case instances that do not have a callback identifier. -
caseInstanceReferenceId
Only select historic case instance that have the provided reference identifier. -
caseInstanceReferenceType
Only select historic case instance that have the provided reference type. -
caseInstanceTenantId
Only select historic case instances that have the tenant identifier. -
caseInstanceTenantIdLike
Only select historic case instances with a tenant identifier like the given value. -
caseInstanceTenantIdLikeIgnoreCase
Only select historic case instances with a tenant identifier like the given value, ignoring upper/lower case. -
caseInstanceWithoutTenantId
HistoricCaseInstanceQuery caseInstanceWithoutTenantId()Only select historic case instances that have no tenant identifier. -
or
Begin an OR statement. Make sure you invoke the endOr method at the end of your OR statement. Only one OR statement is allowed, for the second call to this method an exception will be thrown. -
endOr
HistoricCaseInstanceQuery endOr()End an OR statement. Only one OR statement is allowed, for the second call to this method an exception will be thrown. -
activePlanItemDefinitionId
Select the historic case instances with an active plan item definition id equal to the provided definition id. -
activePlanItemDefinitionIds
Select the historic case instances with an active plan item definition id equal to one of the provided definition ids. -
involvedUser
Select the historic case instances with which the user with the given id is involved. -
involvedUser
Select the historic case instances with which the user with the given id and identity link type are involved. -
involvedGroup
Select the historic case instances with which the group with the given id and identity link type are involved. -
involvedGroups
Select the historic case instances with which the groups with the given ids are involved. -
variableValueEquals
Only select case instances which had a global variable with the given value when they ended. Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported.- Parameters:
name
- of the variable, cannot be null.
-
variableValueEquals
Only select case instances which had at least one global variable with the given value when they ended. Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported. -
variableValueEqualsIgnoreCase
Only select historic case instances which have a string variable with the given value, case insensitive.- Parameters:
name
- name of the variable, cannot be null.value
- value of the variable, cannot be null.
-
variableValueNotEquals
Only select case instances which had a global variable with the given name, but with a different value than the passed value when they ended. Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported.- Parameters:
name
- of the variable, cannot be null.
-
variableValueGreaterThan
Only select case instances which had a global variable value greater than the passed value when they ended. Booleans, Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported.- Parameters:
name
- cannot be null.value
- cannot be null.
-
variableValueGreaterThanOrEqual
Only select case instances which had a global variable value greater than or equal to the passed value when they ended. Booleans, Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported.- Parameters:
name
- cannot be null.value
- cannot be null.
-
variableValueLessThan
Only select case instances which had a global variable value less than the passed value when the ended. Booleans, Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported.- Parameters:
name
- cannot be null.value
- cannot be null.
-
variableValueLessThanOrEqual
Only select case instances which has a global variable value less than or equal to the passed value when they ended. Booleans, Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported.- Parameters:
name
- cannot be null.value
- cannot be null.
-
variableValueLike
Only select case instances which had global variable value like the given value when they ended. This can be used on string variables only.- Parameters:
name
- cannot be null.value
- cannot be null. The string can include the wildcard character '%' to express like-strategy: starts with (string%), ends with (%string) or contains (%string%).
-
variableValueLikeIgnoreCase
Only select case instances which had global variable value like (case insensitive) the given value when they ended. This can be used on string variables only.- Parameters:
name
- cannot be null.value
- cannot be null. The string can include the wildcard character '%' to express like-strategy: starts with (string%), ends with (%string) or contains (%string%).
-
variableExists
Only select case instances which have a variable with the given name.- Parameters:
name
- cannot be null.
-
variableNotExists
Only select case instances which does not have a variable with the given name.- Parameters:
name
- cannot be null.
-
locale
Localize case name to specified locale. -
withLocalizationFallback
HistoricCaseInstanceQuery withLocalizationFallback()Instruct localization to fallback to more general locales including the default locale of the JVM if the specified locale is not found. -
orderByCaseInstanceId
HistoricCaseInstanceQuery orderByCaseInstanceId() -
orderByCaseInstanceName
HistoricCaseInstanceQuery orderByCaseInstanceName() -
orderByCaseDefinitionKey
HistoricCaseInstanceQuery orderByCaseDefinitionKey() -
orderByCaseDefinitionId
HistoricCaseInstanceQuery orderByCaseDefinitionId() -
orderByStartTime
HistoricCaseInstanceQuery orderByStartTime() -
orderByEndTime
HistoricCaseInstanceQuery orderByEndTime() -
orderByTenantId
HistoricCaseInstanceQuery orderByTenantId()
-