Package ch.ivyteam.ivy.workflow.query

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

      CaseQuery.AggregationQuery 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 IvyScript and Java. It has the visibility EXPERT.

    • minCaseId

      CaseQuery.AggregationQuery 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 IvyScript and Java. It has the visibility EXPERT.

    • maxCaseId

      CaseQuery.AggregationQuery 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • minEnvironment

      CaseQuery.AggregationQuery minEnvironment()

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

      SQL part: MIN(Environment) AS MinEnvironment

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

    • maxEnvironment

      CaseQuery.AggregationQuery maxEnvironment()

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

      SQL part: MAX(Environment) AS MaxEnvironment

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

    • minName

      CaseQuery.AggregationQuery 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 IvyScript and Java. It has the visibility EXPERT.

    • maxName

      CaseQuery.AggregationQuery 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • minStage

      CaseQuery.AggregationQuery 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 IvyScript and Java. It has the visibility EXPERT.

    • maxStage

      CaseQuery.AggregationQuery 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 IvyScript and Java. It has the visibility EXPERT.

    • minOwnerName

      CaseQuery.AggregationQuery 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 IvyScript and Java. It has the visibility EXPERT.

    • maxOwnerName

      CaseQuery.AggregationQuery 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • 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 IvyScript and Java. It has the visibility EXPERT.

    • minCategory

      CaseQuery.AggregationQuery 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 IvyScript and Java. It has the visibility EXPERT.

    • maxCategory

      CaseQuery.AggregationQuery 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 IvyScript and Java. It has the visibility EXPERT.

    • customField

      CaseQuery.ICustomFieldAggregationQuery 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 IvyScript and Java. It has the visibility EXPERT.