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

All Implemented Interfaces:: TaskQuery.IGroupByQueryColumns

Enclosing class:: TaskQuery

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

Provides methods to group the result by certain fields.

Example:

TaskQuery.create().groupBy().activatorUserId().priority().aggregate().countRows();

Corresponds to SQL: SELECT ActivatorUserId, Priority, Count(*) AS Count FROM IWA_Task GROUP BY ActivatorUserId, Priority

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.IBoolFilterQuery, 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.GroupByQuery`	`activatorDisplayName()`	Groups the result of the query by the field `ActivatorDisplayName`.
`TaskQuery.GroupByQuery`	`activatorId()`	Groups the result of the query by the field `ActivatorId`.
`TaskQuery.GroupByQuery`	`activatorName()`	Groups the result of the query by the field `ActivatorName`.
`TaskQuery.GroupByQuery`	`applicationId()`	Groups the result of the query by the field `ApplicationId`.
`TaskQuery.GroupByQuery`	`businessCalendar()`	Groups the result of the query by the field `BusinessCalendar`.
`TaskQuery.GroupByQuery`	`businessCaseId()`	Groups the result of the query by the field `BusinessCaseId`.
`TaskQuery.GroupByQuery`	`businessRuntime()`	Groups the result of the query by the field `BusinessRuntime`.
`TaskQuery.GroupByQuery`	`caseId()`	Groups the result of the query by the field `CaseId`.
`TaskQuery.GroupByQuery`	`category()`	Groups the result of the query by the field `Category`.
`TaskQuery.ICustomFieldGroupBy`	`customField()`	Groups the result of the query by a custom field specified during further composition.
`TaskQuery.GroupByQuery`	`delayTimestamp()`	Groups the result of the query by the field `DelayTimestamp`.
`TaskQuery.GroupByQuery`	`description()`	Groups the result of the query by the field `Description`.
`TaskQuery.GroupByQuery`	`displayDescriptionTemplate()`	Groups the result of the query by the field `DisplayDescriptionTemplate`.
`TaskQuery.GroupByQuery`	`displayNameTemplate()`	Groups the result of the query by the field `DisplayNameTemplate`.
`TaskQuery.GroupByQuery`	`endTaskSwitchEventId()`	Groups the result of the query by the field `EndTaskSwitchEventId`.
`TaskQuery.GroupByQuery`	`endTimestamp()`	Groups the result of the query by the field `EndTimestamp`.
`TaskQuery.GroupByQuery`	`expiredCreatorTaskId()`	Groups the result of the query by the field `ExpiredCreatorTaskId`.
`TaskQuery.GroupByQuery`	`expiryActivatorDisplayName()`	Groups the result of the query by the field `ExpiryActivatorDisplayName`.
`TaskQuery.GroupByQuery`	`expiryActivatorId()`	Groups the result of the query by the field `ExpiryActivatorId`.
`TaskQuery.GroupByQuery`	`expiryActivatorName()`	Groups the result of the query by the field `ExpiryActivatorName`.
`TaskQuery.GroupByQuery`	`expiryPriority()`	Groups the result of the query by the field `ExpiryPriority`.
`TaskQuery.GroupByQuery`	`expiryTaskStartElementPid()`	Groups the result of the query by the field `ExpiryTaskStartElementPid`.
`TaskQuery.GroupByQuery`	`expiryTimestamp()`	Groups the result of the query by the field `ExpiryTimestamp`.
`TaskQuery.GroupByQuery`	`failedTimeoutTimestamp()`	Groups the result of the query by the field `FailedTimeoutTimestamp`.
`TaskQuery.GroupByQuery`	`isExpired()`	Groups the result of the query by the field `IsExpired`.
`TaskQuery.GroupByQuery`	`isOffline()`	Groups the result of the query by the field `IsOffline`.
`TaskQuery.GroupByQuery`	`isUpdatedOnStart()`	Groups the result of the query by the field `IsUpdatedOnStart`.
`TaskQuery.GroupByQuery`	`name()`	Groups the result of the query by the field `Name`.
`TaskQuery.GroupByQuery`	`numberOfFailures()`	Groups the result of the query by the field `NumberOfFailures`.
`TaskQuery.GroupByQuery`	`numberOfResumes()`	Groups the result of the query by the field `NumberOfResumes`.
`TaskQuery.GroupByQuery`	`originalActivatorDisplayName()`	Groups the result of the query by the field `OriginalActivatorDisplayName`.
`TaskQuery.GroupByQuery`	`originalActivatorId()`	Groups the result of the query by the field `OriginalActivatorId`.
`TaskQuery.GroupByQuery`	`originalActivatorName()`	Groups the result of the query by the field `OriginalActivatorName`.
`TaskQuery.GroupByQuery`	`originalPriority()`	Groups the result of the query by the field `OriginalPriority`.
`TaskQuery.GroupByQuery`	`priority()`	Groups the result of the query by the field `Priority`.
`TaskQuery.GroupByQuery`	`processModelId()`	Groups the result of the query by the field `ProcessModelId`.
`TaskQuery.GroupByQuery`	`requestPath()`	Groups the result of the query by the field `RequestPath`.
`TaskQuery.GroupByQuery`	`startTaskSwitchEventId()`	Groups the result of the query by the field `StartTaskSwitchEventId`.
`TaskQuery.GroupByQuery`	`startTimestamp()`	Groups the result of the query by the field `StartTimestamp`.
`TaskQuery.GroupByQuery`	`state()`	Groups the result of the query by the field `State`.
`TaskQuery.GroupByQuery`	`taskEndId()`	Groups the result of the query by the field `TaskEndId`.
`TaskQuery.GroupByQuery`	`taskId()`	Groups the result of the query by the field `TaskId`.
`TaskQuery.GroupByQuery`	`taskStartId()`	Groups the result of the query by the field `TaskStartId`.
`TaskQuery.GroupByQuery`	`timeoutedCreatorIntrmdtEventId()`	Groups the result of the query by the field `TimeoutedCreatorIntrmdtEventId`.
`TaskQuery.GroupByQuery`	`workerId()`	Groups the result of the query by the field `WorkerId`.
`TaskQuery.GroupByQuery`	`workerSessionId()`	Groups the result of the query by the field `WorkerSessionId`.
`TaskQuery.GroupByQuery`	`workerUserDisplayName()`	Groups the result of the query by the field `WorkerUserDisplayName`.
`TaskQuery.GroupByQuery`	`workerUserName()`	Groups the result of the query by the field `WorkerUserName`.
`TaskQuery.GroupByQuery`	`workingTime()`	Groups the result of the query by the field `WorkingTime`.

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

- Method Detail
  - taskId
```
public TaskQuery.GroupByQuery taskId()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field TaskId.
    
    SQL part: GROUP BY TaskId
    
    Specified by:
    
    taskId in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.taskId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - caseId
