Package ch.ivyteam.ivy.workflow.query

Interface TaskQuery.IGroupByQueryColumns

All Known Implementing Classes:
TaskQuery.GroupByQuery
Enclosing class:
TaskQuery
public static interface 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.

  • Method Details

    • taskId

      TaskQuery.GroupByQuery taskId()

      Groups the result of the query by the field TaskId.

      SQL part: GROUP BY TaskId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • caseId

      TaskQuery.GroupByQuery caseId()

      Groups the result of the query by the field CaseId.

      SQL part: GROUP BY CaseId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • businessCaseId

      TaskQuery.GroupByQuery businessCaseId()

      Groups the result of the query by the field BusinessCaseId.

      SQL part: GROUP BY BusinessCaseId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • processModelId

      TaskQuery.GroupByQuery processModelId()

      Groups the result of the query by the field ProcessModelId.

      SQL part: GROUP BY ProcessModelId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • securitySystemId

      TaskQuery.GroupByQuery securitySystemId()

      Groups the result of the query by the field SecuritySystemId.

      SQL part: GROUP BY SecuritySystemId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • applicationId

      TaskQuery.GroupByQuery applicationId()

      Groups the result of the query by the field ApplicationId.

      SQL part: GROUP BY ApplicationId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • startTaskSwitchEventId

      TaskQuery.GroupByQuery startTaskSwitchEventId()

      Groups the result of the query by the field StartTaskSwitchEventId.

      SQL part: GROUP BY StartTaskSwitchEventId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • endTaskSwitchEventId

      TaskQuery.GroupByQuery endTaskSwitchEventId()

      Groups the result of the query by the field EndTaskSwitchEventId.

      SQL part: GROUP BY EndTaskSwitchEventId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • taskStartId

      TaskQuery.GroupByQuery taskStartId()

      Groups the result of the query by the field TaskStartId.

      SQL part: GROUP BY TaskStartId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • taskEndId

      TaskQuery.GroupByQuery taskEndId()

      Groups the result of the query by the field TaskEndId.

      SQL part: GROUP BY TaskEndId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • workerId

      TaskQuery.GroupByQuery workerId()

      Groups the result of the query by the field WorkerId.

      SQL part: GROUP BY WorkerId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • workerUserName

      TaskQuery.GroupByQuery workerUserName()

      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.


      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • workerUserDisplayName

      TaskQuery.GroupByQuery workerUserDisplayName()

      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.


      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • workerSessionId

      TaskQuery.GroupByQuery workerSessionId()

      Groups the result of the query by the field WorkerSessionId.

      SQL part: GROUP BY WorkerSessionId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • activatorId

      TaskQuery.GroupByQuery activatorId()

      Groups the result of the query by the field ActivatorId.

      SQL part: GROUP BY ActivatorId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • originalActivatorId

      TaskQuery.GroupByQuery originalActivatorId()

      Groups the result of the query by the field OriginalActivatorId.

      SQL part: GROUP BY OriginalActivatorId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • originalActivatorName

      TaskQuery.GroupByQuery originalActivatorName()

      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.


      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • originalActivatorDisplayName

      TaskQuery.GroupByQuery originalActivatorDisplayName()

      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.


      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • expiryActivatorId

      TaskQuery.GroupByQuery expiryActivatorId()

      Groups the result of the query by the field ExpiryActivatorId.

      SQL part: GROUP BY ExpiryActivatorId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • expiryActivatorName

      TaskQuery.GroupByQuery expiryActivatorName()

      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.


      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • expiryActivatorDisplayName

      TaskQuery.GroupByQuery expiryActivatorDisplayName()

      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.


      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • expiryPriority

      TaskQuery.GroupByQuery expiryPriority()

      Groups the result of the query by the field ExpiryPriority.

      SQL part: GROUP BY ExpiryPriority

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • expiryTimestamp

      TaskQuery.GroupByQuery expiryTimestamp()

      Groups the result of the query by the field ExpiryTimestamp.

      SQL part: GROUP BY ExpiryTimestamp

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • expiryTaskStartElementPid

      TaskQuery.GroupByQuery expiryTaskStartElementPid()

      Groups the result of the query by the field ExpiryTaskStartElementPid.

      SQL part: GROUP BY ExpiryTaskStartElementPid

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • isExpired

      TaskQuery.GroupByQuery isExpired()

      Groups the result of the query by the field IsExpired.

      SQL part: GROUP BY IsExpired

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • expiredCreatorTaskId

      TaskQuery.GroupByQuery expiredCreatorTaskId()

      Groups the result of the query by the field ExpiredCreatorTaskId.

      SQL part: GROUP BY ExpiredCreatorTaskId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • timeoutedCreatorIntrmdtEventId

      TaskQuery.GroupByQuery timeoutedCreatorIntrmdtEventId()

      Groups the result of the query by the field TimeoutedCreatorIntrmdtEventId.

      SQL part: GROUP BY TimeoutedCreatorIntrmdtEventId

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • delayTimestamp

      TaskQuery.GroupByQuery delayTimestamp()

      Groups the result of the query by the field DelayTimestamp.

      SQL part: GROUP BY DelayTimestamp

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • state

      TaskQuery.GroupByQuery state()

      Groups the result of the query by the field State.

      SQL part: GROUP BY State

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • requestPath

      TaskQuery.GroupByQuery requestPath()

      Groups the result of the query by the field RequestPath.

      SQL part: GROUP BY RequestPath

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • name

      TaskQuery.GroupByQuery name()

      Groups the result of the query by the field Name.

      SQL part: GROUP BY Name

      This is a virtual column. It contains the same value as the column Name of the referenced TaskLocalized.


      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • description

      TaskQuery.GroupByQuery description()

      Groups the result of the query by the field Description.

      SQL part: GROUP BY Description

      This is a virtual column. It contains the same value as the column Description of the referenced TaskLocalized.


      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • priority

      TaskQuery.GroupByQuery priority()

      Groups the result of the query by the field Priority.

      SQL part: GROUP BY Priority

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • originalPriority

      TaskQuery.GroupByQuery originalPriority()

      Groups the result of the query by the field OriginalPriority.

      SQL part: GROUP BY OriginalPriority

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • startTimestamp

      TaskQuery.GroupByQuery startTimestamp()

      Groups the result of the query by the field StartTimestamp.

      SQL part: GROUP BY StartTimestamp

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • endTimestamp

      TaskQuery.GroupByQuery endTimestamp()

      Groups the result of the query by the field EndTimestamp.

      SQL part: GROUP BY EndTimestamp

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • businessCalendar

      TaskQuery.GroupByQuery businessCalendar()

      Groups the result of the query by the field BusinessCalendar.

      SQL part: GROUP BY BusinessCalendar

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • workingTime

      TaskQuery.GroupByQuery workingTime()

      Groups the result of the query by the field WorkingTime.

      SQL part: GROUP BY WorkingTime

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • businessRuntime

      TaskQuery.GroupByQuery businessRuntime()

      Groups the result of the query by the field BusinessRuntime.

      SQL part: GROUP BY BusinessRuntime

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • failedTimeoutTimestamp

      TaskQuery.GroupByQuery failedTimeoutTimestamp()

      Groups the result of the query by the field FailedTimeoutTimestamp.

      SQL part: GROUP BY FailedTimeoutTimestamp

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • numberOfFailures

      TaskQuery.GroupByQuery numberOfFailures()

      Groups the result of the query by the field NumberOfFailures.

      SQL part: GROUP BY NumberOfFailures

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • numberOfResumes

      TaskQuery.GroupByQuery numberOfResumes()

      Groups the result of the query by the field NumberOfResumes.

      SQL part: GROUP BY NumberOfResumes

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • category

      TaskQuery.GroupByQuery category()

      Groups the result of the query by the field Category.

      SQL part: GROUP BY Category

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • isUpdatedOnStart

      TaskQuery.GroupByQuery isUpdatedOnStart()

      Groups the result of the query by the field IsUpdatedOnStart.

      SQL part: GROUP BY IsUpdatedOnStart

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • isOffline

      TaskQuery.GroupByQuery isOffline()

      Groups the result of the query by the field IsOffline.

      SQL part: GROUP BY IsOffline

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • activatorName

      TaskQuery.GroupByQuery activatorName()

      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.


      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • activatorDisplayName

      TaskQuery.GroupByQuery activatorDisplayName()

      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.


      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • languageId

      TaskQuery.GroupByQuery languageId()

      Groups the result of the query by the field LanguageId.

      SQL part: GROUP BY LanguageId

      This is a virtual column. It contains the same value as the column LanguageId of the referenced TaskLocalized.


      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • customField

      TaskQuery.ICustomFieldGroupBy customField()

      Groups the result of the query by a custom field specified during further composition.

      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.