java.lang.Object
- ch.ivyteam.ivy.persistence.query.Query<ITask>
- - ch.ivyteam.ivy.workflow.query.TaskQuery
  - - ch.ivyteam.ivy.workflow.query.TaskQuery.AggregationQuery

All Implemented Interfaces:: TaskQuery.IAggregationQuery

Enclosing class:: TaskQuery

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

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

Example:

TaskQuery.create().aggregate().sumWorkingTime().avgWorkingTime();

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

API:: This is a public API.

Nested Class Summary
- Nested classes/interfaces inherited from class ch.ivyteam.ivy.workflow.query.TaskQuery
  TaskQuery.AggregationQuery, TaskQuery.FilterLink, TaskQuery.FilterQuery, TaskQuery.GroupByQuery, TaskQuery.IAggregationQuery, TaskQuery.IBooleanColumnFilterQuery, TaskQuery.IClobColumnFilterQuery, TaskQuery.IColumnFilterQuery, TaskQuery.ICustomFieldAggregationQuery, TaskQuery.ICustomFieldFilterQuery, TaskQuery.ICustomFieldGroupBy, TaskQuery.ICustomFieldOrderBy, TaskQuery.IDateColumnFilterQuery, TaskQuery.IFilterableColumns, TaskQuery.IFilterLink, TaskQuery.IFilterQuery, TaskQuery.IGroupByQueryColumns, TaskQuery.IIntegerColumnFilterQuery, TaskQuery.INumberColumnFilterQuery, TaskQuery.IOrderByQueryColumns, TaskQuery.IPatternColumnFilterQuery, TaskQuery.IStringColumnFilterQuery, TaskQuery.ITaskStateFilterQuery, TaskQuery.IWorkflowPriorityFilterQuery, TaskQuery.OrderByColumnQuery, TaskQuery.OrderByQuery

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`TaskQuery.AggregationQuery`	`avgBusinessRuntime()`	Adds a result column `AvgBusinessRuntime` to the query, that contains the average of the field `BusinessRuntime` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`avgDelayTimestamp()`	Adds a result column `AvgDelayTimestamp` to the query, that contains the average of the field `DelayTimestamp` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`avgEndTimestamp()`	Adds a result column `AvgEndTimestamp` to the query, that contains the average of the field `EndTimestamp` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`avgExpiryTimestamp()`	Adds a result column `AvgExpiryTimestamp` to the query, that contains the average of the field `ExpiryTimestamp` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`avgFailedTimeoutTimestamp()`	Adds a result column `AvgFailedTimeoutTimestamp` to the query, that contains the average of the field `FailedTimeoutTimestamp` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`avgNumberOfFailures()`	Adds a result column `AvgNumberOfFailures` to the query, that contains the average of the field `NumberOfFailures` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`avgNumberOfResumes()`	Adds a result column `AvgNumberOfResumes` to the query, that contains the average of the field `NumberOfResumes` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`avgStartTimestamp()`	Adds a result column `AvgStartTimestamp` to the query, that contains the average of the field `StartTimestamp` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`avgWorkerSessionId()`	Adds a result column `AvgWorkerSessionId` to the query, that contains the average of the field `WorkerSessionId` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`avgWorkingTime()`	Adds a result column `AvgWorkingTime` to the query, that contains the average of the field `WorkingTime` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`countRows()`	Adds a result column `Count` to the query, that contains the number of (grouped) rows.
`TaskQuery.ICustomFieldAggregationQuery`	`customField()`	Adds a result custom field to the query.
`TaskQuery.AggregationQuery`	`maxActivatorDisplayName()`	Adds a result column `MaxActivatorDisplayName` to the query, that contains the maximum value of the field `ActivatorDisplayName` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxActivatorName()`	Adds a result column `MaxActivatorName` to the query, that contains the maximum value of the field `ActivatorName` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxBusinessCalendar()`	Adds a result column `MaxBusinessCalendar` to the query, that contains the maximum value of the field `BusinessCalendar` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxBusinessRuntime()`	Adds a result column `MaxBusinessRuntime` to the query, that contains the maximum value of the field `BusinessRuntime` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxCategory()`	Adds a result column `MaxCategory` to the query, that contains the maximum value of the field `Category` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxDelayTimestamp()`	Adds a result column `MaxDelayTimestamp` to the query, that contains the maximum value of the field `DelayTimestamp` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxDisplayNameTemplate()`	Adds a result column `MaxDisplayNameTemplate` to the query, that contains the maximum value of the field `DisplayNameTemplate` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxEndTimestamp()`	Adds a result column `MaxEndTimestamp` to the query, that contains the maximum value of the field `EndTimestamp` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxExpiryActivatorDisplayName()`	Adds a result column `MaxExpiryActivatorDisplayName` to the query, that contains the maximum value of the field `ExpiryActivatorDisplayName` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxExpiryActivatorName()`	Adds a result column `MaxExpiryActivatorName` to the query, that contains the maximum value of the field `ExpiryActivatorName` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxExpiryTaskStartElementPid()`	Adds a result column `MaxExpiryTaskStartElementPid` to the query, that contains the maximum value of the field `ExpiryTaskStartElementPid` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxExpiryTimestamp()`	Adds a result column `MaxExpiryTimestamp` to the query, that contains the maximum value of the field `ExpiryTimestamp` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxFailedTimeoutTimestamp()`	Adds a result column `MaxFailedTimeoutTimestamp` to the query, that contains the maximum value of the field `FailedTimeoutTimestamp` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxName()`	Adds a result column `MaxName` to the query, that contains the maximum value of the field `Name` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxNumberOfFailures()`	Adds a result column `MaxNumberOfFailures` to the query, that contains the maximum value of the field `NumberOfFailures` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxNumberOfResumes()`	Adds a result column `MaxNumberOfResumes` to the query, that contains the maximum value of the field `NumberOfResumes` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxOriginalActivatorDisplayName()`	Adds a result column `MaxOriginalActivatorDisplayName` to the query, that contains the maximum value of the field `OriginalActivatorDisplayName` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxOriginalActivatorName()`	Adds a result column `MaxOriginalActivatorName` to the query, that contains the maximum value of the field `OriginalActivatorName` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxRequestPath()`	Adds a result column `MaxRequestPath` to the query, that contains the maximum value of the field `RequestPath` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxStartTimestamp()`	Adds a result column `MaxStartTimestamp` to the query, that contains the maximum value of the field `StartTimestamp` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxTaskId()`	Adds a result column `MaxTaskId` to the query, that contains the maximum value of the field `TaskId` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxWorkerSessionId()`	Adds a result column `MaxWorkerSessionId` to the query, that contains the maximum value of the field `WorkerSessionId` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxWorkerUserDisplayName()`	Adds a result column `MaxWorkerUserDisplayName` to the query, that contains the maximum value of the field `WorkerUserDisplayName` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxWorkerUserName()`	Adds a result column `MaxWorkerUserName` to the query, that contains the maximum value of the field `WorkerUserName` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`maxWorkingTime()`	Adds a result column `MaxWorkingTime` to the query, that contains the maximum value of the field `WorkingTime` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minActivatorDisplayName()`	Adds a result column `MinActivatorDisplayName` to the query, that contains the minimum value of the field `ActivatorDisplayName` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minActivatorName()`	Adds a result column `MinActivatorName` to the query, that contains the minimum value of the field `ActivatorName` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minBusinessCalendar()`	Adds a result column `MinBusinessCalendar` to the query, that contains the minimum value of the field `BusinessCalendar` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minBusinessRuntime()`	Adds a result column `MinBusinessRuntime` to the query, that contains the minimum value of the field `BusinessRuntime` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minCategory()`	Adds a result column `MinCategory` to the query, that contains the minimum value of the field `Category` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minDelayTimestamp()`	Adds a result column `MinDelayTimestamp` to the query, that contains the minimum value of the field `DelayTimestamp` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minDisplayNameTemplate()`	Adds a result column `MinDisplayNameTemplate` to the query, that contains the minimum value of the field `DisplayNameTemplate` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minEndTimestamp()`	Adds a result column `MinEndTimestamp` to the query, that contains the minimum value of the field `EndTimestamp` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minExpiryActivatorDisplayName()`	Adds a result column `MinExpiryActivatorDisplayName` to the query, that contains the minimum value of the field `ExpiryActivatorDisplayName` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minExpiryActivatorName()`	Adds a result column `MinExpiryActivatorName` to the query, that contains the minimum value of the field `ExpiryActivatorName` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minExpiryTaskStartElementPid()`	Adds a result column `MinExpiryTaskStartElementPid` to the query, that contains the minimum value of the field `ExpiryTaskStartElementPid` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minExpiryTimestamp()`	Adds a result column `MinExpiryTimestamp` to the query, that contains the minimum value of the field `ExpiryTimestamp` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minFailedTimeoutTimestamp()`	Adds a result column `MinFailedTimeoutTimestamp` to the query, that contains the minimum value of the field `FailedTimeoutTimestamp` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minName()`	Adds a result column `MinName` to the query, that contains the minimum value of the field `Name` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minNumberOfFailures()`	Adds a result column `MinNumberOfFailures` to the query, that contains the minimum value of the field `NumberOfFailures` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minNumberOfResumes()`	Adds a result column `MinNumberOfResumes` to the query, that contains the minimum value of the field `NumberOfResumes` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minOriginalActivatorDisplayName()`	Adds a result column `MinOriginalActivatorDisplayName` to the query, that contains the minimum value of the field `OriginalActivatorDisplayName` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minOriginalActivatorName()`	Adds a result column `MinOriginalActivatorName` to the query, that contains the minimum value of the field `OriginalActivatorName` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minRequestPath()`	Adds a result column `MinRequestPath` to the query, that contains the minimum value of the field `RequestPath` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minStartTimestamp()`	Adds a result column `MinStartTimestamp` to the query, that contains the minimum value of the field `StartTimestamp` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minTaskId()`	Adds a result column `MinTaskId` to the query, that contains the minimum value of the field `TaskId` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minWorkerSessionId()`	Adds a result column `MinWorkerSessionId` to the query, that contains the minimum value of the field `WorkerSessionId` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minWorkerUserDisplayName()`	Adds a result column `MinWorkerUserDisplayName` to the query, that contains the minimum value of the field `WorkerUserDisplayName` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minWorkerUserName()`	Adds a result column `MinWorkerUserName` to the query, that contains the minimum value of the field `WorkerUserName` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`minWorkingTime()`	Adds a result column `MinWorkingTime` to the query, that contains the minimum value of the field `WorkingTime` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`sumBusinessRuntime()`	Adds a result column `SumBusinessRuntime` to the query, that contains the sum of the field `BusinessRuntime` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`sumNumberOfFailures()`	Adds a result column `SumNumberOfFailures` to the query, that contains the sum of the field `NumberOfFailures` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`sumNumberOfResumes()`	Adds a result column `SumNumberOfResumes` to the query, that contains the sum of the field `NumberOfResumes` of all (grouped) rows.
`TaskQuery.AggregationQuery`	`sumWorkerSessionId()`	Adds a result column `SumWorkerSessionId` to the query, that contains the sum of the field `WorkerSessionId` of all (grouped) rows.
`TaskQuery.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.TaskQuery
aggregate, create, executor, groupBy, orderBy, where

