java.lang.Object
- ch.ivyteam.ivy.persistence.query.Query<ICase>
- - ch.ivyteam.ivy.workflow.query.CaseQuery
  - - ch.ivyteam.ivy.workflow.query.CaseQuery.GroupByQuery

All Implemented Interfaces:: CaseQuery.IGroupByQueryColumns

Enclosing class:: CaseQuery

public static class CaseQuery.GroupByQuery
extends CaseQuery
implements CaseQuery.IGroupByQueryColumns

Provides methods to group the result by certain fields.

Example:

CaseQuery.businessCases().groupBy().ownerRoleId().ownerName().aggregate().countRows();

Corresponds to SQL: 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

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`CaseQuery.GroupByQuery`	`activatorId()`	Groups the result of the query by the field `ActivatorId`.
`CaseQuery.GroupByQuery`	`applicationId()`	Groups the result of the query by the field `ApplicationId`.
`CaseQuery.GroupByQuery`	`businessCalendar()`	Groups the result of the query by the field `BusinessCalendar`.
`CaseQuery.GroupByQuery`	`businessCaseId()`	Groups the result of the query by the field `BusinessCaseId`.
`CaseQuery.GroupByQuery`	`businessRuntime()`	Groups the result of the query by the field `BusinessRuntime`.
`CaseQuery.GroupByQuery`	`caseId()`	Groups the result of the query by the field `CaseId`.
`CaseQuery.GroupByQuery`	`category()`	Groups the result of the query by the field `Category`.
`CaseQuery.GroupByQuery`	`creatorId()`	Groups the result of the query by the field `CreatorId`.
`CaseQuery.GroupByQuery`	`creatorTaskId()`	Groups the result of the query by the field `CreatorTaskId`.
`CaseQuery.GroupByQuery`	`creatorUserDisplayName()`	Groups the result of the query by the field `CreatorUserDisplayName`.
`CaseQuery.GroupByQuery`	`creatorUserName()`	Groups the result of the query by the field `CreatorUserName`.
`CaseQuery.ICustomFieldGroupBy`	`customField()`	Groups the result of the query by a custom field specified during further composition.
`CaseQuery.GroupByQuery`	`description()`	Groups the result of the query by the field `Description`.
`CaseQuery.GroupByQuery`	`displayDescriptionTemplate()`	Groups the result of the query by the field `DisplayDescriptionTemplate`.
`CaseQuery.GroupByQuery`	`displayNameTemplate()`	Groups the result of the query by the field `DisplayNameTemplate`.
`CaseQuery.GroupByQuery`	`endTimestamp()`	Groups the result of the query by the field `EndTimestamp`.
`CaseQuery.GroupByQuery`	`environment()`	Groups the result of the query by the field `Environment`.
`CaseQuery.GroupByQuery`	`name()`	Groups the result of the query by the field `Name`.
`CaseQuery.GroupByQuery`	`ownerDisplayName()`	Groups the result of the query by the field `OwnerDisplayName`.
`CaseQuery.GroupByQuery`	`ownerId()`	Groups the result of the query by the field `OwnerId`.
`CaseQuery.GroupByQuery`	`ownerName()`	Groups the result of the query by the field `OwnerName`.
`CaseQuery.GroupByQuery`	`priority()`	Groups the result of the query by the field `Priority`.
`CaseQuery.GroupByQuery`	`processModelId()`	Groups the result of the query by the field `ProcessModelId`.
`CaseQuery.GroupByQuery`	`stage()`	Groups the result of the query by the field `Stage`.
`CaseQuery.GroupByQuery`	`startTimestamp()`	Groups the result of the query by the field `StartTimestamp`.
`CaseQuery.GroupByQuery`	`state()`	Groups the result of the query by the field `State`.
`CaseQuery.GroupByQuery`	`taskStartId()`	Groups the result of the query by the field `TaskStartId`.
`CaseQuery.GroupByQuery`	`workingTime()`	Groups the result of the query by the field `WorkingTime`.

Methods inherited from class ch.ivyteam.ivy.workflow.query.CaseQuery
aggregate, businessCases, create, executor, groupBy, orderBy, subCases, where

- Method Detail
  - caseId
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.caseId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - businessCaseId
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.businessCaseId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - applicationId
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.applicationId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - processModelId
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.processModelId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - taskStartId
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.taskStartId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - activatorId
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.activatorId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - creatorId
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.creatorId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - creatorUserName
```
public CaseQuery.GroupByQuery 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 referenced Creator.
    
    Specified by:
    
    creatorUserName in interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.creatorUserName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - creatorUserDisplayName
```
public CaseQuery.GroupByQuery 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 referenced Creator.
    
    Specified by:
    
    creatorUserDisplayName in interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.creatorUserDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - creatorTaskId
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.creatorTaskId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - environment
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.environment()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - displayNameTemplate
```
public CaseQuery.GroupByQuery displayNameTemplate()
```
    Description copied from interface: CaseQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field DisplayNameTemplate.
    
    SQL part: GROUP BY DisplayNameTemplate
    
    Specified by:
    
    displayNameTemplate in interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.displayNameTemplate()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - name
```
public CaseQuery.GroupByQuery name()
```
    Description copied from interface: CaseQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field Name.
    
    SQL part: GROUP BY Name
    
    Specified by:
    
    name in interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.name()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - displayDescriptionTemplate
```
public CaseQuery.GroupByQuery displayDescriptionTemplate()
```
    Description copied from interface: CaseQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field DisplayDescriptionTemplate.
    
    SQL part: GROUP BY DisplayDescriptionTemplate
    
    Specified by:
    
    displayDescriptionTemplate in interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.displayDescriptionTemplate()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - description
```
public CaseQuery.GroupByQuery description()
```
    Description copied from interface: CaseQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field Description.
    
    SQL part: GROUP BY Description
    
    Specified by:
    
    description in interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.description()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - startTimestamp
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.startTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - endTimestamp
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.endTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - businessCalendar
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.businessCalendar()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - workingTime
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.workingTime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - businessRuntime
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.businessRuntime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - state
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.state()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - priority
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.priority()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - stage
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.stage()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - ownerId
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.ownerId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - ownerName
```
public CaseQuery.GroupByQuery 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 referenced Owner.
    
    Specified by:
    
    ownerName in interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.ownerName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - ownerDisplayName
```
public CaseQuery.GroupByQuery 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 referenced Owner.
    
    Specified by:
    
    ownerDisplayName in interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.ownerDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - category
```
public CaseQuery.GroupByQuery 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IGroupByQueryColumns.category()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - customField
```
public CaseQuery.ICustomFieldGroupBy 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 interface CaseQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.

Class CaseQuery.GroupByQuery

Nested Class Summary

Nested classes/interfaces inherited from class ch.ivyteam.ivy.workflow.query.CaseQuery

Method Summary

Methods inherited from class ch.ivyteam.ivy.workflow.query.CaseQuery

Method Detail

caseId

businessCaseId

applicationId

processModelId

taskStartId

activatorId

creatorId

creatorUserName

creatorUserDisplayName

creatorTaskId

environment

displayNameTemplate

name

displayDescriptionTemplate

description

startTimestamp

endTimestamp

businessCalendar

workingTime

businessRuntime

state

priority

stage

ownerId

ownerName

ownerDisplayName

category

customField