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

      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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • businessState

      TaskQuery.GroupByQuery businessState()

      Groups the result of the query by the field BusinessState.

      SQL part: GROUP BY BusinessState

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • 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 Java.
    • customVarCharField1

      @Deprecated TaskQuery.GroupByQuery customVarCharField1()

      Groups the result of the query by the legacy field "CustomVarCharField1".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • customVarCharField2

      @Deprecated TaskQuery.GroupByQuery customVarCharField2()

      Groups the result of the query by the legacy field "CustomVarCharField2".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • customVarCharField3

      @Deprecated TaskQuery.GroupByQuery customVarCharField3()

      Groups the result of the query by the legacy field "CustomVarCharField3".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • customVarCharField4

      @Deprecated TaskQuery.GroupByQuery customVarCharField4()

      Groups the result of the query by the legacy field "CustomVarCharField4".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • customVarCharField5

      @Deprecated TaskQuery.GroupByQuery customVarCharField5()

      Groups the result of the query by the legacy field "CustomVarCharField5".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • customDecimalField1

      @Deprecated TaskQuery.GroupByQuery customDecimalField1()

      Groups the result of the query by the legacy field "CustomDecimalField1".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • customDecimalField2

      @Deprecated TaskQuery.GroupByQuery customDecimalField2()

      Groups the result of the query by the legacy field "CustomDecimalField2".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • customDecimalField3

      @Deprecated TaskQuery.GroupByQuery customDecimalField3()

      Groups the result of the query by the legacy field "CustomDecimalField3".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • customDecimalField4

      @Deprecated TaskQuery.GroupByQuery customDecimalField4()

      Groups the result of the query by the legacy field "CustomDecimalField4".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • customDecimalField5

      @Deprecated TaskQuery.GroupByQuery customDecimalField5()

      Groups the result of the query by the legacy field "CustomDecimalField5".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • customTimestampField1

      @Deprecated TaskQuery.GroupByQuery customTimestampField1()

      Groups the result of the query by the legacy field "CustomTimestampField1".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • customTimestampField2

      @Deprecated TaskQuery.GroupByQuery customTimestampField2()

      Groups the result of the query by the legacy field "CustomTimestampField2".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • customTimestampField3

      @Deprecated TaskQuery.GroupByQuery customTimestampField3()

      Groups the result of the query by the legacy field "CustomTimestampField3".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • customTimestampField4

      @Deprecated TaskQuery.GroupByQuery customTimestampField4()

      Groups the result of the query by the legacy field "CustomTimestampField4".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • customTimestampField5

      @Deprecated TaskQuery.GroupByQuery customTimestampField5()

      Groups the result of the query by the legacy field "CustomTimestampField5".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • businessMilestoneTimestamp

      @Deprecated TaskQuery.GroupByQuery businessMilestoneTimestamp()

      Groups the result of the query by the legacy field "BusinessMilestoneTimestamp".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • businessCreatorUser

      @Deprecated TaskQuery.GroupByQuery businessCreatorUser()

      Groups the result of the query by the legacy field "BusinessCreatorUser".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • businessMainContactId

      @Deprecated TaskQuery.GroupByQuery businessMainContactId()

      Groups the result of the query by the legacy field "BusinessMainContactId".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • businessMainContactName

      @Deprecated TaskQuery.GroupByQuery businessMainContactName()

      Groups the result of the query by the legacy field "BusinessMainContactName".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • businessObjectCode

      @Deprecated TaskQuery.GroupByQuery businessObjectCode()

      Groups the result of the query by the legacy field "BusinessObjectCode".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • businessObjectName

      @Deprecated TaskQuery.GroupByQuery businessObjectName()

      Groups the result of the query by the legacy field "BusinessObjectName".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • businessStartTimestamp

      @Deprecated TaskQuery.GroupByQuery businessStartTimestamp()

      Groups the result of the query by the legacy field "BusinessStartTimestamp".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • kindCode

      Deprecated.

      Groups the result of the query by the legacy field "KindCode".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • kindName

      Deprecated.

      Groups the result of the query by the legacy field "KindName".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • processCode

      Deprecated.

      Groups the result of the query by the legacy field "ProcessCode".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • processName

      Deprecated.

      Groups the result of the query by the legacy field "ProcessName".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • processCategoryCode

      @Deprecated TaskQuery.GroupByQuery processCategoryCode()

      Groups the result of the query by the legacy field "ProcessCategoryCode".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • processCategoryName

      @Deprecated TaskQuery.GroupByQuery processCategoryName()

      Groups the result of the query by the legacy field "ProcessCategoryName".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • typeCode

      Deprecated.

      Groups the result of the query by the legacy field "TypeCode".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • typeName

      Deprecated.

      Groups the result of the query by the legacy field "TypeName".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • subTypeCode

      Deprecated.

      Groups the result of the query by the legacy field "SubTypeCode".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • subTypeName

      Deprecated.

      Groups the result of the query by the legacy field "SubTypeName".

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • workerUserId

      @Deprecated(since="9.1", forRemoval=true) TaskQuery.GroupByQuery workerUserId()
      Deprecated, for removal: This API element is subject to removal in a future version.
      use workerId() instead

      Groups the result of the query by the legacy field WorkerUserId.

      SQL part: GROUP BY WorkerUserId

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • activatorRoleId

      @Deprecated(since="9.1", forRemoval=true) TaskQuery.GroupByQuery activatorRoleId()
      Deprecated, for removal: This API element is subject to removal in a future version.
      use activatorId() instead

      Groups the result of the query by the legacy field ActivatorRoleId.

      SQL part: GROUP BY ActivatorRoleId

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • activatorUserId

      @Deprecated(since="9.1", forRemoval=true) TaskQuery.GroupByQuery activatorUserId()
      Deprecated, for removal: This API element is subject to removal in a future version.
      use activatorId() instead

      Groups the result of the query by the legacy field ActivatorUserId.

      SQL part: GROUP BY ActivatorUserId

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • originalActivatorRoleId

      @Deprecated(since="9.1", forRemoval=true) TaskQuery.GroupByQuery originalActivatorRoleId()
      Deprecated, for removal: This API element is subject to removal in a future version.

      Groups the result of the query by the legacy field OriginalActivatorRoleId.

      SQL part: GROUP BY OriginalActivatorRoleId

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • originalActivatorUserId

      @Deprecated(since="9.1", forRemoval=true) TaskQuery.GroupByQuery originalActivatorUserId()
      Deprecated, for removal: This API element is subject to removal in a future version.

      Groups the result of the query by the legacy field OriginalActivatorUserId.

      SQL part: GROUP BY OriginalActivatorUserId

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • expiryActivatorRoleId

      @Deprecated(since="9.1", forRemoval=true) TaskQuery.GroupByQuery expiryActivatorRoleId()
      Deprecated, for removal: This API element is subject to removal in a future version.

      Groups the result of the query by the legacy field ExpiryActivatorRoleId.

      SQL part: GROUP BY ExpiryActivatorRoleId

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • expiryActivatorUserId

      @Deprecated(since="9.1", forRemoval=true) TaskQuery.GroupByQuery expiryActivatorUserId()
      Deprecated, for removal: This API element is subject to removal in a future version.

      Groups the result of the query by the legacy field ExpiryActivatorUserId.

      SQL part: GROUP BY ExpiryActivatorUserId

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • businessCalendarId

      @Deprecated TaskQuery.GroupByQuery businessCalendarId()
      Deprecated.
      use businessCalendar() instead

      This method is deprecated. Instead of grouping the query by the field BusinessCalendarId it groups by the field BusinessCalendar.

      SQL part: GROUP BY BusinessCalendar

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • displayNameTemplate

      @Deprecated(since="9.4", forRemoval=true) TaskQuery.GroupByQuery displayNameTemplate()
      Deprecated, for removal: This API element is subject to removal in a future version.
      the removed DisplayNameTemplate column was never used in production.

      Does not add any group by because column DisplayNameTemplate was removed without any replacement.

      Returns:
      query for further composition
      API:
      This public API is available in Java.
    • displayDescriptionTemplate

      @Deprecated(since="9.4", forRemoval=true) TaskQuery.GroupByQuery displayDescriptionTemplate()
      Deprecated, for removal: This API element is subject to removal in a future version.
      the removed DisplayNameTemplate column was never used in production.

      Does not add any filter because column DisplayDescriptionTemplate was removed without any replacement.

      Returns:
      query for further composition
      API:
      This public API is available in Java.