- Method Detail
  - countRows
```
public TaskQuery.AggregationQuery countRows()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.countRows()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minTaskId
```
public TaskQuery.AggregationQuery minTaskId()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinTaskId to the query, that contains the minimum value of the field TaskId of all (grouped) rows.
    
    SQL part: MIN(TaskId) AS MinTaskId
    
    Specified by:
    
    minTaskId in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minTaskId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxTaskId
```
public TaskQuery.AggregationQuery maxTaskId()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxTaskId to the query, that contains the maximum value of the field TaskId of all (grouped) rows.
    
    SQL part: MAX(TaskId) AS MaxTaskId
    
    Specified by:
    
    maxTaskId in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxTaskId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minWorkerUserName
```
public TaskQuery.AggregationQuery minWorkerUserName()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinWorkerUserName to the query, that contains the minimum value of the field WorkerUserName of all (grouped) rows.
    
    SQL part: MIN(WorkerUserName) AS MinWorkerUserName
    
    Specified by:
    
    minWorkerUserName in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minWorkerUserName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxWorkerUserName
```
public TaskQuery.AggregationQuery maxWorkerUserName()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxWorkerUserName to the query, that contains the maximum value of the field WorkerUserName of all (grouped) rows.
    
    SQL part: MAX(WorkerUserName) AS MaxWorkerUserName
    
    Specified by:
    
    maxWorkerUserName in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxWorkerUserName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minWorkerUserDisplayName
```
public TaskQuery.AggregationQuery minWorkerUserDisplayName()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinWorkerUserDisplayName to the query, that contains the minimum value of the field WorkerUserDisplayName of all (grouped) rows.
    
    SQL part: MIN(WorkerUserDisplayName) AS MinWorkerUserDisplayName
    
    Specified by:
    
    minWorkerUserDisplayName in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minWorkerUserDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxWorkerUserDisplayName
