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 Detail

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

      • minDisplayNameTemplate

        CaseQuery.AggregationQuery minDisplayNameTemplate()

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

        SQL part: MIN(DisplayNameTemplate) AS MinDisplayNameTemplate

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

      • maxDisplayNameTemplate

        CaseQuery.AggregationQuery maxDisplayNameTemplate()

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

        SQL part: MAX(DisplayNameTemplate) AS MaxDisplayNameTemplate

        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

        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

        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.