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

All Implemented Interfaces:: CaseQuery.IAggregationQuery

Enclosing class:: CaseQuery

public static class CaseQuery.AggregationQuery
extends CaseQuery
implements CaseQuery.IAggregationQuery

This class provides methods to perform aggregations on the query. For each aggregation a column is added to the result set.

Example:

CaseQuery.businessCases().aggregate().sumWorkingTime().avgWorkingTime();

Corresponds to SQL: SELECT SUM(WorkingTime) AS SumWorkingTime, AVG(WorkingTime) AS AvgWorkingTime FROM IWA_Case

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.AggregationQuery`	`avgBusinessRuntime()`	Adds a result column `AvgBusinessRuntime` to the query, that contains the average of the field `BusinessRuntime` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`avgEndTimestamp()`	Adds a result column `AvgEndTimestamp` to the query, that contains the average of the field `EndTimestamp` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`avgStartTimestamp()`	Adds a result column `AvgStartTimestamp` to the query, that contains the average of the field `StartTimestamp` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`avgWorkingTime()`	Adds a result column `AvgWorkingTime` to the query, that contains the average of the field `WorkingTime` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`countRows()`	Adds a result column `Count` to the query, that contains the number of (grouped) rows.
`CaseQuery.ICustomFieldAggregationQuery`	`customField()`	Adds a result custom field to the query.
`CaseQuery.AggregationQuery`	`maxBusinessCalendar()`	Adds a result column `MaxBusinessCalendar` to the query, that contains the maximum value of the field `BusinessCalendar` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`maxBusinessRuntime()`	Adds a result column `MaxBusinessRuntime` to the query, that contains the maximum value of the field `BusinessRuntime` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`maxCaseId()`	Adds a result column `MaxCaseId` to the query, that contains the maximum value of the field `CaseId` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`maxCategory()`	Adds a result column `MaxCategory` to the query, that contains the maximum value of the field `Category` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`maxCreatorUserDisplayName()`	Adds a result column `MaxCreatorUserDisplayName` to the query, that contains the maximum value of the field `CreatorUserDisplayName` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`maxCreatorUserName()`	Adds a result column `MaxCreatorUserName` to the query, that contains the maximum value of the field `CreatorUserName` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`maxDisplayNameTemplate()`	Adds a result column `MaxDisplayNameTemplate` to the query, that contains the maximum value of the field `DisplayNameTemplate` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`maxEndTimestamp()`	Adds a result column `MaxEndTimestamp` to the query, that contains the maximum value of the field `EndTimestamp` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`maxName()`	Adds a result column `MaxName` to the query, that contains the maximum value of the field `Name` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`maxOwnerDisplayName()`	Adds a result column `MaxOwnerDisplayName` to the query, that contains the maximum value of the field `OwnerDisplayName` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`maxOwnerName()`	Adds a result column `MaxOwnerName` to the query, that contains the maximum value of the field `OwnerName` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`maxStage()`	Adds a result column `MaxStage` to the query, that contains the maximum value of the field `Stage` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`maxStartTimestamp()`	Adds a result column `MaxStartTimestamp` to the query, that contains the maximum value of the field `StartTimestamp` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`maxWorkingTime()`	Adds a result column `MaxWorkingTime` to the query, that contains the maximum value of the field `WorkingTime` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`minBusinessCalendar()`	Adds a result column `MinBusinessCalendar` to the query, that contains the minimum value of the field `BusinessCalendar` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`minBusinessRuntime()`	Adds a result column `MinBusinessRuntime` to the query, that contains the minimum value of the field `BusinessRuntime` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`minCaseId()`	Adds a result column `MinCaseId` to the query, that contains the minimum value of the field `CaseId` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`minCategory()`	Adds a result column `MinCategory` to the query, that contains the minimum value of the field `Category` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`minCreatorUserDisplayName()`	Adds a result column `MinCreatorUserDisplayName` to the query, that contains the minimum value of the field `CreatorUserDisplayName` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`minCreatorUserName()`	Adds a result column `MinCreatorUserName` to the query, that contains the minimum value of the field `CreatorUserName` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`minDisplayNameTemplate()`	Adds a result column `MinDisplayNameTemplate` to the query, that contains the minimum value of the field `DisplayNameTemplate` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`minEndTimestamp()`	Adds a result column `MinEndTimestamp` to the query, that contains the minimum value of the field `EndTimestamp` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`minName()`	Adds a result column `MinName` to the query, that contains the minimum value of the field `Name` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`minOwnerDisplayName()`	Adds a result column `MinOwnerDisplayName` to the query, that contains the minimum value of the field `OwnerDisplayName` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`minOwnerName()`	Adds a result column `MinOwnerName` to the query, that contains the minimum value of the field `OwnerName` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`minStage()`	Adds a result column `MinStage` to the query, that contains the minimum value of the field `Stage` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`minStartTimestamp()`	Adds a result column `MinStartTimestamp` to the query, that contains the minimum value of the field `StartTimestamp` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`minWorkingTime()`	Adds a result column `MinWorkingTime` to the query, that contains the minimum value of the field `WorkingTime` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`sumBusinessRuntime()`	Adds a result column `SumBusinessRuntime` to the query, that contains the sum of the field `BusinessRuntime` of all (grouped) rows.
`CaseQuery.AggregationQuery`	`sumWorkingTime()`	Adds a result column `SumWorkingTime` to the query, that contains the sum of the field `WorkingTime` of all (grouped) rows.

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

- Method Detail
  - countRows
```
public CaseQuery.AggregationQuery countRows()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column Count to the query, that contains the number of (grouped) rows.
    
    SQL part: COUNT(*) AS Count
    
    Specified by:
    
    countRows in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.countRows()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minCaseId
