Package ch.ivyteam.ivy.workflow.query

Interface CaseQuery.IGroupByQueryColumns

  • All Known Implementing Classes:
    CaseQuery.GroupByQuery
    Enclosing class:
    CaseQuery
    public static interface CaseQuery.IGroupByQueryColumns
    Provides methods to group the result by certain fields.

    Example: 

    CaseQuery.businessCases().groupBy().ownerRoleId().ownerName().aggregate().countRows();
    Corresponds to SQL: 
    SELECT OwnerRoleId, OwnerUserId, Count(*) AS Count FROM IWA_Case GROUP BY OwnerRoleId, OwnerUserId

    API:
    This is a public API.

    • Method Detail

      • caseId

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

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

      • applicationId

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

      • processModelId

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

      • taskStartId

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

      • creatorUserId

        CaseQuery.GroupByQuery creatorUserId()

        Groups the result of the query by the field CreatorUserId.

        SQL part: GROUP BY CreatorUserId

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

      • creatorUserName

        CaseQuery.GroupByQuery creatorUserName()

        Groups the result of the query by the field CreatorUserName.

        SQL part: GROUP BY CreatorUserName

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

      • creatorUserDisplayName

        CaseQuery.GroupByQuery creatorUserDisplayName()

        Groups the result of the query by the field CreatorUserDisplayName.

        SQL part: GROUP BY CreatorUserDisplayName

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

      • creatorTaskId

        CaseQuery.GroupByQuery creatorTaskId()

        Groups the result of the query by the field CreatorTaskId.

        SQL part: GROUP BY CreatorTaskId

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

      • environmentId

        CaseQuery.GroupByQuery environmentId()

        Groups the result of the query by the field EnvironmentId.

        SQL part: GROUP BY EnvironmentId

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

      • displayNameTemplate

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

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

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

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

      • startTimestamp

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

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

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

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

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

      • state

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

      • priority

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

      • stage

        CaseQuery.GroupByQuery stage()

        Groups the result of the query by the field Stage.

        SQL part: GROUP BY Stage

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

      • ownerRoleId

        CaseQuery.GroupByQuery ownerRoleId()

        Groups the result of the query by the field OwnerRoleId.

        SQL part: GROUP BY OwnerRoleId

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

      • ownerUserId

        CaseQuery.GroupByQuery ownerUserId()

        Groups the result of the query by the field OwnerUserId.

        SQL part: GROUP BY OwnerUserId

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

      • ownerName

        CaseQuery.GroupByQuery ownerName()

        Groups the result of the query by the field OwnerName.

        SQL part: GROUP BY OwnerName

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

      • category

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

      • customField

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