```
public TaskQuery.AggregationQuery maxWorkerUserDisplayName()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxWorkerUserDisplayName to the query, that contains the maximum value of the field WorkerUserDisplayName of all (grouped) rows.
    
    SQL part: MAX(WorkerUserDisplayName) AS MaxWorkerUserDisplayName
    
    Specified by:
    
    maxWorkerUserDisplayName in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxWorkerUserDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - sumWorkerSessionId
```
public TaskQuery.AggregationQuery sumWorkerSessionId()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column SumWorkerSessionId to the query, that contains the sum of the field WorkerSessionId of all (grouped) rows.
    
    SQL part: SUM(WorkerSessionId) AS SumWorkerSessionId
    
    Specified by:
    
    sumWorkerSessionId in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.sumWorkerSessionId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - avgWorkerSessionId
```
public TaskQuery.AggregationQuery avgWorkerSessionId()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column AvgWorkerSessionId to the query, that contains the average of the field WorkerSessionId of all (grouped) rows.
    
    SQL part: AVG(WorkerSessionId) AS AvgWorkerSessionId
    
    Specified by:
    
    avgWorkerSessionId in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.avgWorkerSessionId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minWorkerSessionId
```
public TaskQuery.AggregationQuery minWorkerSessionId()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinWorkerSessionId to the query, that contains the minimum value of the field WorkerSessionId of all (grouped) rows.
    
    SQL part: MIN(WorkerSessionId) AS MinWorkerSessionId
    
    Specified by:
    
    minWorkerSessionId in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minWorkerSessionId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxWorkerSessionId
