Package org.camunda.bpm.engine.history
Interface HistoricCaseInstanceQuery
-
- All Superinterfaces:
Query<HistoricCaseInstanceQuery,HistoricCaseInstance>
- All Known Implementing Classes:
HistoricCaseInstanceQueryImpl
public interface HistoricCaseInstanceQuery extends Query<HistoricCaseInstanceQuery,HistoricCaseInstance>
Allows programmatic querying ofHistoricCaseInstances.- Author:
- Tom Baeyens, Joram Barrez, Falko Menge
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description HistoricCaseInstanceQueryactive()Only select historic case instances which are activeHistoricCaseInstanceQuerycaseActivityIdIn(java.lang.String... caseActivityIds)Only selects historic case instances with historic case activity instances in at least one of the given case activity ids.HistoricCaseInstanceQuerycaseDefinitionId(java.lang.String caseDefinitionId)Only select historic case instances for the given case definitionHistoricCaseInstanceQuerycaseDefinitionKey(java.lang.String caseDefinitionKey)Only select historic case instances that are defined by a case definition with the given key.HistoricCaseInstanceQuerycaseDefinitionKeyNotIn(java.util.List<java.lang.String> caseDefinitionKeys)Only select historic case instances that don't have a case definition of which the key is present in the given listHistoricCaseInstanceQuerycaseDefinitionName(java.lang.String caseDefinitionName)Only select historic case instances that are defined by a case definition with the given name.HistoricCaseInstanceQuerycaseDefinitionNameLike(java.lang.String nameLike)Only select historic case instances that are defined by case definition which name is like the given value.HistoricCaseInstanceQuerycaseInstanceBusinessKey(java.lang.String caseInstanceBusinessKey)Only select historic case instances with the given business keyHistoricCaseInstanceQuerycaseInstanceBusinessKeyLike(java.lang.String caseInstanceBusinessKeyLike)Only select historic case instances which had a business key like the given value.HistoricCaseInstanceQuerycaseInstanceId(java.lang.String caseInstanceId)Only select historic case instances with the given case instance id.HistoricCaseInstanceQuerycaseInstanceIds(java.util.Set<java.lang.String> caseInstanceIds)Only select historic case instances whose id is in the given set of ids.HistoricCaseInstanceQueryclosed()Only select historic case instances which are closedHistoricCaseInstanceQueryclosedAfter(java.util.Date date)Only select historic case instances that were closed after the given date.HistoricCaseInstanceQueryclosedBefore(java.util.Date date)Only select historic case instances that were closed before the given date.HistoricCaseInstanceQuerycompleted()Only select historic case instances which are completedHistoricCaseInstanceQuerycreatedAfter(java.util.Date date)Only select historic case instances that were created after the given date.HistoricCaseInstanceQuerycreatedBefore(java.util.Date date)Only select historic case instances that were created before the given date.HistoricCaseInstanceQuerycreatedBy(java.lang.String userId)Only select historic case instance that are created by the given user.HistoricCaseInstanceQuerymatchVariableNamesIgnoreCase()The query will match the names of variables in a case-insensitive way.HistoricCaseInstanceQuerymatchVariableValuesIgnoreCase()The query will match the values of variables in a case-insensitive way.HistoricCaseInstanceQuerynotClosed()Only select historic case instance that are not yet closed.HistoricCaseInstanceQueryorderByCaseDefinitionId()Order by the case definition id (needs to be followed byQuery.asc()orQuery.desc()).HistoricCaseInstanceQueryorderByCaseInstanceBusinessKey()Order by the business key (needs to be followed byQuery.asc()orQuery.desc()).HistoricCaseInstanceQueryorderByCaseInstanceCloseTime()Order by the close time (needs to be followed byQuery.asc()orQuery.desc()).HistoricCaseInstanceQueryorderByCaseInstanceCreateTime()Order by the create time (needs to be followed byQuery.asc()orQuery.desc()).HistoricCaseInstanceQueryorderByCaseInstanceDuration()Order by the duration of the case instance (needs to be followed byQuery.asc()orQuery.desc()).HistoricCaseInstanceQueryorderByCaseInstanceId()Order by the case instance id (needs to be followed byQuery.asc()orQuery.desc()).HistoricCaseInstanceQueryorderByTenantId()Order by tenant id (needs to be followed byQuery.asc()orQuery.desc()).HistoricCaseInstanceQuerysubCaseInstanceId(java.lang.String subCaseInstanceId)Only select historic case instances having a sub case instance with the given case instance id.HistoricCaseInstanceQuerysubProcessInstanceId(java.lang.String subProcessInstanceId)Only select historic case instances having a sub process instance with the given process instance id.HistoricCaseInstanceQuerysuperCaseInstanceId(java.lang.String superCaseInstanceId)Only select historic case instances started by the given case instance.HistoricCaseInstanceQuerysuperProcessInstanceId(java.lang.String superProcessInstanceId)Only select historic case instances started by the given process instance.HistoricCaseInstanceQuerytenantIdIn(java.lang.String... tenantIds)Only select historic case instances with one of the given tenant ids.HistoricCaseInstanceQueryterminated()Only select historic case instances which are terminatedHistoricCaseInstanceQueryvariableValueEquals(java.lang.String name, java.lang.Object value)Only select case instances which have a global variable with the given value.HistoricCaseInstanceQueryvariableValueGreaterThan(java.lang.String name, java.lang.Object value)Only select case instances which had a global variable with the given name and a value greater than the given value when they where closed.HistoricCaseInstanceQueryvariableValueGreaterThanOrEqual(java.lang.String name, java.lang.Object value)Only select case instances which have a global variable with the given name and a value greater or equal than the given value.HistoricCaseInstanceQueryvariableValueLessThan(java.lang.String name, java.lang.Object value)Only select case instances which have a global variable with the given name and a value less than the given value.HistoricCaseInstanceQueryvariableValueLessThanOrEqual(java.lang.String name, java.lang.Object value)Only select case instances which have a global variable with the given name and a value less or equal than the given value.HistoricCaseInstanceQueryvariableValueLike(java.lang.String name, java.lang.String value)Only select case instances which have a global variable with the given name and a value like given value.HistoricCaseInstanceQueryvariableValueNotEquals(java.lang.String name, java.lang.Object value)Only select case instances which have a global variable with the given name but a different value.HistoricCaseInstanceQueryvariableValueNotLike(java.lang.String name, java.lang.String value)Only select case instances which have a global variable with the given name and not matching the given value.HistoricCaseInstanceQuerywithoutTenantId()Only selects historic case instances which have no tenant id.-
Methods inherited from interface org.camunda.bpm.engine.query.Query
asc, count, desc, list, listPage, singleResult, unlimitedList
-
-
-
-
Method Detail
-
caseInstanceId
HistoricCaseInstanceQuery caseInstanceId(java.lang.String caseInstanceId)
Only select historic case instances with the given case instance id.
-
caseInstanceIds
HistoricCaseInstanceQuery caseInstanceIds(java.util.Set<java.lang.String> caseInstanceIds)
Only select historic case instances whose id is in the given set of ids.
-
caseDefinitionId
HistoricCaseInstanceQuery caseDefinitionId(java.lang.String caseDefinitionId)
Only select historic case instances for the given case definition
-
caseDefinitionKey
HistoricCaseInstanceQuery caseDefinitionKey(java.lang.String caseDefinitionKey)
Only select historic case instances that are defined by a case definition with the given key.
-
caseDefinitionKeyNotIn
HistoricCaseInstanceQuery caseDefinitionKeyNotIn(java.util.List<java.lang.String> caseDefinitionKeys)
Only select historic case instances that don't have a case definition of which the key is present in the given list
-
caseDefinitionName
HistoricCaseInstanceQuery caseDefinitionName(java.lang.String caseDefinitionName)
Only select historic case instances that are defined by a case definition with the given name.
-
caseDefinitionNameLike
HistoricCaseInstanceQuery caseDefinitionNameLike(java.lang.String nameLike)
Only select historic case instances that are defined by case definition which name is like the given value.- Parameters:
nameLike- The string can include the wildcard character '%' to express like-strategy: starts with (string%), ends with (%string) or contains (%string%).
-
caseInstanceBusinessKey
HistoricCaseInstanceQuery caseInstanceBusinessKey(java.lang.String caseInstanceBusinessKey)
Only select historic case instances with the given business key
-
caseInstanceBusinessKeyLike
HistoricCaseInstanceQuery caseInstanceBusinessKeyLike(java.lang.String caseInstanceBusinessKeyLike)
Only select historic case instances which had a business key like the given value.- Parameters:
caseInstanceBusinessKeyLike- The string can include the wildcard character '%' to express like-strategy: starts with (string%), ends with (%string) or contains (%string%).
-
caseActivityIdIn
HistoricCaseInstanceQuery caseActivityIdIn(java.lang.String... caseActivityIds)
Only selects historic case instances with historic case activity instances in at least one of the given case activity ids.
-
createdBefore
HistoricCaseInstanceQuery createdBefore(java.util.Date date)
Only select historic case instances that were created before the given date.
-
createdAfter
HistoricCaseInstanceQuery createdAfter(java.util.Date date)
Only select historic case instances that were created after the given date.
-
closedBefore
HistoricCaseInstanceQuery closedBefore(java.util.Date date)
Only select historic case instances that were closed before the given date.
-
closedAfter
HistoricCaseInstanceQuery closedAfter(java.util.Date date)
Only select historic case instances that were closed after the given date.
-
createdBy
HistoricCaseInstanceQuery createdBy(java.lang.String userId)
Only select historic case instance that are created by the given user.
-
superCaseInstanceId
HistoricCaseInstanceQuery superCaseInstanceId(java.lang.String superCaseInstanceId)
Only select historic case instances started by the given case instance.
-
subCaseInstanceId
HistoricCaseInstanceQuery subCaseInstanceId(java.lang.String subCaseInstanceId)
Only select historic case instances having a sub case instance with the given case instance id. Note that there will always be maximum only one such case instance that can be the result of this query.
-
superProcessInstanceId
HistoricCaseInstanceQuery superProcessInstanceId(java.lang.String superProcessInstanceId)
Only select historic case instances started by the given process instance.
-
subProcessInstanceId
HistoricCaseInstanceQuery subProcessInstanceId(java.lang.String subProcessInstanceId)
Only select historic case instances having a sub process instance with the given process instance id. Note that there will always be maximum only one such case instance that can be the result of this query.
-
tenantIdIn
HistoricCaseInstanceQuery tenantIdIn(java.lang.String... tenantIds)
Only select historic case instances with one of the given tenant ids.
-
withoutTenantId
HistoricCaseInstanceQuery withoutTenantId()
Only selects historic case instances which have no tenant id.
-
active
HistoricCaseInstanceQuery active()
Only select historic case instances which are active
-
completed
HistoricCaseInstanceQuery completed()
Only select historic case instances which are completed
-
terminated
HistoricCaseInstanceQuery terminated()
Only select historic case instances which are terminated
-
closed
HistoricCaseInstanceQuery closed()
Only select historic case instances which are closed
-
notClosed
HistoricCaseInstanceQuery notClosed()
Only select historic case instance that are not yet closed.
-
matchVariableNamesIgnoreCase
HistoricCaseInstanceQuery matchVariableNamesIgnoreCase()
The query will match the names of variables in a case-insensitive way.
-
matchVariableValuesIgnoreCase
HistoricCaseInstanceQuery matchVariableValuesIgnoreCase()
The query will match the values of variables in a case-insensitive way.
-
variableValueEquals
HistoricCaseInstanceQuery variableValueEquals(java.lang.String name, java.lang.Object value)
Only select case instances which have a global variable with the given value.- Parameters:
name- the name of the variablevalue- the value of the variable- Throws:
NotValidException- if the name is null
-
variableValueNotEquals
HistoricCaseInstanceQuery variableValueNotEquals(java.lang.String name, java.lang.Object value)
Only select case instances which have a global variable with the given name but a different value.- Parameters:
name- the name of the variablevalue- the value of the variable- Throws:
NotValidException- if the name is null
-
variableValueGreaterThan
HistoricCaseInstanceQuery variableValueGreaterThan(java.lang.String name, java.lang.Object value)
Only select case instances which had a global variable with the given name and a value greater than the given value when they where closed.- Parameters:
name- the name of the variablevalue- the value of the variable- Throws:
NotValidException- if the name or value is null
-
variableValueGreaterThanOrEqual
HistoricCaseInstanceQuery variableValueGreaterThanOrEqual(java.lang.String name, java.lang.Object value)
Only select case instances which have a global variable with the given name and a value greater or equal than the given value.- Parameters:
name- the name of the variablevalue- the value of the variable- Throws:
NotValidException- if the name or value is null
-
variableValueLessThan
HistoricCaseInstanceQuery variableValueLessThan(java.lang.String name, java.lang.Object value)
Only select case instances which have a global variable with the given name and a value less than the given value.- Parameters:
name- the name of the variablevalue- the value of the variable- Throws:
NotValidException- if the name or value is null
-
variableValueLessThanOrEqual
HistoricCaseInstanceQuery variableValueLessThanOrEqual(java.lang.String name, java.lang.Object value)
Only select case instances which have a global variable with the given name and a value less or equal than the given value.- Parameters:
name- the name of the variablevalue- the value of the variable- Throws:
NotValidException- if the name or value is null
-
variableValueLike
HistoricCaseInstanceQuery variableValueLike(java.lang.String name, java.lang.String value)
Only select case instances which have a global variable with the given name and a value like given value.- Parameters:
name- the name of the variablevalue- the value of the variable, it can include the wildcard character '%' to express like-strategy: starts with (string%), ends with (%string), contains (%string%)- Throws:
NotValidException- if the name or value is null
-
variableValueNotLike
HistoricCaseInstanceQuery variableValueNotLike(java.lang.String name, java.lang.String value)
Only select case instances which have a global variable with the given name and not matching the given value. The syntax is that of SQL: for example usage: valueNotLike(%value%)- Parameters:
name- the name of the variablevalue- the value of the variable, it can include the wildcard character '%' to express like-strategy: starts with (string%), ends with (%string), contains (%string%)- Throws:
NotValidException- if the name or value is null or a null-value or a boolean-value is used
-
orderByCaseInstanceId
HistoricCaseInstanceQuery orderByCaseInstanceId()
Order by the case instance id (needs to be followed byQuery.asc()orQuery.desc()).
-
orderByCaseDefinitionId
HistoricCaseInstanceQuery orderByCaseDefinitionId()
Order by the case definition id (needs to be followed byQuery.asc()orQuery.desc()).
-
orderByCaseInstanceBusinessKey
HistoricCaseInstanceQuery orderByCaseInstanceBusinessKey()
Order by the business key (needs to be followed byQuery.asc()orQuery.desc()).
-
orderByCaseInstanceCreateTime
HistoricCaseInstanceQuery orderByCaseInstanceCreateTime()
Order by the create time (needs to be followed byQuery.asc()orQuery.desc()).
-
orderByCaseInstanceCloseTime
HistoricCaseInstanceQuery orderByCaseInstanceCloseTime()
Order by the close time (needs to be followed byQuery.asc()orQuery.desc()).
-
orderByCaseInstanceDuration
HistoricCaseInstanceQuery orderByCaseInstanceDuration()
Order by the duration of the case instance (needs to be followed byQuery.asc()orQuery.desc()).
-
orderByTenantId
HistoricCaseInstanceQuery orderByTenantId()
Order by tenant id (needs to be followed byQuery.asc()orQuery.desc()). Note that the ordering of historic case instances without tenant id is database-specific.
-
-