```
public CaseQuery.AggregationQuery minCaseId()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MinCaseId to the query, that contains the minimum value of the field CaseId of all (grouped) rows.
    
    SQL part: MIN(CaseId) AS MinCaseId
    
    Specified by:
    
    minCaseId in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.minCaseId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxCaseId
```
public CaseQuery.AggregationQuery maxCaseId()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MaxCaseId to the query, that contains the maximum value of the field CaseId of all (grouped) rows.
    
    SQL part: MAX(CaseId) AS MaxCaseId
    
    Specified by:
    
    maxCaseId in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.maxCaseId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minCreatorUserName
```
public CaseQuery.AggregationQuery minCreatorUserName()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MinCreatorUserName to the query, that contains the minimum value of the field CreatorUserName of all (grouped) rows.
    
    SQL part: MIN(CreatorUserName) AS MinCreatorUserName
    
    This is a virtual column. It contains the same value as the column Name of the referenced Creator.
    
    Specified by:
    
    minCreatorUserName in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.minCreatorUserName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxCreatorUserName
```
public CaseQuery.AggregationQuery maxCreatorUserName()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MaxCreatorUserName to the query, that contains the maximum value of the field CreatorUserName of all (grouped) rows.
    
    SQL part: MAX(CreatorUserName) AS MaxCreatorUserName
    
    This is a virtual column. It contains the same value as the column Name of the referenced Creator.
    
    Specified by:
    
    maxCreatorUserName in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.maxCreatorUserName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minCreatorUserDisplayName
```
public CaseQuery.AggregationQuery minCreatorUserDisplayName()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MinCreatorUserDisplayName to the query, that contains the minimum value of the field CreatorUserDisplayName of all (grouped) rows.
    
    SQL part: MIN(CreatorUserDisplayName) AS MinCreatorUserDisplayName
    
    This is a virtual column. It contains the same value as the column DisplayName of the referenced Creator.
    
    Specified by:
    
    minCreatorUserDisplayName in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.minCreatorUserDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxCreatorUserDisplayName
```
public CaseQuery.AggregationQuery maxCreatorUserDisplayName()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MaxCreatorUserDisplayName to the query, that contains the maximum value of the field CreatorUserDisplayName of all (grouped) rows.
    
    SQL part: MAX(CreatorUserDisplayName) AS MaxCreatorUserDisplayName
    
    This is a virtual column. It contains the same value as the column DisplayName of the referenced Creator.
    
    Specified by:
    
    maxCreatorUserDisplayName in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.maxCreatorUserDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minDisplayNameTemplate