```
public TaskQuery.AggregationQuery maxWorkerSessionId()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxWorkerSessionId to the query, that contains the maximum value of the field WorkerSessionId of all (grouped) rows.
    
    SQL part: MAX(WorkerSessionId) AS MaxWorkerSessionId
    
    Specified by:
    
    maxWorkerSessionId in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxWorkerSessionId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minOriginalActivatorName
```
public TaskQuery.AggregationQuery minOriginalActivatorName()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinOriginalActivatorName to the query, that contains the minimum value of the field OriginalActivatorName of all (grouped) rows.
    
    SQL part: MIN(OriginalActivatorName) AS MinOriginalActivatorName
    
    Specified by:
    
    minOriginalActivatorName in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minOriginalActivatorName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxOriginalActivatorName
```
public TaskQuery.AggregationQuery maxOriginalActivatorName()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxOriginalActivatorName to the query, that contains the maximum value of the field OriginalActivatorName of all (grouped) rows.
    
    SQL part: MAX(OriginalActivatorName) AS MaxOriginalActivatorName
    
    Specified by:
    
    maxOriginalActivatorName in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxOriginalActivatorName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minOriginalActivatorDisplayName
```
public TaskQuery.AggregationQuery minOriginalActivatorDisplayName()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinOriginalActivatorDisplayName to the query, that contains the minimum value of the field OriginalActivatorDisplayName of all (grouped) rows.
    
    SQL part: MIN(OriginalActivatorDisplayName) AS MinOriginalActivatorDisplayName
    
    Specified by:
    
    minOriginalActivatorDisplayName in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minOriginalActivatorDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxOriginalActivatorDisplayName
