Interface CaseQuery.IAggregationQuery
- All Known Implementing Classes:
CaseQuery.AggregationQuery
- Enclosing class:
- CaseQuery
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
Modifier and TypeMethodDescriptionAdds a result columnAvgBusinessRuntime
to the query, that contains the average of the fieldBusinessRuntime
of all (grouped) rows.Adds a result columnAvgEndTimestamp
to the query, that contains the average of the fieldEndTimestamp
of all (grouped) rows.Adds a result columnAvgStartTimestamp
to the query, that contains the average of the fieldStartTimestamp
of all (grouped) rows.Adds a result columnAvgWorkingTime
to the query, that contains the average of the fieldWorkingTime
of all (grouped) rows.Adds a result columnCount
to the query, that contains the number of (grouped) rows.Adds a result custom field to the query.Adds a result columnMaxBusinessCalendar
to the query, that contains the maximum value of the fieldBusinessCalendar
of all (grouped) rows.Adds a result columnMaxBusinessRuntime
to the query, that contains the maximum value of the fieldBusinessRuntime
of all (grouped) rows.Adds a result columnMaxCaseId
to the query, that contains the maximum value of the fieldCaseId
of all (grouped) rows.Adds a result columnMaxCategory
to the query, that contains the maximum value of the fieldCategory
of all (grouped) rows.Adds a result columnMaxCreatorUserDisplayName
to the query, that contains the maximum value of the fieldCreatorUserDisplayName
of all (grouped) rows.Adds a result columnMaxCreatorUserName
to the query, that contains the maximum value of the fieldCreatorUserName
of all (grouped) rows.Adds a result columnMaxEndTimestamp
to the query, that contains the maximum value of the fieldEndTimestamp
of all (grouped) rows.Adds a result columnMaxEnvironment
to the query, that contains the maximum value of the fieldEnvironment
of all (grouped) rows.maxName()
Adds a result columnMaxName
to the query, that contains the maximum value of the fieldName
of all (grouped) rows.Adds a result columnMaxOwnerDisplayName
to the query, that contains the maximum value of the fieldOwnerDisplayName
of all (grouped) rows.Adds a result columnMaxOwnerName
to the query, that contains the maximum value of the fieldOwnerName
of all (grouped) rows.maxStage()
Adds a result columnMaxStage
to the query, that contains the maximum value of the fieldStage
of all (grouped) rows.Adds a result columnMaxStartTimestamp
to the query, that contains the maximum value of the fieldStartTimestamp
of all (grouped) rows.Adds a result columnMaxWorkingTime
to the query, that contains the maximum value of the fieldWorkingTime
of all (grouped) rows.Adds a result columnMinBusinessCalendar
to the query, that contains the minimum value of the fieldBusinessCalendar
of all (grouped) rows.Adds a result columnMinBusinessRuntime
to the query, that contains the minimum value of the fieldBusinessRuntime
of all (grouped) rows.Adds a result columnMinCaseId
to the query, that contains the minimum value of the fieldCaseId
of all (grouped) rows.Adds a result columnMinCategory
to the query, that contains the minimum value of the fieldCategory
of all (grouped) rows.Adds a result columnMinCreatorUserDisplayName
to the query, that contains the minimum value of the fieldCreatorUserDisplayName
of all (grouped) rows.Adds a result columnMinCreatorUserName
to the query, that contains the minimum value of the fieldCreatorUserName
of all (grouped) rows.Adds a result columnMinEndTimestamp
to the query, that contains the minimum value of the fieldEndTimestamp
of all (grouped) rows.Adds a result columnMinEnvironment
to the query, that contains the minimum value of the fieldEnvironment
of all (grouped) rows.minName()
Adds a result columnMinName
to the query, that contains the minimum value of the fieldName
of all (grouped) rows.Adds a result columnMinOwnerDisplayName
to the query, that contains the minimum value of the fieldOwnerDisplayName
of all (grouped) rows.Adds a result columnMinOwnerName
to the query, that contains the minimum value of the fieldOwnerName
of all (grouped) rows.minStage()
Adds a result columnMinStage
to the query, that contains the minimum value of the fieldStage
of all (grouped) rows.Adds a result columnMinStartTimestamp
to the query, that contains the minimum value of the fieldStartTimestamp
of all (grouped) rows.Adds a result columnMinWorkingTime
to the query, that contains the minimum value of the fieldWorkingTime
of all (grouped) rows.Adds a result columnSumBusinessRuntime
to the query, that contains the sum of the fieldBusinessRuntime
of all (grouped) rows.Adds a result columnSumWorkingTime
to the query, that contains the sum of the fieldWorkingTime
of all (grouped) rows.
-
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 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
This is a virtual column. It contains the same value as the column
Name
of the referencedCreator
.- 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
This is a virtual column. It contains the same value as the column
Name
of the referencedCreator
.- 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
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedCreator
.- 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
This is a virtual column. It contains the same value as the column
DisplayName
of the referencedCreator
.- 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 fieldEnvironment
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 fieldEnvironment
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 fieldName
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 referencedCaseLocalized
.- 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
This is a virtual column. It contains the same value as the column
Name
of the referencedCaseLocalized
.- 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
This is a virtual column. It contains the same value as the column
MemberName
of the referencedOwner
.- 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
This is a virtual column. It contains the same value as the column
MemberName
of the referencedOwner
.- 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 fieldOwnerDisplayName
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 referencedOwner
.- 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 fieldOwnerDisplayName
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 referencedOwner
.- 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.
-