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.ICaseBusinessStateFilterQuery, 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.IUUIDColumnFilterQuery, 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.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.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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-