```
public TaskQuery.AggregationQuery maxOriginalActivatorDisplayName()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxOriginalActivatorDisplayName to the query, that contains the maximum value of the field OriginalActivatorDisplayName of all (grouped) rows.
    
    SQL part: MAX(OriginalActivatorDisplayName) AS MaxOriginalActivatorDisplayName
    
    Specified by:
    
    maxOriginalActivatorDisplayName in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxOriginalActivatorDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minExpiryActivatorName
```
public TaskQuery.AggregationQuery minExpiryActivatorName()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinExpiryActivatorName to the query, that contains the minimum value of the field ExpiryActivatorName of all (grouped) rows.
    
    SQL part: MIN(ExpiryActivatorName) AS MinExpiryActivatorName
    
    Specified by:
    
    minExpiryActivatorName in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minExpiryActivatorName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxExpiryActivatorName
```
public TaskQuery.AggregationQuery maxExpiryActivatorName()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxExpiryActivatorName to the query, that contains the maximum value of the field ExpiryActivatorName of all (grouped) rows.
    
    SQL part: MAX(ExpiryActivatorName) AS MaxExpiryActivatorName
    
    Specified by:
    
    maxExpiryActivatorName in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxExpiryActivatorName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minExpiryActivatorDisplayName
```
public TaskQuery.AggregationQuery minExpiryActivatorDisplayName()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinExpiryActivatorDisplayName to the query, that contains the minimum value of the field ExpiryActivatorDisplayName of all (grouped) rows.
    
    SQL part: MIN(ExpiryActivatorDisplayName) AS MinExpiryActivatorDisplayName
    
    Specified by:
    
    minExpiryActivatorDisplayName in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minExpiryActivatorDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxExpiryActivatorDisplayName
```
public TaskQuery.AggregationQuery maxExpiryActivatorDisplayName()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxExpiryActivatorDisplayName to the query, that contains the maximum value of the field ExpiryActivatorDisplayName of all (grouped) rows.
    
    SQL part: MAX(ExpiryActivatorDisplayName) AS MaxExpiryActivatorDisplayName
    
    Specified by:
    
    maxExpiryActivatorDisplayName in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxExpiryActivatorDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - avgExpiryTimestamp
```
public TaskQuery.AggregationQuery avgExpiryTimestamp()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column AvgExpiryTimestamp to the query, that contains the average of the field ExpiryTimestamp of all (grouped) rows.
    
    SQL part: AVG(ExpiryTimestamp) AS AvgExpiryTimestamp
    
    Specified by:
    
    avgExpiryTimestamp in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.avgExpiryTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minExpiryTimestamp
```
public TaskQuery.AggregationQuery minExpiryTimestamp()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinExpiryTimestamp to the query, that contains the minimum value of the field ExpiryTimestamp of all (grouped) rows.
    
    SQL part: MIN(ExpiryTimestamp) AS MinExpiryTimestamp
    
    Specified by:
    
    minExpiryTimestamp in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minExpiryTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxExpiryTimestamp
```
public TaskQuery.AggregationQuery maxExpiryTimestamp()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxExpiryTimestamp to the query, that contains the maximum value of the field ExpiryTimestamp of all (grouped) rows.
    
    SQL part: MAX(ExpiryTimestamp) AS MaxExpiryTimestamp
    
    Specified by:
    
    maxExpiryTimestamp in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxExpiryTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minExpiryTaskStartElementPid
```
public TaskQuery.AggregationQuery minExpiryTaskStartElementPid()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinExpiryTaskStartElementPid to the query, that contains the minimum value of the field ExpiryTaskStartElementPid of all (grouped) rows.
    
    SQL part: MIN(ExpiryTaskStartElementPid) AS MinExpiryTaskStartElementPid
    
    Specified by:
    
    minExpiryTaskStartElementPid in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minExpiryTaskStartElementPid()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxExpiryTaskStartElementPid
```
public TaskQuery.AggregationQuery maxExpiryTaskStartElementPid()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxExpiryTaskStartElementPid to the query, that contains the maximum value of the field ExpiryTaskStartElementPid of all (grouped) rows.
    
    SQL part: MAX(ExpiryTaskStartElementPid) AS MaxExpiryTaskStartElementPid
    
    Specified by:
    
    maxExpiryTaskStartElementPid in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxExpiryTaskStartElementPid()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - avgDelayTimestamp