```
public CaseQuery.AggregationQuery minDisplayNameTemplate()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MinDisplayNameTemplate to the query, that contains the minimum value of the field DisplayNameTemplate of all (grouped) rows.
    
    SQL part: MIN(DisplayNameTemplate) AS MinDisplayNameTemplate
    
    Specified by:
    
    minDisplayNameTemplate in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.minDisplayNameTemplate()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxDisplayNameTemplate
```
public CaseQuery.AggregationQuery maxDisplayNameTemplate()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MaxDisplayNameTemplate to the query, that contains the maximum value of the field DisplayNameTemplate of all (grouped) rows.
    
    SQL part: MAX(DisplayNameTemplate) AS MaxDisplayNameTemplate
    
    Specified by:
    
    maxDisplayNameTemplate in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.maxDisplayNameTemplate()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minName
```
public CaseQuery.AggregationQuery minName()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MinName to the query, that contains the minimum value of the field Name of all (grouped) rows.
    
    SQL part: MIN(Name) AS MinName
    
    Specified by:
    
    minName in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.minName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxName
```
public CaseQuery.AggregationQuery maxName()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MaxName to the query, that contains the maximum value of the field Name of all (grouped) rows.
    
    SQL part: MAX(Name) AS MaxName
    
    Specified by:
    
    maxName in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.maxName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - avgStartTimestamp
```
public CaseQuery.AggregationQuery avgStartTimestamp()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column AvgStartTimestamp to the query, that contains the average of the field StartTimestamp of all (grouped) rows.
    
    SQL part: AVG(StartTimestamp) AS AvgStartTimestamp
    
    Specified by:
    
    avgStartTimestamp in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.avgStartTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minStartTimestamp
```
public CaseQuery.AggregationQuery minStartTimestamp()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MinStartTimestamp to the query, that contains the minimum value of the field StartTimestamp of all (grouped) rows.
    
    SQL part: MIN(StartTimestamp) AS MinStartTimestamp
    
    Specified by:
    
    minStartTimestamp in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.minStartTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxStartTimestamp
```
public CaseQuery.AggregationQuery maxStartTimestamp()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MaxStartTimestamp to the query, that contains the maximum value of the field StartTimestamp of all (grouped) rows.
    
    SQL part: MAX(StartTimestamp) AS MaxStartTimestamp
    
    Specified by:
    
    maxStartTimestamp in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.maxStartTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - avgEndTimestamp
```
public CaseQuery.AggregationQuery avgEndTimestamp()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column AvgEndTimestamp to the query, that contains the average of the field EndTimestamp of all (grouped) rows.
    
    SQL part: AVG(EndTimestamp) AS AvgEndTimestamp
    
    Specified by:
    
    avgEndTimestamp in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.avgEndTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minEndTimestamp
```
public CaseQuery.AggregationQuery minEndTimestamp()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MinEndTimestamp to the query, that contains the minimum value of the field EndTimestamp of all (grouped) rows.
    
    SQL part: MIN(EndTimestamp) AS MinEndTimestamp
    
    Specified by:
    
    minEndTimestamp in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.minEndTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxEndTimestamp
```
public CaseQuery.AggregationQuery maxEndTimestamp()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MaxEndTimestamp to the query, that contains the maximum value of the field EndTimestamp of all (grouped) rows.
    
    SQL part: MAX(EndTimestamp) AS MaxEndTimestamp
    
    Specified by:
    
    maxEndTimestamp in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.maxEndTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minBusinessCalendar
