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.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
maxOwnerName()
Adds a result columnMaxOwnerName
to the query, that contains the maximum value of the fieldOwnerName
of all (grouped) rows.CaseQuery.AggregationQuery
maxStage()
Adds a result columnMaxStage
to the query, that contains the maximum value of the fieldStage
of all (grouped) rows.CaseQuery.AggregationQuery
maxStartTimestamp()
Adds a result columnMaxStartTimestamp
to the query, that contains the maximum value of the fieldStartTimestamp
of all (grouped) rows.CaseQuery.AggregationQuery
maxWorkingTime()
Adds a result columnMaxWorkingTime
to the query, that contains the maximum value of the fieldWorkingTime
of all (grouped) rows.CaseQuery.AggregationQuery
minBusinessCalendar()
Adds a result columnMinBusinessCalendar
to the query, that contains the minimum value of the fieldBusinessCalendar
of all (grouped) rows.CaseQuery.AggregationQuery
minBusinessRuntime()
Adds a result columnMinBusinessRuntime
to the query, that contains the minimum value of the fieldBusinessRuntime
of all (grouped) rows.CaseQuery.AggregationQuery
minCaseId()
Adds a result columnMinCaseId
to the query, that contains the minimum value of the fieldCaseId
of all (grouped) rows.CaseQuery.AggregationQuery
minCategory()
Adds a result columnMinCategory
to the query, that contains the minimum value of the fieldCategory
of all (grouped) rows.CaseQuery.AggregationQuery
minCreatorUserDisplayName()
Adds a result columnMinCreatorUserDisplayName
to the query, that contains the minimum value of the fieldCreatorUserDisplayName
of all (grouped) rows.CaseQuery.AggregationQuery
minCreatorUserName()
Adds a result columnMinCreatorUserName
to the query, that contains the minimum value of the fieldCreatorUserName
of all (grouped) rows.CaseQuery.AggregationQuery
minDisplayNameTemplate()
Adds a result columnMinDisplayNameTemplate
to the query, that contains the minimum value of the fieldDisplayNameTemplate
of all (grouped) rows.CaseQuery.AggregationQuery
minEndTimestamp()
Adds a result columnMinEndTimestamp
to the query, that contains the minimum value of the fieldEndTimestamp
of all (grouped) rows.CaseQuery.AggregationQuery
minName()
Adds a result columnMinName
to the query, that contains the minimum value of the fieldName
of all (grouped) rows.CaseQuery.AggregationQuery
minOwnerName()
Adds a result columnMinOwnerName
to the query, that contains the minimum value of the fieldOwnerName
of all (grouped) rows.CaseQuery.AggregationQuery
minStage()
Adds a result columnMinStage
to the query, that contains the minimum value of the fieldStage
of all (grouped) rows.CaseQuery.AggregationQuery
minStartTimestamp()
Adds a result columnMinStartTimestamp
to the query, that contains the minimum value of the fieldStartTimestamp
of all (grouped) rows.CaseQuery.AggregationQuery
minWorkingTime()
Adds a result columnMinWorkingTime
to the query, that contains the minimum value of the fieldWorkingTime
of all (grouped) rows.CaseQuery.AggregationQuery
sumBusinessRuntime()
Adds a result columnSumBusinessRuntime
to the query, that contains the sum of the fieldBusinessRuntime
of all (grouped) rows.CaseQuery.AggregationQuery
sumWorkingTime()
Adds a result columnSumWorkingTime
to the query, that contains the sum of the fieldWorkingTime
of all (grouped) rows.
-
-
-
Method Detail
-
countRows
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
- 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
- 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
- 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
- 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
- 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
- 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.
-
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.
-
-