```
public TaskQuery.AggregationQuery avgDelayTimestamp()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column AvgDelayTimestamp to the query, that contains the average of the field DelayTimestamp of all (grouped) rows.
    
    SQL part: AVG(DelayTimestamp) AS AvgDelayTimestamp
    
    Specified by:
    
    avgDelayTimestamp in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.avgDelayTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minDelayTimestamp
```
public TaskQuery.AggregationQuery minDelayTimestamp()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinDelayTimestamp to the query, that contains the minimum value of the field DelayTimestamp of all (grouped) rows.
    
    SQL part: MIN(DelayTimestamp) AS MinDelayTimestamp
    
    Specified by:
    
    minDelayTimestamp in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minDelayTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxDelayTimestamp
```
public TaskQuery.AggregationQuery maxDelayTimestamp()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxDelayTimestamp to the query, that contains the maximum value of the field DelayTimestamp of all (grouped) rows.
    
    SQL part: MAX(DelayTimestamp) AS MaxDelayTimestamp
    
    Specified by:
    
    maxDelayTimestamp in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxDelayTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minRequestPath
```
public TaskQuery.AggregationQuery minRequestPath()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinRequestPath to the query, that contains the minimum value of the field RequestPath of all (grouped) rows.
    
    SQL part: MIN(RequestPath) AS MinRequestPath
    
    Specified by:
    
    minRequestPath in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minRequestPath()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxRequestPath
```
public TaskQuery.AggregationQuery maxRequestPath()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxRequestPath to the query, that contains the maximum value of the field RequestPath of all (grouped) rows.
    
    SQL part: MAX(RequestPath) AS MaxRequestPath
    
    Specified by:
    
    maxRequestPath in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxRequestPath()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minDisplayNameTemplate
```
public TaskQuery.AggregationQuery minDisplayNameTemplate()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minDisplayNameTemplate()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxDisplayNameTemplate
```
public TaskQuery.AggregationQuery maxDisplayNameTemplate()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxDisplayNameTemplate()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minName
```
public TaskQuery.AggregationQuery minName()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxName
```
public TaskQuery.AggregationQuery maxName()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - avgStartTimestamp
```
public TaskQuery.AggregationQuery avgStartTimestamp()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.avgStartTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minStartTimestamp
```
public TaskQuery.AggregationQuery minStartTimestamp()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minStartTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxStartTimestamp
```
public TaskQuery.AggregationQuery maxStartTimestamp()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxStartTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - avgEndTimestamp
```
public TaskQuery.AggregationQuery avgEndTimestamp()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.avgEndTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minEndTimestamp
```
public TaskQuery.AggregationQuery minEndTimestamp()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minEndTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxEndTimestamp
```
public TaskQuery.AggregationQuery maxEndTimestamp()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxEndTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minBusinessCalendar
```
public TaskQuery.AggregationQuery minBusinessCalendar()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minBusinessCalendar()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxBusinessCalendar
```
public TaskQuery.AggregationQuery maxBusinessCalendar()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxBusinessCalendar()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - sumWorkingTime
```
public TaskQuery.AggregationQuery sumWorkingTime()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.sumWorkingTime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - avgWorkingTime
```
public TaskQuery.AggregationQuery avgWorkingTime()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.avgWorkingTime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minWorkingTime
```
public TaskQuery.AggregationQuery minWorkingTime()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minWorkingTime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxWorkingTime
```
public TaskQuery.AggregationQuery maxWorkingTime()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxWorkingTime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - sumBusinessRuntime
```
public TaskQuery.AggregationQuery sumBusinessRuntime()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.sumBusinessRuntime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - avgBusinessRuntime
```
public TaskQuery.AggregationQuery avgBusinessRuntime()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.avgBusinessRuntime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minBusinessRuntime
```
public TaskQuery.AggregationQuery minBusinessRuntime()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minBusinessRuntime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxBusinessRuntime
```
public TaskQuery.AggregationQuery maxBusinessRuntime()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxBusinessRuntime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - avgFailedTimeoutTimestamp
```
public TaskQuery.AggregationQuery avgFailedTimeoutTimestamp()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column AvgFailedTimeoutTimestamp to the query, that contains the average of the field FailedTimeoutTimestamp of all (grouped) rows.
    
    SQL part: AVG(FailedTimeoutTimestamp) AS AvgFailedTimeoutTimestamp
    
    Specified by:
    
    avgFailedTimeoutTimestamp in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.avgFailedTimeoutTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minFailedTimeoutTimestamp
