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.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.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
.Groups the result of the query by the fieldBusinessCaseId
.Groups the result of the query by the fieldBusinessRuntime
.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
.Groups the result of the query by the fieldEndTimestamp
.Groups the result of the query by the fieldEnvironment
.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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
environment
Description copied from interface:CaseQuery.IGroupByQueryColumns
Groups the result of the query by the field
Environment
.SQL part:
GROUP BY Environment
- Specified by:
environment
in interfaceCaseQuery.IGroupByQueryColumns
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-
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 IvyScript and Java. It has the visibility EXPERT.
-