```
public CaseQuery.AggregationQuery minBusinessCalendar()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MinBusinessCalendar to the query, that contains the minimum value of the field BusinessCalendar of all (grouped) rows.
    
    SQL part: MIN(BusinessCalendar) AS MinBusinessCalendar
    
    Specified by:
    
    minBusinessCalendar in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.minBusinessCalendar()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxBusinessCalendar
```
public CaseQuery.AggregationQuery maxBusinessCalendar()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MaxBusinessCalendar to the query, that contains the maximum value of the field BusinessCalendar of all (grouped) rows.
    
    SQL part: MAX(BusinessCalendar) AS MaxBusinessCalendar
    
    Specified by:
    
    maxBusinessCalendar in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.maxBusinessCalendar()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - sumWorkingTime
```
public CaseQuery.AggregationQuery sumWorkingTime()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column SumWorkingTime to the query, that contains the sum of the field WorkingTime of all (grouped) rows.
    
    SQL part: SUM(WorkingTime) AS SumWorkingTime
    
    Specified by:
    
    sumWorkingTime in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.sumWorkingTime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - avgWorkingTime
```
public CaseQuery.AggregationQuery avgWorkingTime()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column AvgWorkingTime to the query, that contains the average of the field WorkingTime of all (grouped) rows.
    
    SQL part: AVG(WorkingTime) AS AvgWorkingTime
    
    Specified by:
    
    avgWorkingTime in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.avgWorkingTime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minWorkingTime
```
public CaseQuery.AggregationQuery minWorkingTime()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MinWorkingTime to the query, that contains the minimum value of the field WorkingTime of all (grouped) rows.
    
    SQL part: MIN(WorkingTime) AS MinWorkingTime
    
    Specified by:
    
    minWorkingTime in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.minWorkingTime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxWorkingTime
```
public CaseQuery.AggregationQuery maxWorkingTime()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MaxWorkingTime to the query, that contains the maximum value of the field WorkingTime of all (grouped) rows.
    
    SQL part: MAX(WorkingTime) AS MaxWorkingTime
    
    Specified by:
    
    maxWorkingTime in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.maxWorkingTime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - sumBusinessRuntime
```
public CaseQuery.AggregationQuery sumBusinessRuntime()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column SumBusinessRuntime to the query, that contains the sum of the field BusinessRuntime of all (grouped) rows.
    
    SQL part: SUM(BusinessRuntime) AS SumBusinessRuntime
    
    Specified by:
    
    sumBusinessRuntime in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.sumBusinessRuntime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - avgBusinessRuntime
```
public CaseQuery.AggregationQuery avgBusinessRuntime()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column AvgBusinessRuntime to the query, that contains the average of the field BusinessRuntime of all (grouped) rows.
    
    SQL part: AVG(BusinessRuntime) AS AvgBusinessRuntime
    
    Specified by:
    
    avgBusinessRuntime in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.avgBusinessRuntime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minBusinessRuntime
```
public CaseQuery.AggregationQuery minBusinessRuntime()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MinBusinessRuntime to the query, that contains the minimum value of the field BusinessRuntime of all (grouped) rows.
    
    SQL part: MIN(BusinessRuntime) AS MinBusinessRuntime
    
    Specified by:
    
    minBusinessRuntime in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.minBusinessRuntime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxBusinessRuntime
```
public CaseQuery.AggregationQuery maxBusinessRuntime()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MaxBusinessRuntime to the query, that contains the maximum value of the field BusinessRuntime of all (grouped) rows.
    
    SQL part: MAX(BusinessRuntime) AS MaxBusinessRuntime
    
    Specified by:
    
    maxBusinessRuntime in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.maxBusinessRuntime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minStage