```
public TaskQuery.AggregationQuery minFailedTimeoutTimestamp()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinFailedTimeoutTimestamp to the query, that contains the minimum value of the field FailedTimeoutTimestamp of all (grouped) rows.
    
    SQL part: MIN(FailedTimeoutTimestamp) AS MinFailedTimeoutTimestamp
    
    Specified by:
    
    minFailedTimeoutTimestamp in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minFailedTimeoutTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxFailedTimeoutTimestamp
```
public TaskQuery.AggregationQuery maxFailedTimeoutTimestamp()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxFailedTimeoutTimestamp to the query, that contains the maximum value of the field FailedTimeoutTimestamp of all (grouped) rows.
    
    SQL part: MAX(FailedTimeoutTimestamp) AS MaxFailedTimeoutTimestamp
    
    Specified by:
    
    maxFailedTimeoutTimestamp in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxFailedTimeoutTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - sumNumberOfFailures
```
public TaskQuery.AggregationQuery sumNumberOfFailures()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column SumNumberOfFailures to the query, that contains the sum of the field NumberOfFailures of all (grouped) rows.
    
    SQL part: SUM(NumberOfFailures) AS SumNumberOfFailures
    
    Specified by:
    
    sumNumberOfFailures in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.sumNumberOfFailures()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - avgNumberOfFailures
```
public TaskQuery.AggregationQuery avgNumberOfFailures()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column AvgNumberOfFailures to the query, that contains the average of the field NumberOfFailures of all (grouped) rows.
    
    SQL part: AVG(NumberOfFailures) AS AvgNumberOfFailures
    
    Specified by:
    
    avgNumberOfFailures in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.avgNumberOfFailures()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minNumberOfFailures
```
public TaskQuery.AggregationQuery minNumberOfFailures()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinNumberOfFailures to the query, that contains the minimum value of the field NumberOfFailures of all (grouped) rows.
    
    SQL part: MIN(NumberOfFailures) AS MinNumberOfFailures
    
    Specified by:
    
    minNumberOfFailures in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minNumberOfFailures()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxNumberOfFailures
```
public TaskQuery.AggregationQuery maxNumberOfFailures()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxNumberOfFailures to the query, that contains the maximum value of the field NumberOfFailures of all (grouped) rows.
    
    SQL part: MAX(NumberOfFailures) AS MaxNumberOfFailures
    
    Specified by:
    
    maxNumberOfFailures in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxNumberOfFailures()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - sumNumberOfResumes
```
public TaskQuery.AggregationQuery sumNumberOfResumes()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column SumNumberOfResumes to the query, that contains the sum of the field NumberOfResumes of all (grouped) rows.
    
    SQL part: SUM(NumberOfResumes) AS SumNumberOfResumes
    
    Specified by:
    
    sumNumberOfResumes in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.sumNumberOfResumes()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - avgNumberOfResumes
```
public TaskQuery.AggregationQuery avgNumberOfResumes()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column AvgNumberOfResumes to the query, that contains the average of the field NumberOfResumes of all (grouped) rows.
    
    SQL part: AVG(NumberOfResumes) AS AvgNumberOfResumes
    
    Specified by:
    
    avgNumberOfResumes in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.avgNumberOfResumes()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minNumberOfResumes
```
public TaskQuery.AggregationQuery minNumberOfResumes()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinNumberOfResumes to the query, that contains the minimum value of the field NumberOfResumes of all (grouped) rows.
    
    SQL part: MIN(NumberOfResumes) AS MinNumberOfResumes
    
    Specified by:
    
    minNumberOfResumes in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minNumberOfResumes()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxNumberOfResumes
```
public TaskQuery.AggregationQuery maxNumberOfResumes()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxNumberOfResumes to the query, that contains the maximum value of the field NumberOfResumes of all (grouped) rows.
    
    SQL part: MAX(NumberOfResumes) AS MaxNumberOfResumes
    
    Specified by:
    
    maxNumberOfResumes in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxNumberOfResumes()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minCategory
