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:
Corresponds to SQL:CaseQuery.businessCases().aggregate().sumWorkingTime().avgWorkingTime();
SELECT SUM(WorkingTime) AS SumWorkingTime, AVG(WorkingTime) AS AvgWorkingTime FROM IWA_Case
- API:
- This is a public API.
-
-
Method Summary
All Methods Instance Methods Abstract Methods Modifier and Type Method Description CaseQuery.AggregationQuery
avgBusinessRuntime()
Adds a result columnAvgBusinessRuntime
to the query, that contains the average of the fieldBusinessRuntime
of all (grouped) rows.CaseQuery.AggregationQuery
avgEndTimestamp()
Adds a result columnAvgEndTimestamp
to the query, that contains the average of the fieldEndTimestamp
of all (grouped) rows.CaseQuery.AggregationQuery
avgStartTimestamp()
Adds a result columnAvgStartTimestamp
to the query, that contains the average of the fieldStartTimestamp
of all (grouped) rows.CaseQuery.AggregationQuery
avgWorkingTime()
Adds a result columnAvgWorkingTime
to the query, that contains the average of the fieldWorkingTime
of all (grouped) rows.CaseQuery.AggregationQuery
countRows()
Adds a result columnCount
to the query, that contains the number of (grouped) rows.CaseQuery.ICustomFieldAggregationQuery
customField()
Adds a result custom field to the query.CaseQuery.AggregationQuery
maxBusinessCalendar()
Adds a result columnMaxBusinessCalendar
to the query, that contains the maximum value of the fieldBusinessCalendar
of all (grouped) rows.CaseQuery.AggregationQuery
maxBusinessRuntime()
Adds a result columnMaxBusinessRuntime
to the query, that contains the maximum value of the fieldBusinessRuntime
of all (grouped) rows.CaseQuery.AggregationQuery
maxCaseId()
Adds a result columnMaxCaseId
to the query, that contains the maximum value of the fieldCaseId
of all (grouped) rows.CaseQuery.AggregationQuery
maxCategory()
Adds a result columnMaxCategory
to the query, that contains the maximum value of the fieldCategory
of all (grouped) rows.CaseQuery.AggregationQuery
maxCreatorUserDisplayName()
Adds a result columnMaxCreatorUserDisplayName
to the query, that contains the maximum value of the fieldCreatorUserDisplayName
of all (grouped) rows.CaseQuery.AggregationQuery
maxCreatorUserName()
Adds a result columnMaxCreatorUserName
to the query, that contains the maximum value of the fieldCreatorUserName
of all (grouped) rows.CaseQuery.AggregationQuery
maxDisplayNameTemplate()
Adds a result columnMaxDisplayNameTemplate
to the query, that contains the maximum value of the fieldDisplayNameTemplate
of all (grouped) rows.CaseQuery.AggregationQuery
maxEndTimestamp()
Adds a result columnMaxEndTimestamp
to the query, that contains the maximum value of the fieldEndTimestamp
of all (grouped) rows.CaseQuery.AggregationQuery
maxName()
Adds a result columnMaxName
to the query, that contains the maximum value of the fieldName
of all (grouped) rows.CaseQuery.AggregationQuery
maxOwnerName()
Adds a result columnMaxOwnerName
to the query, that contains the maximum value of the fieldOwnerName
of all (grouped) rows.CaseQuery.AggregationQuery
maxStage()
Adds a result columnMaxStage
to the query, that contains the maximum value of the fieldStage
of all (grouped) rows.CaseQuery.AggregationQuery
maxStartTimestamp()
Adds a result columnMaxStartTimestamp
to the query, that contains the maximum value of the fieldStartTimestamp
of all (grouped) rows.CaseQuery.AggregationQuery
maxWorkingTime()
Adds a result columnMaxWorkingTime
to the query, that contains the maximum value of the fieldWorkingTime
of all (grouped) rows.CaseQuery.AggregationQuery
minBusinessCalendar()
Adds a result columnMinBusinessCalendar
to the query, that contains the minimum value of the fieldBusinessCalendar
of all (grouped) rows.CaseQuery.AggregationQuery
minBusinessRuntime()
Adds a result columnMinBusinessRuntime
to the query, that contains the minimum value of the fieldBusinessRuntime
of all (grouped) rows.CaseQuery.AggregationQuery
minCaseId()
Adds a result columnMinCaseId
to the query, that contains the minimum value of the fieldCaseId
of all (grouped) rows.CaseQuery.AggregationQuery
minCategory()
Adds a result columnMinCategory
to the query, that contains the minimum value of the fieldCategory
of all (grouped) rows.CaseQuery.AggregationQuery
minCreatorUserDisplayName()
Adds a result columnMinCreatorUserDisplayName
to the query, that contains the minimum value of the fieldCreatorUserDisplayName
of all (grouped) rows.CaseQuery.AggregationQuery
minCreatorUserName()
Adds a result columnMinCreatorUserName
to the query, that contains the minimum value of the fieldCreatorUserName
of all (grouped) rows.CaseQuery.AggregationQuery
minDisplayNameTemplate()
Adds a result columnMinDisplayNameTemplate
to the query, that contains the minimum value of the fieldDisplayNameTemplate
of all (grouped) rows.CaseQuery.AggregationQuery
minEndTimestamp()
Adds a result columnMinEndTimestamp
to the query, that contains the minimum value of the fieldEndTimestamp
of all (grouped) rows.CaseQuery.AggregationQuery
minName()
Adds a result columnMinName
to the query, that contains the minimum value of the fieldName
of all (grouped) rows.CaseQuery.AggregationQuery
minOwnerName()
Adds a result columnMinOwnerName
to the query, that contains the minimum value of the fieldOwnerName
of all (grouped) rows.CaseQuery.AggregationQuery
minStage()
Adds a result columnMinStage
to the query, that contains the minimum value of the fieldStage
of all (grouped) rows.CaseQuery.AggregationQuery
minStartTimestamp()
Adds a result columnMinStartTimestamp
to the query, that contains the minimum value of the fieldStartTimestamp
of all (grouped) rows.CaseQuery.AggregationQuery
minWorkingTime()
Adds a result columnMinWorkingTime
to the query, that contains the minimum value of the fieldWorkingTime
of all (grouped) rows.CaseQuery.AggregationQuery
sumBusinessRuntime()
Adds a result columnSumBusinessRuntime
to the query, that contains the sum of the fieldBusinessRuntime
of all (grouped) rows.CaseQuery.AggregationQuery
sumWorkingTime()
Adds a result columnSumWorkingTime
to the query, that contains the sum of the fieldWorkingTime
of all (grouped) rows.
-
-
-
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 fieldCaseId
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 fieldCaseId
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 fieldCreatorUserName
of all (grouped) rows.SQL part:
MIN(CreatorUserName) AS MinCreatorUserName
- 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 fieldCreatorUserName
of all (grouped) rows.SQL part:
MAX(CreatorUserName) AS MaxCreatorUserName
- 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 fieldCreatorUserDisplayName
of all (grouped) rows.SQL part:
MIN(CreatorUserDisplayName) AS MinCreatorUserDisplayName
- 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 fieldCreatorUserDisplayName
of all (grouped) rows.SQL part:
MAX(CreatorUserDisplayName) AS MaxCreatorUserDisplayName
- 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 fieldDisplayNameTemplate
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 fieldDisplayNameTemplate
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 fieldName
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 fieldName
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 fieldStartTimestamp
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 fieldStartTimestamp
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 fieldStartTimestamp
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 fieldEndTimestamp
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 fieldEndTimestamp
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 fieldEndTimestamp
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 fieldBusinessCalendar
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 fieldBusinessCalendar
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 fieldWorkingTime
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 fieldWorkingTime
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 fieldWorkingTime
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 fieldWorkingTime
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 fieldBusinessRuntime
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 fieldBusinessRuntime
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 fieldBusinessRuntime
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 fieldBusinessRuntime
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 fieldStage
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 fieldStage
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 fieldOwnerName
of all (grouped) rows.SQL part:
MIN(OwnerName) AS MinOwnerName
- 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 fieldOwnerName
of all (grouped) rows.SQL part:
MAX(OwnerName) AS MaxOwnerName
- 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 fieldCategory
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 fieldCategory
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.
-
-