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 Detail

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

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

      • displayNameTemplate

        TaskQuery.GroupByQuery displayNameTemplate()

        Groups the result of the query by the field DisplayNameTemplate.

        SQL part: GROUP BY DisplayNameTemplate

        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

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

      • displayDescriptionTemplate

        TaskQuery.GroupByQuery displayDescriptionTemplate()

        Groups the result of the query by the field DisplayDescriptionTemplate.

        SQL part: GROUP BY DisplayDescriptionTemplate

        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

        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.

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