```
public TaskQuery.GroupByQuery caseId()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field CaseId.
    
    SQL part: GROUP BY CaseId
    
    Specified by:
    
    caseId in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.caseId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - businessCaseId
```
public TaskQuery.GroupByQuery businessCaseId()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field BusinessCaseId.
    
    SQL part: GROUP BY BusinessCaseId
    
    Specified by:
    
    businessCaseId in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.businessCaseId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - processModelId
```
public TaskQuery.GroupByQuery processModelId()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field ProcessModelId.
    
    SQL part: GROUP BY ProcessModelId
    
    Specified by:
    
    processModelId in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.processModelId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - applicationId
```
public TaskQuery.GroupByQuery applicationId()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field ApplicationId.
    
    SQL part: GROUP BY ApplicationId
    
    Specified by:
    
    applicationId in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.applicationId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - startTaskSwitchEventId
```
public TaskQuery.GroupByQuery startTaskSwitchEventId()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field StartTaskSwitchEventId.
    
    SQL part: GROUP BY StartTaskSwitchEventId
    
    Specified by:
    
    startTaskSwitchEventId in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.startTaskSwitchEventId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - endTaskSwitchEventId
```
public TaskQuery.GroupByQuery endTaskSwitchEventId()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field EndTaskSwitchEventId.
    
    SQL part: GROUP BY EndTaskSwitchEventId
    
    Specified by:
    
    endTaskSwitchEventId in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.endTaskSwitchEventId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - taskStartId
