Class CaseQuery.AggregationQuery
- All Implemented Interfaces:
CaseQuery.IAggregationQuery
- 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.
-
Nested Class Summary
Nested classes/interfaces inherited from class ch.ivyteam.ivy.workflow.query.CaseQuery
CaseQuery.AggregationQuery, CaseQuery.FilterLink, CaseQuery.FilterQuery, CaseQuery.GroupByQuery, CaseQuery.IAggregationQuery, CaseQuery.IBoolFilterQuery, CaseQuery.ICaseStateFilterQuery, CaseQuery.IClobColumnFilterQuery, CaseQuery.IColumnFilterQuery, CaseQuery.ICustomFieldAggregationQuery, CaseQuery.ICustomFieldFilterQuery, CaseQuery.ICustomFieldGroupBy, CaseQuery.ICustomFieldOrderBy, CaseQuery.IDateColumnFilterQuery, CaseQuery.IFilterableColumns, CaseQuery.IFilterLink, CaseQuery.IFilterQuery, CaseQuery.IGroupByQueryColumns, CaseQuery.IIntegerColumnFilterQuery, CaseQuery.INumberColumnFilterQuery, CaseQuery.IOrderByQueryColumns, CaseQuery.IPatternColumnFilterQuery, CaseQuery.IStringColumnFilterQuery, CaseQuery.IWorkflowPriorityFilterQuery, CaseQuery.OrderByColumnQuery, CaseQuery.OrderByQuery
-
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
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 interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minCaseId
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
minCaseId
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxCaseId
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
maxCaseId
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minCreatorUserName
Description copied from interface:CaseQuery.IAggregationQuery
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
.- Specified by:
minCreatorUserName
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxCreatorUserName
Description copied from interface:CaseQuery.IAggregationQuery
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
.- Specified by:
maxCreatorUserName
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minCreatorUserDisplayName
Description copied from interface:CaseQuery.IAggregationQuery
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
.- Specified by:
minCreatorUserDisplayName
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxCreatorUserDisplayName
Description copied from interface:CaseQuery.IAggregationQuery
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
.- Specified by:
maxCreatorUserDisplayName
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minEnvironment
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
minEnvironment
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxEnvironment
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
maxEnvironment
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minName
Description copied from interface:CaseQuery.IAggregationQuery
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
.- Specified by:
minName
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxName
Description copied from interface:CaseQuery.IAggregationQuery
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
.- Specified by:
maxName
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
avgStartTimestamp
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
avgStartTimestamp
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minStartTimestamp
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
minStartTimestamp
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxStartTimestamp
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
maxStartTimestamp
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
avgEndTimestamp
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
avgEndTimestamp
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minEndTimestamp
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
minEndTimestamp
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxEndTimestamp
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
maxEndTimestamp
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minBusinessCalendar
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
minBusinessCalendar
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxBusinessCalendar
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
maxBusinessCalendar
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
sumWorkingTime
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
sumWorkingTime
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
avgWorkingTime
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
avgWorkingTime
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minWorkingTime
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
minWorkingTime
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxWorkingTime
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
maxWorkingTime
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
sumBusinessRuntime
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
sumBusinessRuntime
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
avgBusinessRuntime
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
avgBusinessRuntime
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minBusinessRuntime
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
minBusinessRuntime
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxBusinessRuntime
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
maxBusinessRuntime
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minStage
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
minStage
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxStage
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
maxStage
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minOwnerName
Description copied from interface:CaseQuery.IAggregationQuery
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
.- Specified by:
minOwnerName
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxOwnerName
Description copied from interface:CaseQuery.IAggregationQuery
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
.- Specified by:
maxOwnerName
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minOwnerDisplayName
Description copied from interface:CaseQuery.IAggregationQuery
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
.- Specified by:
minOwnerDisplayName
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxOwnerDisplayName
Description copied from interface:CaseQuery.IAggregationQuery
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
.- Specified by:
maxOwnerDisplayName
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minCategory
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
minCategory
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxCategory
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
maxCategory
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
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 interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-