```
public CaseQuery.AggregationQuery minStage()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MinStage to the query, that contains the minimum value of the field Stage of all (grouped) rows.
    
    SQL part: MIN(Stage) AS MinStage
    
    Specified by:
    
    minStage in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.minStage()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxStage
```
public CaseQuery.AggregationQuery maxStage()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MaxStage to the query, that contains the maximum value of the field Stage of all (grouped) rows.
    
    SQL part: MAX(Stage) AS MaxStage
    
    Specified by:
    
    maxStage in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.maxStage()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minOwnerName
```
public CaseQuery.AggregationQuery minOwnerName()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MinOwnerName to the query, that contains the minimum value of the field OwnerName of all (grouped) rows.
    
    SQL part: MIN(OwnerName) AS MinOwnerName
    
    This is a virtual column. It contains the same value as the column MemberName of the referenced Owner.
    
    Specified by:
    
    minOwnerName in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.minOwnerName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxOwnerName
```
public CaseQuery.AggregationQuery maxOwnerName()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MaxOwnerName to the query, that contains the maximum value of the field OwnerName of all (grouped) rows.
    
    SQL part: MAX(OwnerName) AS MaxOwnerName
    
    This is a virtual column. It contains the same value as the column MemberName of the referenced Owner.
    
    Specified by:
    
    maxOwnerName in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.maxOwnerName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minOwnerDisplayName
```
public CaseQuery.AggregationQuery minOwnerDisplayName()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MinOwnerDisplayName to the query, that contains the minimum value of the field OwnerDisplayName of all (grouped) rows.
    
    SQL part: MIN(OwnerDisplayName) AS MinOwnerDisplayName
    
    This is a virtual column. It contains the same value as the column DisplayName of the referenced Owner.
    
    Specified by:
    
    minOwnerDisplayName in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.minOwnerDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxOwnerDisplayName
```
public CaseQuery.AggregationQuery maxOwnerDisplayName()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MaxOwnerDisplayName to the query, that contains the maximum value of the field OwnerDisplayName of all (grouped) rows.
    
    SQL part: MAX(OwnerDisplayName) AS MaxOwnerDisplayName
    
    This is a virtual column. It contains the same value as the column DisplayName of the referenced Owner.
    
    Specified by:
    
    maxOwnerDisplayName in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.maxOwnerDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minCategory
```
public CaseQuery.AggregationQuery minCategory()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MinCategory to the query, that contains the minimum value of the field Category of all (grouped) rows.
    
    SQL part: MIN(Category) AS MinCategory
    
    Specified by:
    
    minCategory in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.minCategory()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxCategory
```
public CaseQuery.AggregationQuery maxCategory()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result column MaxCategory to the query, that contains the maximum value of the field Category of all (grouped) rows.
    
    SQL part: MAX(Category) AS MaxCategory
    
    Specified by:
    
    maxCategory in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    CaseQuery.IAggregationQuery.maxCategory()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - customField
```
public CaseQuery.ICustomFieldAggregationQuery customField()
```
    Description copied from interface: CaseQuery.IAggregationQuery
    
    Adds a result custom field to the query. Type and name are specified during further query composition.
    
    Specified by:
    
    customField in interface CaseQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.

Class CaseQuery.AggregationQuery

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

countRows

minCaseId

maxCaseId

minCreatorUserName

maxCreatorUserName

minCreatorUserDisplayName

maxCreatorUserDisplayName

minDisplayNameTemplate

maxDisplayNameTemplate

minName

maxName

avgStartTimestamp

minStartTimestamp

maxStartTimestamp

avgEndTimestamp

minEndTimestamp

maxEndTimestamp

minBusinessCalendar

maxBusinessCalendar

sumWorkingTime

avgWorkingTime

minWorkingTime

maxWorkingTime

sumBusinessRuntime

avgBusinessRuntime

minBusinessRuntime

maxBusinessRuntime

minStage

maxStage

minOwnerName

maxOwnerName

minOwnerDisplayName

maxOwnerDisplayName

minCategory

maxCategory

customField