```
public TaskQuery.AggregationQuery minCategory()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minCategory()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxCategory
```
public TaskQuery.AggregationQuery maxCategory()
```
    Description copied from interface: TaskQuery.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 TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxCategory()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minActivatorName
```
public TaskQuery.AggregationQuery minActivatorName()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinActivatorName to the query, that contains the minimum value of the field ActivatorName of all (grouped) rows.
    
    SQL part: MIN(ActivatorName) AS MinActivatorName
    
    Specified by:
    
    minActivatorName in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minActivatorName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxActivatorName
```
public TaskQuery.AggregationQuery maxActivatorName()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxActivatorName to the query, that contains the maximum value of the field ActivatorName of all (grouped) rows.
    
    SQL part: MAX(ActivatorName) AS MaxActivatorName
    
    Specified by:
    
    maxActivatorName in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxActivatorName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - minActivatorDisplayName
```
public TaskQuery.AggregationQuery minActivatorDisplayName()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MinActivatorDisplayName to the query, that contains the minimum value of the field ActivatorDisplayName of all (grouped) rows.
    
    SQL part: MIN(ActivatorDisplayName) AS MinActivatorDisplayName
    
    Specified by:
    
    minActivatorDisplayName in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.minActivatorDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - maxActivatorDisplayName
```
public TaskQuery.AggregationQuery maxActivatorDisplayName()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result column MaxActivatorDisplayName to the query, that contains the maximum value of the field ActivatorDisplayName of all (grouped) rows.
    
    SQL part: MAX(ActivatorDisplayName) AS MaxActivatorDisplayName
    
    Specified by:
    
    maxActivatorDisplayName in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IAggregationQuery.maxActivatorDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - customField
```
public TaskQuery.ICustomFieldAggregationQuery customField()
```
    Description copied from interface: TaskQuery.IAggregationQuery
    
    Adds a result custom field to the query. Type and name are specified during further query composition.
    
    Specified by:
    
    customField in interface TaskQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.

Class TaskQuery.AggregationQuery

Nested Class Summary

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

Method Summary

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

Method Detail

countRows

minTaskId

maxTaskId

minWorkerUserName

maxWorkerUserName

minWorkerUserDisplayName

maxWorkerUserDisplayName

sumWorkerSessionId

avgWorkerSessionId

minWorkerSessionId

maxWorkerSessionId

minOriginalActivatorName

maxOriginalActivatorName

minOriginalActivatorDisplayName

maxOriginalActivatorDisplayName

minExpiryActivatorName

maxExpiryActivatorName

minExpiryActivatorDisplayName

maxExpiryActivatorDisplayName

avgExpiryTimestamp

minExpiryTimestamp

maxExpiryTimestamp

minExpiryTaskStartElementPid

maxExpiryTaskStartElementPid

avgDelayTimestamp

minDelayTimestamp

maxDelayTimestamp

minRequestPath

maxRequestPath

minDisplayNameTemplate

maxDisplayNameTemplate

minName

maxName

avgStartTimestamp

minStartTimestamp

maxStartTimestamp

avgEndTimestamp

minEndTimestamp

maxEndTimestamp

minBusinessCalendar

maxBusinessCalendar

sumWorkingTime

avgWorkingTime

minWorkingTime

maxWorkingTime

sumBusinessRuntime

avgBusinessRuntime

minBusinessRuntime

maxBusinessRuntime

avgFailedTimeoutTimestamp

minFailedTimeoutTimestamp

maxFailedTimeoutTimestamp

sumNumberOfFailures

avgNumberOfFailures

minNumberOfFailures

maxNumberOfFailures

sumNumberOfResumes

avgNumberOfResumes

minNumberOfResumes

maxNumberOfResumes

minCategory

maxCategory

minActivatorName

maxActivatorName

minActivatorDisplayName

maxActivatorDisplayName

customField