Interface CaseQuery.IAggregationQuery

All Known Implementing Classes:
CaseQuery.AggregationQuery
Enclosing class:
CaseQuery

public static interface CaseQuery.IAggregationQuery
Provides methods to perform aggregations on the query. For each aggregation a column is added to the result set.

Example:

CaseQuery.businessCases().aggregate().sumWorkingTime().avgWorkingTime();
Corresponds to SQL:
SELECT SUM(WorkingTime) AS SumWorkingTime, AVG(WorkingTime) AS AvgWorkingTime FROM IWA_Case

API:
This is a public API.
  • Method Details

    • countRows

      Adds a result column Count to the query, that contains the number of (grouped) rows.

      SQL part: COUNT(*) AS Count

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

      Adds a result column MinCaseId to the query, that contains the minimum value of the field CaseId of all (grouped) rows.

      SQL part: MIN(CaseId) AS MinCaseId

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

      Adds a result column MaxCaseId to the query, that contains the maximum value of the field CaseId of all (grouped) rows.

      SQL part: MAX(CaseId) AS MaxCaseId

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

      CaseQuery.AggregationQuery minCreatorUserName()

      Adds a result column MinCreatorUserName to the query, that contains the minimum value of the field CreatorUserName of all (grouped) rows.

      SQL part: MIN(CreatorUserName) AS MinCreatorUserName

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

      CaseQuery.AggregationQuery maxCreatorUserName()

      Adds a result column MaxCreatorUserName to the query, that contains the maximum value of the field CreatorUserName of all (grouped) rows.

      SQL part: MAX(CreatorUserName) AS MaxCreatorUserName

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

      CaseQuery.AggregationQuery minCreatorUserDisplayName()

      Adds a result column MinCreatorUserDisplayName to the query, that contains the minimum value of the field CreatorUserDisplayName of all (grouped) rows.

      SQL part: MIN(CreatorUserDisplayName) AS MinCreatorUserDisplayName

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

      CaseQuery.AggregationQuery maxCreatorUserDisplayName()

      Adds a result column MaxCreatorUserDisplayName to the query, that contains the maximum value of the field CreatorUserDisplayName of all (grouped) rows.

      SQL part: MAX(CreatorUserDisplayName) AS MaxCreatorUserDisplayName

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

      Adds a result column MinName to the query, that contains the minimum value of the field Name of all (grouped) rows.

      SQL part: MIN(Name) AS MinName

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

      Adds a result column MaxName to the query, that contains the maximum value of the field Name of all (grouped) rows.

      SQL part: MAX(Name) AS MaxName

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

      CaseQuery.AggregationQuery avgStartTimestamp()

      Adds a result column AvgStartTimestamp to the query, that contains the average of the field StartTimestamp of all (grouped) rows.

      SQL part: AVG(StartTimestamp) AS AvgStartTimestamp

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

      CaseQuery.AggregationQuery minStartTimestamp()

      Adds a result column MinStartTimestamp to the query, that contains the minimum value of the field StartTimestamp of all (grouped) rows.

      SQL part: MIN(StartTimestamp) AS MinStartTimestamp

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

      CaseQuery.AggregationQuery maxStartTimestamp()

      Adds a result column MaxStartTimestamp to the query, that contains the maximum value of the field StartTimestamp of all (grouped) rows.

      SQL part: MAX(StartTimestamp) AS MaxStartTimestamp

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

      CaseQuery.AggregationQuery avgEndTimestamp()

      Adds a result column AvgEndTimestamp to the query, that contains the average of the field EndTimestamp of all (grouped) rows.

      SQL part: AVG(EndTimestamp) AS AvgEndTimestamp

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

      CaseQuery.AggregationQuery minEndTimestamp()

      Adds a result column MinEndTimestamp to the query, that contains the minimum value of the field EndTimestamp of all (grouped) rows.

      SQL part: MIN(EndTimestamp) AS MinEndTimestamp

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

      CaseQuery.AggregationQuery maxEndTimestamp()

      Adds a result column MaxEndTimestamp to the query, that contains the maximum value of the field EndTimestamp of all (grouped) rows.

      SQL part: MAX(EndTimestamp) AS MaxEndTimestamp

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

      CaseQuery.AggregationQuery minModifiedTimestamp()

      Adds a result column MinModifiedTimestamp to the query, that contains the minimum value of the field ModifiedTimestamp of all (grouped) rows.

      SQL part: MIN(ModifiedTimestamp) AS MinModifiedTimestamp

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

      CaseQuery.AggregationQuery maxModifiedTimestamp()

      Adds a result column MaxModifiedTimestamp to the query, that contains the maximum value of the field ModifiedTimestamp of all (grouped) rows.

      SQL part: MAX(ModifiedTimestamp) AS MaxModifiedTimestamp

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

      CaseQuery.AggregationQuery minBusinessCalendar()

      Adds a result column MinBusinessCalendar to the query, that contains the minimum value of the field BusinessCalendar of all (grouped) rows.

      SQL part: MIN(BusinessCalendar) AS MinBusinessCalendar

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

      CaseQuery.AggregationQuery maxBusinessCalendar()

      Adds a result column MaxBusinessCalendar to the query, that contains the maximum value of the field BusinessCalendar of all (grouped) rows.

      SQL part: MAX(BusinessCalendar) AS MaxBusinessCalendar

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

      CaseQuery.AggregationQuery sumWorkingTime()

      Adds a result column SumWorkingTime to the query, that contains the sum of the field WorkingTime of all (grouped) rows.

      SQL part: SUM(WorkingTime) AS SumWorkingTime

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

      CaseQuery.AggregationQuery avgWorkingTime()

      Adds a result column AvgWorkingTime to the query, that contains the average of the field WorkingTime of all (grouped) rows.

      SQL part: AVG(WorkingTime) AS AvgWorkingTime

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

      CaseQuery.AggregationQuery minWorkingTime()

      Adds a result column MinWorkingTime to the query, that contains the minimum value of the field WorkingTime of all (grouped) rows.

      SQL part: MIN(WorkingTime) AS MinWorkingTime

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

      CaseQuery.AggregationQuery maxWorkingTime()

      Adds a result column MaxWorkingTime to the query, that contains the maximum value of the field WorkingTime of all (grouped) rows.

      SQL part: MAX(WorkingTime) AS MaxWorkingTime

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

      CaseQuery.AggregationQuery sumBusinessRuntime()

      Adds a result column SumBusinessRuntime to the query, that contains the sum of the field BusinessRuntime of all (grouped) rows.

      SQL part: SUM(BusinessRuntime) AS SumBusinessRuntime

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

      CaseQuery.AggregationQuery avgBusinessRuntime()

      Adds a result column AvgBusinessRuntime to the query, that contains the average of the field BusinessRuntime of all (grouped) rows.

      SQL part: AVG(BusinessRuntime) AS AvgBusinessRuntime

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

      CaseQuery.AggregationQuery minBusinessRuntime()

      Adds a result column MinBusinessRuntime to the query, that contains the minimum value of the field BusinessRuntime of all (grouped) rows.

      SQL part: MIN(BusinessRuntime) AS MinBusinessRuntime

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

      CaseQuery.AggregationQuery maxBusinessRuntime()

      Adds a result column MaxBusinessRuntime to the query, that contains the maximum value of the field BusinessRuntime of all (grouped) rows.

      SQL part: MAX(BusinessRuntime) AS MaxBusinessRuntime

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

      Adds a result column MinStage to the query, that contains the minimum value of the field Stage of all (grouped) rows.

      SQL part: MIN(Stage) AS MinStage

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

      Adds a result column MaxStage to the query, that contains the maximum value of the field Stage of all (grouped) rows.

      SQL part: MAX(Stage) AS MaxStage

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

      Adds a result column MinOwnerName to the query, that contains the minimum value of the field OwnerName of all (grouped) rows.

      SQL part: MIN(OwnerName) AS MinOwnerName

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

      Adds a result column MaxOwnerName to the query, that contains the maximum value of the field OwnerName of all (grouped) rows.

      SQL part: MAX(OwnerName) AS MaxOwnerName

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

      CaseQuery.AggregationQuery minOwnerDisplayName()

      Adds a result column MinOwnerDisplayName to the query, that contains the minimum value of the field OwnerDisplayName of all (grouped) rows.

      SQL part: MIN(OwnerDisplayName) AS MinOwnerDisplayName

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

      CaseQuery.AggregationQuery maxOwnerDisplayName()

      Adds a result column MaxOwnerDisplayName to the query, that contains the maximum value of the field OwnerDisplayName of all (grouped) rows.

      SQL part: MAX(OwnerDisplayName) AS MaxOwnerDisplayName

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

      Adds a result column MinCategory to the query, that contains the minimum value of the field Category of all (grouped) rows.

      SQL part: MIN(Category) AS MinCategory

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

      Adds a result column MaxCategory to the query, that contains the maximum value of the field Category of all (grouped) rows.

      SQL part: MAX(Category) AS MaxCategory

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

      Adds a result custom field to the query. Type and name are specified during further query composition.

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

      @Deprecated CaseQuery.AggregationQuery minCustomVarCharField1()
      Deprecated.
      use customField().minStringField("CustomVarCharField1")) instead

      Adds a result custom field "CustomVarCharField1" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxCustomVarCharField1()

      Adds a result custom field "CustomVarCharField1" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minCustomVarCharField2()
      Deprecated.
      use customField().minStringField("CustomVarCharField2")) instead

      Adds a result custom field "CustomVarCharField2" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxCustomVarCharField2()

      Adds a result custom field "CustomVarCharField2" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minCustomVarCharField3()
      Deprecated.
      use customField().minStringField("CustomVarCharField3")) instead

      Adds a result custom field "CustomVarCharField3" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxCustomVarCharField3()

      Adds a result custom field "CustomVarCharField3" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minCustomVarCharField4()
      Deprecated.
      use customField().minStringField("CustomVarCharField4")) instead

      Adds a result custom field "CustomVarCharField4" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxCustomVarCharField4()

      Adds a result custom field "CustomVarCharField4" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minCustomVarCharField5()
      Deprecated.
      use customField().minStringField("CustomVarCharField5")) instead

      Adds a result custom field "CustomVarCharField5" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxCustomVarCharField5()

      Adds a result custom field "CustomVarCharField5" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minCustomDecimalField1()

      Adds a result custom field "CustomDecimalField1" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxCustomDecimalField1()

      Adds a result custom field "CustomDecimalField1" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery avgCustomDecimalField1()

      Adds a result column "CustomDecimalField1" to the query, that contains the average of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery sumCustomDecimalField1()

      Adds a result column "CustomDecimalField1" to the query, that contains the sum of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minCustomDecimalField2()

      Adds a result custom field "CustomDecimalField2" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxCustomDecimalField2()

      Adds a result custom field "CustomDecimalField2" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery avgCustomDecimalField2()

      Adds a result column "CustomDecimalField2" to the query, that contains the average of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery sumCustomDecimalField2()

      Adds a result column "CustomDecimalField2" to the query, that contains the sum of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minCustomDecimalField3()

      Adds a result custom field "CustomDecimalField3" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxCustomDecimalField3()

      Adds a result custom field "CustomDecimalField3" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery avgCustomDecimalField3()

      Adds a result column "CustomDecimalField3" to the query, that contains the average of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery sumCustomDecimalField3()

      Adds a result column "CustomDecimalField3" to the query, that contains the sum of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minCustomDecimalField4()

      Adds a result custom field "CustomDecimalField4" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxCustomDecimalField4()

      Adds a result custom field "CustomDecimalField4" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery avgCustomDecimalField4()

      Adds a result column "CustomDecimalField4" to the query, that contains the average of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery sumCustomDecimalField4()

      Adds a result column "CustomDecimalField4" to the query, that contains the sum of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minCustomDecimalField5()

      Adds a result custom field "CustomDecimalField5" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxCustomDecimalField5()

      Adds a result custom field "CustomDecimalField5" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery avgCustomDecimalField5()

      Adds a result column "CustomDecimalField5" to the query, that contains the average of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery sumCustomDecimalField5()

      Adds a result column "CustomDecimalField5" to the query, that contains the sum of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minCustomTimestampField1()
      Deprecated.
      use customField().minTimestampField("CustomTimestampField1")) instead

      Adds a result custom field "CustomTimestampField1" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxCustomTimestampField1()

      Adds a result custom field "CustomTimestampField1" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery avgCustomTimestampField1()

      Adds a result column "CustomTimestampField1" to the query, that contains the average of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery sumCustomTimestampField1()

      Adds a result column "CustomTimestampField1" to the query, that contains the sum of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minCustomTimestampField2()
      Deprecated.
      use customField().minTimestampField("CustomTimestampField2")) instead

      Adds a result custom field "CustomTimestampField2" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxCustomTimestampField2()

      Adds a result custom field "CustomTimestampField2" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery avgCustomTimestampField2()

      Adds a result column "CustomTimestampField2" to the query, that contains the average of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery sumCustomTimestampField2()

      Adds a result column "CustomTimestampField2" to the query, that contains the sum of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minCustomTimestampField3()
      Deprecated.
      use customField().minTimestampField("CustomTimestampField3")) instead

      Adds a result custom field "CustomTimestampField3" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxCustomTimestampField3()

      Adds a result custom field "CustomTimestampField3" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery avgCustomTimestampField3()

      Adds a result column "CustomTimestampField3" to the query, that contains the average of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery sumCustomTimestampField3()

      Adds a result column "CustomTimestampField3" to the query, that contains the sum of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minCustomTimestampField4()
      Deprecated.
      use customField().minTimestampField("CustomTimestampField4")) instead

      Adds a result custom field "CustomTimestampField4" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxCustomTimestampField4()

      Adds a result custom field "CustomTimestampField4" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery avgCustomTimestampField4()

      Adds a result column "CustomTimestampField4" to the query, that contains the average of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery sumCustomTimestampField4()

      Adds a result column "CustomTimestampField4" to the query, that contains the sum of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minCustomTimestampField5()
      Deprecated.
      use customField().minTimestampField("CustomTimestampField5")) instead

      Adds a result custom field "CustomTimestampField5" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxCustomTimestampField5()

      Adds a result custom field "CustomTimestampField5" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery avgCustomTimestampField5()

      Adds a result column "CustomTimestampField5" to the query, that contains the average of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery sumCustomTimestampField5()

      Adds a result column "CustomTimestampField5" to the query, that contains the sum of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minBusinessMilestoneTimestamp()
      Deprecated.
      use customField().minTimestampField("BusinessMilestoneTimestamp")) instead

      Adds a result custom field "BusinessMilestoneTimestamp" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxBusinessMilestoneTimestamp()

      Adds a result custom field "BusinessMilestoneTimestamp" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery avgBusinessMilestoneTimestamp()

      Adds a result column "BusinessMilestoneTimestamp" to the query, that contains the average of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery sumBusinessMilestoneTimestamp()

      Adds a result column "BusinessMilestoneTimestamp" to the query, that contains the sum of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minBusinessCreatorUser()
      Deprecated.
      use customField().minStringField("BusinessCreatorUser")) instead

      Adds a result custom field "BusinessCreatorUser" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxBusinessCreatorUser()

      Adds a result custom field "BusinessCreatorUser" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minBusinessMainContactId()

      Adds a result custom field "BusinessMainContactId" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxBusinessMainContactId()

      Adds a result custom field "BusinessMainContactId" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery avgBusinessMainContactId()

      Adds a result column "BusinessMainContactId" to the query, that contains the average of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery sumBusinessMainContactId()

      Adds a result column "BusinessMainContactId" to the query, that contains the sum of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minBusinessMainContactName()
      Deprecated.
      use customField().minStringField("BusinessMainContactName")) instead

      Adds a result custom field "BusinessMainContactName" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxBusinessMainContactName()

      Adds a result custom field "BusinessMainContactName" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minBusinessObjectCode()
      Deprecated.
      use customField().minStringField("BusinessObjectCode")) instead

      Adds a result custom field "BusinessObjectCode" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxBusinessObjectCode()

      Adds a result custom field "BusinessObjectCode" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minBusinessObjectName()
      Deprecated.
      use customField().minStringField("BusinessObjectName")) instead

      Adds a result custom field "BusinessObjectName" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxBusinessObjectName()

      Adds a result custom field "BusinessObjectName" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minBusinessStartTimestamp()
      Deprecated.
      use customField().minTimestampField("BusinessStartTimestamp")) instead

      Adds a result custom field "BusinessStartTimestamp" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxBusinessStartTimestamp()

      Adds a result custom field "BusinessStartTimestamp" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery avgBusinessStartTimestamp()

      Adds a result column "BusinessStartTimestamp" to the query, that contains the average of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery sumBusinessStartTimestamp()

      Adds a result column "BusinessStartTimestamp" to the query, that contains the sum of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minBusinessObjectFolderId()
      Deprecated.
      use customField().minStringField("BusinessObjectFolderId")) instead

      Adds a result custom field "BusinessObjectFolderId" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxBusinessObjectFolderId()

      Adds a result custom field "BusinessObjectFolderId" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minBusinessObjectDocDbCode()
      Deprecated.
      use customField().minStringField("BusinessObjectDocumentDbCode")) instead

      Adds a result custom field "BusinessObjectDocumentDbCode" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxBusinessObjectDocDbCode()

      Adds a result custom field "BusinessObjectDocumentDbCode" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minBusinessMainContactDocDbCode()
      Deprecated.
      use customField().minStringField("BusinessMainContactDocumentDbCode")) instead

      Adds a result custom field "BusinessMainContactDocumentDbCode" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxBusinessMainContactDocDbCode()

      Adds a result custom field "BusinessMainContactDocumentDbCode" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minBusinessMainContactFolderId()
      Deprecated.
      use customField().minStringField("BusinessMainContactFolderId")) instead

      Adds a result custom field "BusinessMainContactFolderId" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxBusinessMainContactFolderId()

      Adds a result custom field "BusinessMainContactFolderId" to the query, that contains the maximum value of all (grouped) rows.

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

      Deprecated.
      use customField().minStringField("BusinessPriority")) instead

      Adds a result custom field "BusinessPriority" to the query, that contains the minimum value of all (grouped) rows.

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

      Adds a result custom field "BusinessPriority" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minBusinessMainContactType()
      Deprecated.
      use customField().minStringField("BusinessMainContactType")) instead

      Adds a result custom field "BusinessMainContactType" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxBusinessMainContactType()

      Adds a result custom field "BusinessMainContactType" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minBusinessCorrespondentId()

      Adds a result custom field "BusinessCorrespondentId" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxBusinessCorrespondentId()

      Adds a result custom field "BusinessCorrespondentId" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery avgBusinessCorrespondentId()

      Adds a result column "BusinessCorrespondentId" to the query, that contains the average of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery sumBusinessCorrespondentId()

      Adds a result column "BusinessCorrespondentId" to the query, that contains the sum of all (grouped) rows.

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

      Deprecated.
      use customField().minStringField("ProcessCode")) instead

      Adds a result custom field "ProcessCode" to the query, that contains the minimum value of all (grouped) rows.

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

      Adds a result custom field "ProcessCode" to the query, that contains the maximum value of all (grouped) rows.

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

      Deprecated.
      use customField().minStringField("ProcessName")) instead

      Adds a result custom field "ProcessName" to the query, that contains the minimum value of all (grouped) rows.

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

      Adds a result custom field "ProcessName" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minProcessCategoryCode()
      Deprecated.
      use customField().minStringField("ProcessCategoryCode")) instead

      Adds a result custom field "ProcessCategoryCode" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxProcessCategoryCode()

      Adds a result custom field "ProcessCategoryCode" to the query, that contains the maximum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery minProcessCategoryName()
      Deprecated.
      use customField().minStringField("ProcessCategoryName")) instead

      Adds a result custom field "ProcessCategoryName" to the query, that contains the minimum value of all (grouped) rows.

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

      @Deprecated CaseQuery.AggregationQuery maxProcessCategoryName()

      Adds a result custom field "ProcessCategoryName" to the query, that contains the maximum value of all (grouped) rows.

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

      Deprecated.
      use customField().minStringField("TypeCode")) instead

      Adds a result custom field "TypeCode" to the query, that contains the minimum value of all (grouped) rows.

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

      Adds a result custom field "TypeCode" to the query, that contains the maximum value of all (grouped) rows.

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

      Deprecated.
      use customField().minStringField("TypeName")) instead

      Adds a result custom field "TypeName" to the query, that contains the minimum value of all (grouped) rows.

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

      Adds a result custom field "TypeName" to the query, that contains the maximum value of all (grouped) rows.

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

      Deprecated.
      use customField().minStringField("SubTypeCode")) instead

      Adds a result custom field "SubTypeCode" to the query, that contains the minimum value of all (grouped) rows.

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

      Adds a result custom field "SubTypeCode" to the query, that contains the maximum value of all (grouped) rows.

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

      Deprecated.
      use customField().minStringField("SubTypeName")) instead

      Adds a result custom field "SubTypeName" to the query, that contains the minimum value of all (grouped) rows.

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

      Adds a result custom field "SubTypeName" to the query, that contains the maximum value of all (grouped) rows.

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