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.

      • creatorId

        CaseQuery.GroupByQuery creatorId()

        Groups the result of the query by the field CreatorId.

        SQL part: GROUP BY CreatorId

        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

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


        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

        This is a virtual column. It contains the same value as the column DisplayName of the referenced Creator.


        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.

      • ownerId

        CaseQuery.GroupByQuery ownerId()

        Groups the result of the query by the field OwnerId.

        SQL part: GROUP BY OwnerId

        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

        This is a virtual column. It contains the same value as the column MemberName of the referenced Owner.


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

      • ownerDisplayName

        CaseQuery.GroupByQuery ownerDisplayName()

        Groups the result of the query by the field OwnerDisplayName.

        SQL part: GROUP BY OwnerDisplayName

        This is a virtual column. It contains the same value as the column DisplayName of the referenced Owner.


        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.