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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    • businessState

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

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

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

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

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

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

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

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

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

    • customVarCharField1

      @Deprecated CaseQuery.GroupByQuery customVarCharField1()
      Deprecated.
      use customField().stringField("CustomVarCharField1") instead

      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 CaseQuery.GroupByQuery customVarCharField2()
      Deprecated.
      use customField().stringField("CustomVarCharField2") instead

      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 CaseQuery.GroupByQuery customVarCharField3()
      Deprecated.
      use customField().stringField("CustomVarCharField3") instead

      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 CaseQuery.GroupByQuery customVarCharField4()
      Deprecated.
      use customField().stringField("CustomVarCharField4") instead

      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 CaseQuery.GroupByQuery customVarCharField5()
      Deprecated.
      use customField().stringField("CustomVarCharField5") instead

      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 CaseQuery.GroupByQuery customDecimalField1()
      Deprecated.
      use customField().numberField("CustomDecimalField1") instead

      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 CaseQuery.GroupByQuery customDecimalField2()
      Deprecated.
      use customField().numberField("CustomDecimalField2") instead

      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 CaseQuery.GroupByQuery customDecimalField3()
      Deprecated.
      use customField().numberField("CustomDecimalField3") instead

      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 CaseQuery.GroupByQuery customDecimalField4()
      Deprecated.
      use customField().numberField("CustomDecimalField4") instead

      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 CaseQuery.GroupByQuery customDecimalField5()
      Deprecated.
      use customField().numberField("CustomDecimalField5") instead

      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 CaseQuery.GroupByQuery customTimestampField1()
      Deprecated.
      use customField().timestampField("CustomTimestampField1") instead

      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 CaseQuery.GroupByQuery customTimestampField2()
      Deprecated.
      use customField().timestampField("CustomTimestampField2") instead

      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 CaseQuery.GroupByQuery customTimestampField3()
      Deprecated.
      use customField().timestampField("CustomTimestampField3") instead

      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 CaseQuery.GroupByQuery customTimestampField4()
      Deprecated.
      use customField().timestampField("CustomTimestampField4") instead

      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 CaseQuery.GroupByQuery customTimestampField5()
      Deprecated.
      use customField().timestampField("CustomTimestampField5") instead

      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 CaseQuery.GroupByQuery businessMilestoneTimestamp()
      Deprecated.
      use customField().timestampField("BusinessMilestoneTimestamp") instead

      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 CaseQuery.GroupByQuery businessCreatorUser()
      Deprecated.
      use customField().stringField("BusinessCreatorUser") instead

      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 CaseQuery.GroupByQuery businessMainContactId()
      Deprecated.
      use customField().numberField("BusinessMainContactId") instead

      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 CaseQuery.GroupByQuery businessMainContactName()
      Deprecated.
      use customField().stringField("BusinessMainContactName") instead

      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 CaseQuery.GroupByQuery businessObjectCode()
      Deprecated.
      use customField().stringField("BusinessObjectCode") instead

      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 CaseQuery.GroupByQuery businessObjectName()
      Deprecated.
      use customField().stringField("BusinessObjectName") instead

      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 CaseQuery.GroupByQuery businessStartTimestamp()
      Deprecated.
      use customField().timestampField("BusinessStartTimestamp") instead

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

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

    • businessObjectFolderId

      @Deprecated CaseQuery.GroupByQuery businessObjectFolderId()
      Deprecated.
      use customField().stringField("BusinessObjectFolderId") instead

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

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

    • businessObjectDocDbCode

      @Deprecated CaseQuery.GroupByQuery businessObjectDocDbCode()
      Deprecated.
      use customField().stringField("BusinessObjectDocumentDbCode") instead

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

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

    • businessMainContactDocDbCode

      @Deprecated CaseQuery.GroupByQuery businessMainContactDocDbCode()
      Deprecated.
      use customField().stringField("BusinessMainContactDocumentDbCode") instead

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

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

    • businessMainContactFolderId

      @Deprecated CaseQuery.GroupByQuery businessMainContactFolderId()
      Deprecated.
      use customField().stringField("BusinessMainContactFolderId") instead

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

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

    • businessPriority

      @Deprecated CaseQuery.GroupByQuery businessPriority()
      Deprecated.
      use customField().stringField("BusinessPriority") instead

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

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

    • businessMainContactType

      @Deprecated CaseQuery.GroupByQuery businessMainContactType()
      Deprecated.
      use customField().stringField("BusinessMainContactType") instead

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

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

    • businessCorrespondentId

      @Deprecated CaseQuery.GroupByQuery businessCorrespondentId()
      Deprecated.
      use customField().numberField("BusinessCorrespondentId") instead

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

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

    • processCode

      @Deprecated CaseQuery.GroupByQuery processCode()
      Deprecated.
      use customField().stringField("ProcessCode") instead

      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 CaseQuery.GroupByQuery processName()
      Deprecated.
      use customField().stringField("ProcessName") instead

      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 CaseQuery.GroupByQuery processCategoryCode()
      Deprecated.
      use customField().stringField("ProcessCategoryCode") instead

      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 CaseQuery.GroupByQuery processCategoryName()
      Deprecated.
      use customField().stringField("ProcessCategoryName") instead

      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 CaseQuery.GroupByQuery typeCode()
      Deprecated.
      use customField().stringField("TypeCode") instead

      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 CaseQuery.GroupByQuery typeName()
      Deprecated.
      use customField().stringField("TypeName") instead

      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 CaseQuery.GroupByQuery subTypeCode()
      Deprecated.
      use customField().stringField("SubTypeCode") instead

      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 CaseQuery.GroupByQuery subTypeName()
      Deprecated.
      use customField().stringField("SubTypeName") instead

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

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

    • creatorUserId

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

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

      SQL part: GROUP BY CreatorUserId

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

    • ownerRoleId

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

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

      SQL part: GROUP BY OwnerRoleId

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

    • ownerUserId

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

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

      SQL part: GROUP BY OwnerUserId

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

    • businessCalendarId

      @Deprecated CaseQuery.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) CaseQuery.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) CaseQuery.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.