Class CaseQuery.GroupByQuery
- All Implemented Interfaces:
CaseQuery.IGroupByQueryColumns
- Enclosing class:
- CaseQuery
Example:
Corresponds to SQL:
CaseQuery.businessCases().groupBy().ownerRoleId().ownerName().aggregate().countRows();
SELECT OwnerRoleId, OwnerUserId, Count(*) AS Count FROM IWA_Case GROUP BY OwnerRoleId, OwnerUserId
- API:
- This is a public API.
-
Nested Class Summary
Nested classes/interfaces inherited from class ch.ivyteam.ivy.workflow.query.CaseQuery
CaseQuery.AggregationQuery, CaseQuery.FilterLink, CaseQuery.FilterQuery, CaseQuery.GroupByQuery, CaseQuery.IAggregationQuery, CaseQuery.IBoolFilterQuery, CaseQuery.ICaseBusinessStateFilterQuery, CaseQuery.ICaseStateFilterQuery, CaseQuery.IClobColumnFilterQuery, CaseQuery.IColumnFilterQuery, CaseQuery.ICustomFieldAggregationQuery, CaseQuery.ICustomFieldFilterQuery, CaseQuery.ICustomFieldGroupBy, CaseQuery.ICustomFieldOrderBy, CaseQuery.IDateColumnFilterQuery, CaseQuery.IFilterableColumns, CaseQuery.IFilterLink, CaseQuery.IFilterQuery, CaseQuery.IGroupByQueryColumns, CaseQuery.IIntegerColumnFilterQuery, CaseQuery.INumberColumnFilterQuery, CaseQuery.IOrderByQueryColumns, CaseQuery.IPatternColumnFilterQuery, CaseQuery.IStringColumnFilterQuery, CaseQuery.IUUIDColumnFilterQuery, CaseQuery.IWorkflowPriorityFilterQuery, CaseQuery.OrderByColumnQuery, CaseQuery.OrderByQuery
-
Method Summary
Modifier and TypeMethodDescriptionGroups the result of the query by the fieldActivatorId
.Groups the result of the query by the fieldApplicationId
.Groups the result of the query by the fieldBusinessCalendar
.Deprecated.Groups the result of the query by the fieldBusinessCaseId
.Groups the result of the query by the fieldBusinessRuntime
.Groups the result of the query by the fieldBusinessState
.caseId()
Groups the result of the query by the fieldCaseId
.category()
Groups the result of the query by the fieldCategory
.Groups the result of the query by the fieldCreatorId
.Groups the result of the query by the fieldCreatorTaskId
.Groups the result of the query by the fieldCreatorUserDisplayName
.Groups the result of the query by the fieldCreatorUserName
.Groups the result of the query by a custom field specified during further composition.Groups the result of the query by the fieldDescription
.Deprecated, for removal: This API element is subject to removal in a future version.Deprecated, for removal: This API element is subject to removal in a future version.Groups the result of the query by the fieldEndTimestamp
.Groups the result of the query by the fieldLanguageId
.name()
Groups the result of the query by the fieldName
.Groups the result of the query by the fieldOwnerDisplayName
.ownerId()
Groups the result of the query by the fieldOwnerId
.Groups the result of the query by the fieldOwnerName
.priority()
Groups the result of the query by the fieldPriority
.Groups the result of the query by the fieldProcessModelId
.Groups the result of the query by the fieldSecuritySystemId
.stage()
Groups the result of the query by the fieldStage
.Groups the result of the query by the fieldStartTimestamp
.state()
Groups the result of the query by the fieldState
.Groups the result of the query by the fieldTaskStartId
.Groups the result of the query by the fieldWorkingTime
.
-
Method Details
-
caseId
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
CaseId
.SQL part:
GROUP BY CaseId
- Specified by:
caseId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
businessCaseId
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
BusinessCaseId
.SQL part:
GROUP BY BusinessCaseId
- Specified by:
businessCaseId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
securitySystemId
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
SecuritySystemId
.SQL part:
GROUP BY SecuritySystemId
- Specified by:
securitySystemId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
applicationId
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
ApplicationId
.SQL part:
GROUP BY ApplicationId
- Specified by:
applicationId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
processModelId
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
ProcessModelId
.SQL part:
GROUP BY ProcessModelId
- Specified by:
processModelId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
taskStartId
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
TaskStartId
.SQL part:
GROUP BY TaskStartId
- Specified by:
taskStartId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
activatorId
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
ActivatorId
.SQL part:
GROUP BY ActivatorId
- Specified by:
activatorId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
creatorId
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
CreatorId
.SQL part:
GROUP BY CreatorId
- Specified by:
creatorId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
creatorUserName
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
CreatorUserName
.SQL part:
GROUP BY CreatorUserName
This is a virtual column. It contains the same value as the column
Name
of the referencedCreator
.- Specified by:
creatorUserName
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
creatorUserDisplayName
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
CreatorUserDisplayName
.SQL part:
GROUP BY CreatorUserDisplayName
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedCreator
.- Specified by:
creatorUserDisplayName
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
creatorTaskId
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
CreatorTaskId
.SQL part:
GROUP BY CreatorTaskId
- Specified by:
creatorTaskId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
name
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
Name
.SQL part:
GROUP BY Name
This is a virtual column. It contains the same value as the column
Name
of the referencedCaseLocalized
.- Specified by:
name
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
description
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
Description
.SQL part:
GROUP BY Description
This is a virtual column. It contains the same value as the column
Description
of the referencedCaseLocalized
.- Specified by:
description
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
startTimestamp
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
StartTimestamp
.SQL part:
GROUP BY StartTimestamp
- Specified by:
startTimestamp
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
endTimestamp
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
EndTimestamp
.SQL part:
GROUP BY EndTimestamp
- Specified by:
endTimestamp
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
businessCalendar
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
BusinessCalendar
.SQL part:
GROUP BY BusinessCalendar
- Specified by:
businessCalendar
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
workingTime
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
WorkingTime
.SQL part:
GROUP BY WorkingTime
- Specified by:
workingTime
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
businessRuntime
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
BusinessRuntime
.SQL part:
GROUP BY BusinessRuntime
- Specified by:
businessRuntime
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
state
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
State
.SQL part:
GROUP BY State
- Specified by:
state
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
businessState
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
BusinessState
.SQL part:
GROUP BY BusinessState
- Specified by:
businessState
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
priority
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
Priority
.SQL part:
GROUP BY Priority
- Specified by:
priority
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
stage
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
Stage
.SQL part:
GROUP BY Stage
- Specified by:
stage
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
ownerId
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
OwnerId
.SQL part:
GROUP BY OwnerId
- Specified by:
ownerId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
ownerName
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
OwnerName
.SQL part:
GROUP BY OwnerName
This is a virtual column. It contains the same value as the column
MemberName
of the referencedOwner
.- Specified by:
ownerName
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
ownerDisplayName
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
OwnerDisplayName
.SQL part:
GROUP BY OwnerDisplayName
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedOwner
.- Specified by:
ownerDisplayName
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
category
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
Category
.SQL part:
GROUP BY Category
- Specified by:
category
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
languageId
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
LanguageId
.SQL part:
GROUP BY LanguageId
This is a virtual column. It contains the same value as the column
LanguageId
of the referencedCaseLocalized
.- Specified by:
languageId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
customField
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by a custom field specified during further composition.
- Specified by:
customField
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
businessCalendarId
Deprecated.Description copied from interface:CaseQuery.IGroupByQueryColumns
This method is deprecated. Instead of grouping the query by the field
BusinessCalendarId
it groups by the fieldBusinessCalendar
.
SQL part:
GROUP BY BusinessCalendar
- Specified by:
businessCalendarId
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
displayNameTemplate
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from interface:CaseQuery.IGroupByQueryColumns
Does not add any group by because column
DisplayNameTemplate
was removed without any replacement.- Specified by:
displayNameTemplate
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
displayDescriptionTemplate
@Deprecated(since="9.4", forRemoval=true) public CaseQuery.GroupByQuery displayDescriptionTemplate()Deprecated, for removal: This API element is subject to removal in a future version.Description copied from interface:CaseQuery.IGroupByQueryColumns
Does not add any filter because column
DisplayDescriptionTemplate
was removed without any replacement.- Specified by:
displayDescriptionTemplate
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in Java.
-