```
public TaskQuery.GroupByQuery taskStartId()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field TaskStartId.
    
    SQL part: GROUP BY TaskStartId
    
    Specified by:
    
    taskStartId in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.taskStartId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - taskEndId
```
public TaskQuery.GroupByQuery taskEndId()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field TaskEndId.
    
    SQL part: GROUP BY TaskEndId
    
    Specified by:
    
    taskEndId in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.taskEndId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - workerId
```
public TaskQuery.GroupByQuery workerId()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field WorkerId.
    
    SQL part: GROUP BY WorkerId
    
    Specified by:
    
    workerId in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.workerId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - workerUserName
```
public TaskQuery.GroupByQuery workerUserName()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field WorkerUserName.
    
    SQL part: GROUP BY WorkerUserName
    
    This is a virtual column. It contains the same value as the column Name of the referenced Worker.
    
    Specified by:
    
    workerUserName in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.workerUserName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - workerUserDisplayName
```
public TaskQuery.GroupByQuery workerUserDisplayName()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field WorkerUserDisplayName.
    
    SQL part: GROUP BY WorkerUserDisplayName
    
    This is a virtual column. It contains the same value as the column DisplayName of the referenced Worker.
    
    Specified by:
    
    workerUserDisplayName in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.workerUserDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - workerSessionId
```
public TaskQuery.GroupByQuery workerSessionId()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field WorkerSessionId.
    
    SQL part: GROUP BY WorkerSessionId
    
    Specified by:
    
    workerSessionId in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.workerSessionId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - activatorId
```
public TaskQuery.GroupByQuery activatorId()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field ActivatorId.
    
    SQL part: GROUP BY ActivatorId
    
    Specified by:
    
    activatorId in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.activatorId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - originalActivatorId
```
public TaskQuery.GroupByQuery originalActivatorId()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field OriginalActivatorId.
    
    SQL part: GROUP BY OriginalActivatorId
    
    Specified by:
    
    originalActivatorId in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.originalActivatorId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - originalActivatorName
```
public TaskQuery.GroupByQuery originalActivatorName()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field OriginalActivatorName.
    
    SQL part: GROUP BY OriginalActivatorName
    
    This is a virtual column. It contains the same value as the column MemberName of the referenced OriginalActivator.
    
    Specified by:
    
    originalActivatorName in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.originalActivatorName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - originalActivatorDisplayName
```
public TaskQuery.GroupByQuery originalActivatorDisplayName()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field OriginalActivatorDisplayName.
    
    SQL part: GROUP BY OriginalActivatorDisplayName
    
    This is a virtual column. It contains the same value as the column DisplayName of the referenced OriginalActivator.
    
    Specified by:
    
    originalActivatorDisplayName in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.originalActivatorDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - expiryActivatorId
```
public TaskQuery.GroupByQuery expiryActivatorId()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field ExpiryActivatorId.
    
    SQL part: GROUP BY ExpiryActivatorId
    
    Specified by:
    
    expiryActivatorId in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.expiryActivatorId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - expiryActivatorName
```
public TaskQuery.GroupByQuery expiryActivatorName()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field ExpiryActivatorName.
    
    SQL part: GROUP BY ExpiryActivatorName
    
    This is a virtual column. It contains the same value as the column MemberName of the referenced ExpiryActivator.
    
    Specified by:
    
    expiryActivatorName in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.expiryActivatorName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - expiryActivatorDisplayName
```
public TaskQuery.GroupByQuery expiryActivatorDisplayName()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field ExpiryActivatorDisplayName.
    
    SQL part: GROUP BY ExpiryActivatorDisplayName
    
    This is a virtual column. It contains the same value as the column DisplayName of the referenced ExpiryActivator.
    
    Specified by:
    
    expiryActivatorDisplayName in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.expiryActivatorDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - expiryPriority
```
public TaskQuery.GroupByQuery expiryPriority()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field ExpiryPriority.
    
    SQL part: GROUP BY ExpiryPriority
    
    Specified by:
    
    expiryPriority in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.expiryPriority()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - expiryTimestamp
