Package ch.ivyteam.ivy.workflow.query

Class CaseQuery.AggregationQuery

java.lang.Object
ch.ivyteam.ivy.persistence.query.Query<ICase>
ch.ivyteam.ivy.workflow.query.CaseQuery
ch.ivyteam.ivy.workflow.query.CaseQuery.AggregationQuery
All Implemented Interfaces:
CaseQuery.IAggregationQuery
Enclosing class:
CaseQuery
public class CaseQuery.AggregationQuery extends CaseQuery implements CaseQuery.IAggregationQuery
This class 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

      public CaseQuery.AggregationQuery countRows()
      Description copied from interface: CaseQuery.IAggregationQuery

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

      SQL part: COUNT(*) AS Count

      Specified by:
      countRows in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minCaseId

      public CaseQuery.AggregationQuery minCaseId()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      minCaseId in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxCaseId

      public CaseQuery.AggregationQuery maxCaseId()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      maxCaseId in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minCreatorUserName

      public CaseQuery.AggregationQuery minCreatorUserName()
      Description copied from interface: CaseQuery.IAggregationQuery

      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.


      Specified by:
      minCreatorUserName in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxCreatorUserName

      public CaseQuery.AggregationQuery maxCreatorUserName()
      Description copied from interface: CaseQuery.IAggregationQuery

      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.


      Specified by:
      maxCreatorUserName in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minCreatorUserDisplayName

      public CaseQuery.AggregationQuery minCreatorUserDisplayName()
      Description copied from interface: CaseQuery.IAggregationQuery

      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.


      Specified by:
      minCreatorUserDisplayName in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxCreatorUserDisplayName

      public CaseQuery.AggregationQuery maxCreatorUserDisplayName()
      Description copied from interface: CaseQuery.IAggregationQuery

      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.


      Specified by:
      maxCreatorUserDisplayName in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minEnvironment

      public CaseQuery.AggregationQuery minEnvironment()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      minEnvironment in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxEnvironment

      public CaseQuery.AggregationQuery maxEnvironment()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      maxEnvironment in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minName

      public CaseQuery.AggregationQuery minName()
      Description copied from interface: CaseQuery.IAggregationQuery

      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.


      Specified by:
      minName in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxName

      public CaseQuery.AggregationQuery maxName()
      Description copied from interface: CaseQuery.IAggregationQuery

      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.


      Specified by:
      maxName in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • avgStartTimestamp

      public CaseQuery.AggregationQuery avgStartTimestamp()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      avgStartTimestamp in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minStartTimestamp

      public CaseQuery.AggregationQuery minStartTimestamp()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      minStartTimestamp in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxStartTimestamp

      public CaseQuery.AggregationQuery maxStartTimestamp()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      maxStartTimestamp in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • avgEndTimestamp

      public CaseQuery.AggregationQuery avgEndTimestamp()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      avgEndTimestamp in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minEndTimestamp

      public CaseQuery.AggregationQuery minEndTimestamp()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      minEndTimestamp in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxEndTimestamp

      public CaseQuery.AggregationQuery maxEndTimestamp()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      maxEndTimestamp in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minBusinessCalendar

      public CaseQuery.AggregationQuery minBusinessCalendar()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      minBusinessCalendar in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxBusinessCalendar

      public CaseQuery.AggregationQuery maxBusinessCalendar()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      maxBusinessCalendar in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • sumWorkingTime

      public CaseQuery.AggregationQuery sumWorkingTime()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      sumWorkingTime in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • avgWorkingTime

      public CaseQuery.AggregationQuery avgWorkingTime()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      avgWorkingTime in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minWorkingTime

      public CaseQuery.AggregationQuery minWorkingTime()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      minWorkingTime in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxWorkingTime

      public CaseQuery.AggregationQuery maxWorkingTime()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      maxWorkingTime in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • sumBusinessRuntime

      public CaseQuery.AggregationQuery sumBusinessRuntime()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      sumBusinessRuntime in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • avgBusinessRuntime

      public CaseQuery.AggregationQuery avgBusinessRuntime()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      avgBusinessRuntime in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minBusinessRuntime

      public CaseQuery.AggregationQuery minBusinessRuntime()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      minBusinessRuntime in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxBusinessRuntime

      public CaseQuery.AggregationQuery maxBusinessRuntime()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      maxBusinessRuntime in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minStage

      public CaseQuery.AggregationQuery minStage()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      minStage in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxStage

      public CaseQuery.AggregationQuery maxStage()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      maxStage in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minOwnerName

      public CaseQuery.AggregationQuery minOwnerName()
      Description copied from interface: CaseQuery.IAggregationQuery

      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.


      Specified by:
      minOwnerName in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxOwnerName

      public CaseQuery.AggregationQuery maxOwnerName()
      Description copied from interface: CaseQuery.IAggregationQuery

      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.


      Specified by:
      maxOwnerName in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minOwnerDisplayName

      public CaseQuery.AggregationQuery minOwnerDisplayName()
      Description copied from interface: CaseQuery.IAggregationQuery

      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.


      Specified by:
      minOwnerDisplayName in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxOwnerDisplayName

      public CaseQuery.AggregationQuery maxOwnerDisplayName()
      Description copied from interface: CaseQuery.IAggregationQuery

      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.


      Specified by:
      maxOwnerDisplayName in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • minCategory

      public CaseQuery.AggregationQuery minCategory()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      minCategory in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • maxCategory

      public CaseQuery.AggregationQuery maxCategory()
      Description copied from interface: CaseQuery.IAggregationQuery

      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

      Specified by:
      maxCategory in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.

    • customField

      public CaseQuery.ICustomFieldAggregationQuery customField()
      Description copied from interface: CaseQuery.IAggregationQuery

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

      Specified by:
      customField in interface CaseQuery.IAggregationQuery
      Returns:
      query for further composition
      API:
      This public API is available in IvyScript and Java. It has the visibility EXPERT.