Class CaseQuery.AggregationQuery
- java.lang.Object
-
- ch.ivyteam.ivy.persistence.query.Query<ICase>
-
- ch.ivyteam.ivy.workflow.query.CaseQuery
-
- ch.ivyteam.ivy.workflow.query.CaseQuery.AggregationQuery
-
- All Implemented Interfaces:
CaseQuery.IAggregationQuery
- Enclosing class:
- CaseQuery
public static class CaseQuery.AggregationQuery extends CaseQuery implements CaseQuery.IAggregationQuery
This class 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.
-
-
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
All Methods Instance Methods Concrete 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
maxOwnerDisplayName()
Adds a result columnMaxOwnerDisplayName
to the query, that contains the maximum value of the fieldOwnerDisplayName
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
minOwnerDisplayName()
Adds a result columnMinOwnerDisplayName
to the query, that contains the minimum value of the fieldOwnerDisplayName
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
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.countRows()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minCaseId
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.minCaseId()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxCaseId
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.maxCaseId()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minCreatorUserName
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.minCreatorUserName()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxCreatorUserName
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.maxCreatorUserName()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minCreatorUserDisplayName
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.minCreatorUserDisplayName()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxCreatorUserDisplayName
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.maxCreatorUserDisplayName()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minDisplayNameTemplate
public CaseQuery.AggregationQuery minDisplayNameTemplate()
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
minDisplayNameTemplate
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
CaseQuery.IAggregationQuery.minDisplayNameTemplate()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxDisplayNameTemplate
public CaseQuery.AggregationQuery maxDisplayNameTemplate()
Description copied from interface:CaseQuery.IAggregationQuery
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
- Specified by:
maxDisplayNameTemplate
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
CaseQuery.IAggregationQuery.maxDisplayNameTemplate()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minName
public CaseQuery.AggregationQuery 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
- Specified by:
minName
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
CaseQuery.IAggregationQuery.minName()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxName
public CaseQuery.AggregationQuery 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
- Specified by:
maxName
in interfaceCaseQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
CaseQuery.IAggregationQuery.maxName()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
avgStartTimestamp
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.avgStartTimestamp()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minStartTimestamp
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.minStartTimestamp()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxStartTimestamp
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.maxStartTimestamp()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
avgEndTimestamp
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.avgEndTimestamp()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minEndTimestamp
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.minEndTimestamp()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxEndTimestamp
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.maxEndTimestamp()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minBusinessCalendar
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.minBusinessCalendar()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxBusinessCalendar
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.maxBusinessCalendar()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
sumWorkingTime
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.sumWorkingTime()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
avgWorkingTime
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.avgWorkingTime()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minWorkingTime
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.minWorkingTime()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxWorkingTime
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.maxWorkingTime()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
sumBusinessRuntime
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.sumBusinessRuntime()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
avgBusinessRuntime
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.avgBusinessRuntime()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minBusinessRuntime
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.minBusinessRuntime()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxBusinessRuntime
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.maxBusinessRuntime()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minStage
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.minStage()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxStage
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.maxStage()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minOwnerName
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.minOwnerName()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxOwnerName
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.maxOwnerName()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minOwnerDisplayName
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.minOwnerDisplayName()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxOwnerDisplayName
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.maxOwnerDisplayName()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minCategory
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.minCategory()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxCategory
public CaseQuery.AggregationQuery 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
- See Also:
CaseQuery.IAggregationQuery.maxCategory()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
customField
public CaseQuery.ICustomFieldAggregationQuery 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.
-
-