```
public TaskQuery.GroupByQuery expiryTimestamp()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field ExpiryTimestamp.
    
    SQL part: GROUP BY ExpiryTimestamp
    
    Specified by:
    
    expiryTimestamp in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.expiryTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - expiryTaskStartElementPid
```
public TaskQuery.GroupByQuery expiryTaskStartElementPid()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field ExpiryTaskStartElementPid.
    
    SQL part: GROUP BY ExpiryTaskStartElementPid
    
    Specified by:
    
    expiryTaskStartElementPid in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.expiryTaskStartElementPid()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - isExpired
```
public TaskQuery.GroupByQuery isExpired()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field IsExpired.
    
    SQL part: GROUP BY IsExpired
    
    Specified by:
    
    isExpired in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.isExpired()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - expiredCreatorTaskId
```
public TaskQuery.GroupByQuery expiredCreatorTaskId()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field ExpiredCreatorTaskId.
    
    SQL part: GROUP BY ExpiredCreatorTaskId
    
    Specified by:
    
    expiredCreatorTaskId in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.expiredCreatorTaskId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - timeoutedCreatorIntrmdtEventId
```
public TaskQuery.GroupByQuery timeoutedCreatorIntrmdtEventId()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field TimeoutedCreatorIntrmdtEventId.
    
    SQL part: GROUP BY TimeoutedCreatorIntrmdtEventId
    
    Specified by:
    
    timeoutedCreatorIntrmdtEventId in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.timeoutedCreatorIntrmdtEventId()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - delayTimestamp
```
public TaskQuery.GroupByQuery delayTimestamp()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field DelayTimestamp.
    
    SQL part: GROUP BY DelayTimestamp
    
    Specified by:
    
    delayTimestamp in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.delayTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - state
```
public TaskQuery.GroupByQuery state()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field State.
    
    SQL part: GROUP BY State
    
    Specified by:
    
    state in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.state()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - requestPath
```
public TaskQuery.GroupByQuery requestPath()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field RequestPath.
    
    SQL part: GROUP BY RequestPath
    
    Specified by:
    
    requestPath in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.requestPath()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - displayNameTemplate
```
public TaskQuery.GroupByQuery displayNameTemplate()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field DisplayNameTemplate.
    
    SQL part: GROUP BY DisplayNameTemplate
    
    Specified by:
    
    displayNameTemplate in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.displayNameTemplate()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - name
```
public TaskQuery.GroupByQuery name()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field Name.
    
    SQL part: GROUP BY Name
    
    Specified by:
    
    name in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.name()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - displayDescriptionTemplate
```
public TaskQuery.GroupByQuery displayDescriptionTemplate()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field DisplayDescriptionTemplate.
    
    SQL part: GROUP BY DisplayDescriptionTemplate
    
    Specified by:
    
    displayDescriptionTemplate in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.displayDescriptionTemplate()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - description
```
public TaskQuery.GroupByQuery description()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field Description.
    
    SQL part: GROUP BY Description
    
    Specified by:
    
    description in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.description()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - priority
```
public TaskQuery.GroupByQuery priority()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field Priority.
    
    SQL part: GROUP BY Priority
    
    Specified by:
    
    priority in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.priority()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - originalPriority
```
public TaskQuery.GroupByQuery originalPriority()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field OriginalPriority.
    
    SQL part: GROUP BY OriginalPriority
    
    Specified by:
    
    originalPriority in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.originalPriority()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - startTimestamp
```
public TaskQuery.GroupByQuery startTimestamp()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field StartTimestamp.
    
    SQL part: GROUP BY StartTimestamp
    
    Specified by:
    
    startTimestamp in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.startTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - endTimestamp
```
public TaskQuery.GroupByQuery endTimestamp()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field EndTimestamp.
    
    SQL part: GROUP BY EndTimestamp
    
    Specified by:
    
    endTimestamp in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.endTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - businessCalendar
