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 Details

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

    • securitySystemId

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

      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.

    • activatorId

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

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

    • environment

      CaseQuery.GroupByQuery environment()

      Groups the result of the query by the field Environment.

      SQL part: GROUP BY Environment

      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

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


      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

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


      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.

    • languageId

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


      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.