Interface ExecutionQuery
- All Superinterfaces:
org.flowable.common.engine.api.query.Query<ExecutionQuery,
Execution>
- All Known Implementing Classes:
ExecutionQueryImpl
Execution
s.- Author:
- Joram Barrez, Frederik Heremans
-
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 TypeMethodDescriptionactivityId
(String activityId) Only select executions which contain an activity with the given id.endOr()
End an OR statement.executionId
(String executionId) Only select executions with the given id.executionReferenceId
(String referenceId) Only select executions with the given reference id.executionReferenceType
(String referenceType) Only select executions with the given reference type.executionTenantId
(String tenantId) Only select process instances that have the given tenant id.executionTenantIdLike
(String tenantIdLike) Only select process instances with a tenant id like the given one.executionTenantIdLikeIgnoreCase
(String tenantIdLikeIgnoreCase) Only select process instances with a tenant id like the given one, ignoring upper/lower case.Only select process instances that do not have a tenant id.Localize execution name and description to specified locale.messageEventSubscriptionName
(String messageName) Only select executions which have a message event subscription for the given messageName.Only selects executions that have a parent id set, ie non-processinstance executions.Only selects executions that have no parent id set, ie process instance executionsOnly selects executions that are a subprocess.or()
Begin an OR statement.Order by process definition id (needs to be followed byQuery.asc()
orQuery.desc()
).Order by process definition key (needs to be followed byQuery.asc()
orQuery.desc()
).Order by id (needs to be followed byQuery.asc()
orQuery.desc()
).Order by tenant id (needs to be followed byQuery.asc()
orQuery.desc()
).Only select executions which are a direct child-execution of the execution with the given id.processDefinitionCategory
(String processDefinitionCategory) Only select executions which have the given process definition category.processDefinitionCategoryLike
(String processDefinitionCategoryLike) Only select executions which have a process definition category like the given value.processDefinitionCategoryLikeIgnoreCase
(String processDefinitionCategoryLikeIgnoreCase) Only select executions which have a process definition category like the given value, ignoring upper/lower case.processDefinitionEngineVersion
(String processDefinitionEngineVersion) Only select executions which have the given process definition engine version.processDefinitionId
(String processDefinitionId) Only select executions which have the given process definition id.processDefinitionKey
(String processDefinitionKey) Only select executions which have the given process definition key.processDefinitionKeyLike
(String processDefinitionKeyLike) Only select executions which have a process definition key like the given value.processDefinitionKeyLikeIgnoreCase
(String processDefinitionKeyLikeIgnoreCase) Only select executions which have a process definition key like the given value, ignoring upper/lower case.processDefinitionKeys
(Set<String> processDefinitionKeys) Only select executions which have process definitions with the given keys.processDefinitionName
(String processDefinitionName) Only select executions which have the given process definition name.processDefinitionNameLike
(String processDefinitionNameLike) Only select executions which have a process definition name like the given value.processDefinitionNameLikeIgnoreCase
(String processDefinitionNameLikeIgnoreCase) Only select executions which have a process definition name like the given value, ignoring upper/lower case.processDefinitionVersion
(Integer processDefinitionVersion) Only select executions which have the given process definition version.processInstanceBusinessKey
(String processInstanceBusinessKey) Only executions with the given business key.processInstanceBusinessKey
(String processInstanceBusinessKey, boolean includeChildExecutions) Only executions with the given business key.processInstanceBusinessKeyLike
(String processInstanceBusinessKeyLike) Only executions that have a business key like the given value.processInstanceBusinessKeyLike
(String processInstanceBusinessKeyLike, boolean includeChildExecutions) Only executions that have a business key like the given value.processInstanceBusinessKeyLikeIgnoreCase
(String processInstanceBusinessKeyLikeIgnoreCase) Only executions that have a business key like the given value, ignoring upper/lower case.processInstanceBusinessKeyLikeIgnoreCase
(String processInstanceBusinessKeyLikeIgnoreCase, boolean includeChildExecutions) Only executions that have a business key like the given value, ignoring upper/lower case.processInstanceId
(String processInstanceId) Only select executions which have the given process instance id.processVariableExists
(String name) Only select executions which are part of a process that have a variable with the given name.Only select executions which are part of a process that don't have a variable with the given name.processVariableValueEquals
(Object variableValue) Only select executions which are part of a process that have at least one variable with the given value.processVariableValueEquals
(String variableName, Object variableValue) Only select executions which are part of a process that have a variable with the given name set to the given value.processVariableValueEqualsIgnoreCase
(String name, String value) Only select executions which are part of a process that have a local string variable with the given value, case insensitive.processVariableValueGreaterThan
(String name, Object value) Only select executions which have a process instance variable value greater than the passed value.processVariableValueGreaterThanOrEqual
(String name, Object value) Only select executions which have a process instance variable value greater than or equal to the passed value.processVariableValueLessThan
(String name, Object value) Only select executions which have a process instance variable value less than the passed value.processVariableValueLessThanOrEqual
(String name, Object value) Only select executions which have a process instance variable value less than or equal to the passed value.processVariableValueLike
(String name, String value) Only select executions which are part of a process that have at least one variable like the given value.processVariableValueLikeIgnoreCase
(String name, String value) Only select executions which are part of a process that have at least one variable like the given value (case insensitive).processVariableValueNotEquals
(String variableName, Object variableValue) Only select executions which are part of a process that have a variable with the given name, but with a different value than the passed value.processVariableValueNotEqualsIgnoreCase
(String name, String value) Only select executions which are part of a process that have a local string variable which is not the given value, case insensitive.rootProcessInstanceId
(String rootProcessInstanceId) Only select executions which have the given root process instance id.signalEventSubscriptionName
(String signalName) Only select executions which have a signal event subscription for the given signal name.startedAfter
(Date afterTime) Only select executions that were started after the given start time.startedBefore
(Date beforeTime) Only select executions that were started before the given start time.Only select executions that were started after by the given user id.variableExists
(String name) Only select executions which have a local variable with the given name.variableNotExists
(String name) Only select executions which does not have a local variable with the given name.variableValueEquals
(Object value) Only select executions which have at least one local variable with the given value.variableValueEquals
(String name, Object value) Only select executions which have a local variable with the given value.variableValueEqualsIgnoreCase
(String name, String value) Only select executions which have a local string variable with the given value, case insensitive.variableValueGreaterThan
(String name, Object value) Only select executions which have a local variable value greater than the passed value.variableValueGreaterThanOrEqual
(String name, Object value) Only select executions which have a local variable value greater than or equal to the passed value.variableValueLessThan
(String name, Object value) Only select executions which have a local variable value less than the passed value.variableValueLessThanOrEqual
(String name, Object value) Only select executions which have a local variable value less than or equal to the passed value.variableValueLike
(String name, String value) Only select executions which have a local variable value like the given value.variableValueLikeIgnoreCase
(String name, String value) Only select executions which have a local variable value like the given value (case insensitive).variableValueNotEquals
(String name, Object value) Only select executions which have a local variable with the given name, but with a different value than the passed value.variableValueNotEqualsIgnoreCase
(String name, String value) Only select executions which have a local string variable which is not the given value, case insensitive.Instruct localization to fallback to more general locales including the default locale of the JVM if the specified locale is not found.Methods inherited from interface org.flowable.common.engine.api.query.Query
asc, count, desc, list, listPage, orderBy, orderBy, singleResult
-
Method Details
-
processDefinitionKey
Only select executions which have the given process definition key. -
processDefinitionKeyLike
Only select executions which have a process definition key like the given value. -
processDefinitionKeyLikeIgnoreCase
Only select executions which have a process definition key like the given value, ignoring upper/lower case. -
processDefinitionKeys
Only select executions which have process definitions with the given keys. -
processDefinitionId
Only select executions which have the given process definition id. -
processDefinitionCategory
Only select executions which have the given process definition category. -
processDefinitionCategoryLike
Only select executions which have a process definition category like the given value. -
processDefinitionCategoryLikeIgnoreCase
ExecutionQuery processDefinitionCategoryLikeIgnoreCase(String processDefinitionCategoryLikeIgnoreCase) Only select executions which have a process definition category like the given value, ignoring upper/lower case. -
processDefinitionName
Only select executions which have the given process definition name. -
processDefinitionNameLike
Only select executions which have a process definition name like the given value. -
processDefinitionNameLikeIgnoreCase
Only select executions which have a process definition name like the given value, ignoring upper/lower case. -
processDefinitionEngineVersion
Only select executions which have the given process definition engine version. -
processDefinitionVersion
Only select executions which have the given process definition version. Particularly useful when used in combination withprocessDefinitionKey(String)
-
processInstanceId
Only select executions which have the given process instance id. -
rootProcessInstanceId
Only select executions which have the given root process instance id. -
processInstanceBusinessKey
Only executions with the given business key. Note that only process instances have a business key and as such, child executions will NOT be returned. If you want to return child executions of the process instance with the given business key too, use theprocessInstanceBusinessKey(String, boolean)
method with a boolean value of true instead. -
processInstanceBusinessKey
ExecutionQuery processInstanceBusinessKey(String processInstanceBusinessKey, boolean includeChildExecutions) Only executions with the given business key. Similar toprocessInstanceBusinessKey(String)
, but allows to choose whether child executions are returned or not. -
processInstanceBusinessKeyLike
Only executions that have a business key like the given value. Note that only process instances have a business key and as such, child executions will NOT be returned. If you want to return child executions of the process instance with the given business key too, use theprocessInstanceBusinessKeyLike(String, boolean)
method with a boolean value of true instead. -
processInstanceBusinessKeyLike
ExecutionQuery processInstanceBusinessKeyLike(String processInstanceBusinessKeyLike, boolean includeChildExecutions) Only executions that have a business key like the given value. Similar toprocessInstanceBusinessKeyLike(String)
, but allows to choose whether child executions are returned or not. -
processInstanceBusinessKeyLikeIgnoreCase
ExecutionQuery processInstanceBusinessKeyLikeIgnoreCase(String processInstanceBusinessKeyLikeIgnoreCase) Only executions that have a business key like the given value, ignoring upper/lower case. Note that only process instances have a business key and as such, child executions will NOT be returned. If you want to return child executions of the process instance with the given business key too, use theprocessInstanceBusinessKeyLikeIgnoreCase(String, boolean)
method with a boolean value of true instead. -
processInstanceBusinessKeyLikeIgnoreCase
ExecutionQuery processInstanceBusinessKeyLikeIgnoreCase(String processInstanceBusinessKeyLikeIgnoreCase, boolean includeChildExecutions) Only executions that have a business key like the given value, ignoring upper/lower case. Similar toprocessInstanceBusinessKeyLikeIgnoreCase(String)
, but allows to choose whether child executions are returned or not. -
executionId
Only select executions with the given id. -
activityId
Only select executions which contain an activity with the given id. -
parentId
Only select executions which are a direct child-execution of the execution with the given id. -
onlyChildExecutions
ExecutionQuery onlyChildExecutions()Only selects executions that have a parent id set, ie non-processinstance executions. -
onlySubProcessExecutions
ExecutionQuery onlySubProcessExecutions()Only selects executions that are a subprocess. -
onlyProcessInstanceExecutions
ExecutionQuery onlyProcessInstanceExecutions()Only selects executions that have no parent id set, ie process instance executions -
executionTenantId
Only select process instances that have the given tenant id. -
executionTenantIdLike
Only select process instances with a tenant id like the given one. -
executionTenantIdLikeIgnoreCase
Only select process instances with a tenant id like the given one, ignoring upper/lower case. -
executionWithoutTenantId
ExecutionQuery executionWithoutTenantId()Only select process instances that do not have a tenant id. -
executionReferenceId
Only select executions with the given reference id. -
executionReferenceType
Only select executions with the given reference type. -
variableValueEquals
Only select executions which have a local variable with the given value. The type of variable is determined based on the value, using types configured inProcessEngineConfigurationImpl.getVariableTypes()
. Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported.- Parameters:
name
- name of the variable, cannot be null.
-
variableValueEqualsIgnoreCase
Only select executions which have a local string variable with the given value, case insensitive.This method only works if your database has encoding/collation that supports case-sensitive queries. For example, use "collate UTF-8" on MySQL and for MSSQL, select one of the case-sensitive Collations available (MSDN Server Collation Reference).
- Parameters:
name
- name of the variable, cannot be null.value
- value of the variable, cannot be null.
-
variableValueEquals
Only select executions which have at least one local variable with the given value. The type of variable is determined based on the value, using types configured inProcessEngineConfigurationImpl.getVariableTypes()
. Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported. -
variableValueNotEquals
Only select executions which have a local variable with the given name, but with a different value than the passed value. Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported.- Parameters:
name
- name of the variable, cannot be null.
-
variableValueNotEqualsIgnoreCase
Only select executions which have a local string variable which is not the given value, case insensitive.This method only works if your database has encoding/collation that supports case-sensitive queries. For example, use "collate UTF-8" on MySQL and for MSSQL, select one of the case-sensitive Collations available (MSDN Server Collation Reference).
- Parameters:
name
- name of the variable, cannot be null.value
- value of the variable, cannot be null.
-
variableValueGreaterThan
Only select executions which have a local variable value greater than the passed value. Booleans, Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported.- Parameters:
name
- variable name, cannot be null.value
- variable value, cannot be null.
-
variableValueGreaterThanOrEqual
Only select executions which have a local variable value greater than or equal to the passed value. Booleans, Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported.- Parameters:
name
- variable name, cannot be null.value
- variable value, cannot be null.
-
variableValueLessThan
Only select executions which have a local variable value less than the passed value. Booleans, Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported.- Parameters:
name
- variable name, cannot be null.value
- variable value, cannot be null.
-
variableValueLessThanOrEqual
Only select executions which have a local variable value less than or equal to the passed value. Booleans, Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported.- Parameters:
name
- variable name, cannot be null.value
- variable value, cannot be null.
-
variableValueLike
Only select executions which have a local variable value like the given value. This be used on string variables only.- Parameters:
name
- variable name, cannot be null.value
- variable 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 executions which have a local variable value like the given value (case insensitive). This be used on string variables only.- Parameters:
name
- variable name, cannot be null.value
- variable 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 executions which have a local variable with the given name.- Parameters:
name
- cannot be null.
-
variableNotExists
Only select executions which does not have a local variable with the given name.- Parameters:
name
- cannot be null.
-
processVariableValueEquals
Only select executions which are part of a process that have a variable with the given name set to the given value. Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported. -
processVariableValueEquals
Only select executions which are part of a process that have at least one variable with the given value. Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported. -
processVariableValueNotEquals
Only select executions which are part of a process that have a variable with the given name, but with a different value than the passed value. Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported. -
processVariableValueEqualsIgnoreCase
Only select executions which are part of a process that have a local string variable with the given value, case insensitive.This method only works if your database has encoding/collation that supports case-sensitive queries. For example, use "collate UTF-8" on MySQL and for MSSQL, select one of the case-sensitive Collations available (MSDN Server Collation Reference).
- Parameters:
name
- name of the variable, cannot be null.value
- value of the variable, cannot be null.
-
processVariableValueNotEqualsIgnoreCase
Only select executions which are part of a process that have a local string variable which is not the given value, case insensitive.This method only works if your database has encoding/collation that supports case-sensitive queries. For example, use "collate UTF-8" on MySQL and for MSSQL, select one of the case-sensitive Collations available (MSDN Server Collation Reference).
- Parameters:
name
- name of the variable, cannot be null.value
- value of the variable, cannot be null.
-
processVariableValueLike
Only select executions which are part of a process that have at least one variable like the given value. Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported. -
processVariableValueLikeIgnoreCase
Only select executions which are part of a process that have at least one variable like the given value (case insensitive). Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported. -
processVariableValueGreaterThan
Only select executions which have a process instance variable value greater than the passed value. Booleans, Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported.- Parameters:
name
- variable name, cannot be null.value
- variable value, cannot be null.
-
processVariableValueGreaterThanOrEqual
Only select executions which have a process instance variable value greater than or equal to the passed value. Booleans, Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported.- Parameters:
name
- variable name, cannot be null.value
- variable value, cannot be null.
-
processVariableValueLessThan
Only select executions which have a process instance variable value less than the passed value. Booleans, Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported.- Parameters:
name
- variable name, cannot be null.value
- variable value, cannot be null.
-
processVariableValueLessThanOrEqual
Only select executions which have a process instance variable value less than or equal to the passed value. Booleans, Byte-arrays andSerializable
objects (which are not primitive type wrappers) are not supported.- Parameters:
name
- variable name, cannot be null.value
- variable value, cannot be null.
-
processVariableExists
Only select executions which are part of a process that have a variable with the given name.- Parameters:
name
- cannot be null.
-
processVariableNotExists
Only select executions which are part of a process that don't have a variable with the given name.- Parameters:
name
- cannot be null.
-
signalEventSubscriptionName
Only select executions which have a signal event subscription for the given signal name. (The signalName is specified using the 'name' attribute of the signal element in the BPMN 2.0 XML.)- Parameters:
signalName
- the name of the signal the execution has subscribed to
-
messageEventSubscriptionName
Only select executions which have a message event subscription for the given messageName. (The messageName is specified using the 'name' attribute of the message element in the BPMN 2.0 XML.)- Parameters:
messageName
- the name of the message the execution has subscribed to
-
locale
Localize execution name and description to specified locale. -
withLocalizationFallback
ExecutionQuery withLocalizationFallback()Instruct localization to fallback to more general locales including the default locale of the JVM if the specified locale is not found. -
startedBefore
Only select executions that were started before the given start time.- Parameters:
beforeTime
- executions started before this time will be returned (cannot be null)
-
startedAfter
Only select executions that were started after the given start time.- Parameters:
afterTime
- executions started after this time will be returned (cannot be null)
-
startedBy
Only select executions that were started after by the given user id.- Parameters:
userId
- the user id of the authenticated user that started the execution (cannot be null)
-
or
ExecutionQuery 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
ExecutionQuery endOr()End an OR statement. Only one OR statement is allowed, for the second call to this method an exception will be thrown. -
orderByProcessInstanceId
ExecutionQuery orderByProcessInstanceId()Order by id (needs to be followed byQuery.asc()
orQuery.desc()
). -
orderByProcessDefinitionKey
ExecutionQuery orderByProcessDefinitionKey()Order by process definition key (needs to be followed byQuery.asc()
orQuery.desc()
). -
orderByProcessDefinitionId
ExecutionQuery orderByProcessDefinitionId()Order by process definition id (needs to be followed byQuery.asc()
orQuery.desc()
). -
orderByTenantId
ExecutionQuery orderByTenantId()Order by tenant id (needs to be followed byQuery.asc()
orQuery.desc()
).
-