```
public TaskQuery.GroupByQuery businessCalendar()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field BusinessCalendar.
    
    SQL part: GROUP BY BusinessCalendar
    
    Specified by:
    
    businessCalendar in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.businessCalendar()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - workingTime
```
public TaskQuery.GroupByQuery workingTime()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field WorkingTime.
    
    SQL part: GROUP BY WorkingTime
    
    Specified by:
    
    workingTime in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.workingTime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - businessRuntime
```
public TaskQuery.GroupByQuery businessRuntime()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field BusinessRuntime.
    
    SQL part: GROUP BY BusinessRuntime
    
    Specified by:
    
    businessRuntime in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.businessRuntime()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - failedTimeoutTimestamp
```
public TaskQuery.GroupByQuery failedTimeoutTimestamp()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field FailedTimeoutTimestamp.
    
    SQL part: GROUP BY FailedTimeoutTimestamp
    
    Specified by:
    
    failedTimeoutTimestamp in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.failedTimeoutTimestamp()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - numberOfFailures
```
public TaskQuery.GroupByQuery numberOfFailures()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field NumberOfFailures.
    
    SQL part: GROUP BY NumberOfFailures
    
    Specified by:
    
    numberOfFailures in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.numberOfFailures()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - numberOfResumes
```
public TaskQuery.GroupByQuery numberOfResumes()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field NumberOfResumes.
    
    SQL part: GROUP BY NumberOfResumes
    
    Specified by:
    
    numberOfResumes in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.numberOfResumes()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - category
```
public TaskQuery.GroupByQuery category()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field Category.
    
    SQL part: GROUP BY Category
    
    Specified by:
    
    category in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.category()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - isUpdatedOnStart
```
public TaskQuery.GroupByQuery isUpdatedOnStart()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field IsUpdatedOnStart.
    
    SQL part: GROUP BY IsUpdatedOnStart
    
    Specified by:
    
    isUpdatedOnStart in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.isUpdatedOnStart()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - isOffline
```
public TaskQuery.GroupByQuery isOffline()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field IsOffline.
    
    SQL part: GROUP BY IsOffline
    
    Specified by:
    
    isOffline in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.isOffline()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - activatorName
```
public TaskQuery.GroupByQuery activatorName()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field ActivatorName.
    
    SQL part: GROUP BY ActivatorName
    
    This is a virtual column. It contains the same value as the column MemberName of the referenced Activator.
    
    Specified by:
    
    activatorName in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.activatorName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - activatorDisplayName
```
public TaskQuery.GroupByQuery activatorDisplayName()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by the field ActivatorDisplayName.
    
    SQL part: GROUP BY ActivatorDisplayName
    
    This is a virtual column. It contains the same value as the column DisplayName of the referenced Activator.
    
    Specified by:
    
    activatorDisplayName in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    See Also:
    
    TaskQuery.IGroupByQueryColumns.activatorDisplayName()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.
  - customField
```
public TaskQuery.ICustomFieldGroupBy customField()
```
    Description copied from interface: TaskQuery.IGroupByQueryColumns
    
    Groups the result of the query by a custom field specified during further composition.
    
    Specified by:
    
    customField in interface TaskQuery.IGroupByQueryColumns
    
    Returns:
    
    query for further composition
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.

Class TaskQuery.GroupByQuery

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

taskId

caseId

businessCaseId

processModelId

applicationId

startTaskSwitchEventId

endTaskSwitchEventId

taskStartId

taskEndId

workerId

workerUserName

workerUserDisplayName

workerSessionId

activatorId

originalActivatorId

originalActivatorName

originalActivatorDisplayName

expiryActivatorId

expiryActivatorName

expiryActivatorDisplayName

expiryPriority

expiryTimestamp

expiryTaskStartElementPid

isExpired

expiredCreatorTaskId

timeoutedCreatorIntrmdtEventId

delayTimestamp

state

requestPath

displayNameTemplate

name

displayDescriptionTemplate

description

priority

originalPriority

startTimestamp

endTimestamp

businessCalendar

workingTime

businessRuntime

failedTimeoutTimestamp

numberOfFailures

numberOfResumes

category

isUpdatedOnStart

isOffline

activatorName

activatorDisplayName

customField