Package ch.ivyteam.ivy.workflow.query
Class StartSignalEventElementQuery.AggregationQuery
- java.lang.Object
-
- ch.ivyteam.ivy.persistence.query.Query<IStartSignalEventElement>
-
- ch.ivyteam.ivy.workflow.query.StartSignalEventElementQuery
-
- ch.ivyteam.ivy.workflow.query.StartSignalEventElementQuery.AggregationQuery
-
- All Implemented Interfaces:
StartSignalEventElementQuery.IAggregationQuery
- Enclosing class:
- StartSignalEventElementQuery
public static class StartSignalEventElementQuery.AggregationQuery extends StartSignalEventElementQuery implements StartSignalEventElementQuery.IAggregationQuery
This class provides methods to perform aggregations on the query. For each aggregation a column is added to the result set.- API:
- This is a public API.
-
-
Nested Class Summary
-
Nested classes/interfaces inherited from class ch.ivyteam.ivy.workflow.query.StartSignalEventElementQuery
StartSignalEventElementQuery.AggregationQuery, StartSignalEventElementQuery.FilterLink, StartSignalEventElementQuery.FilterQuery, StartSignalEventElementQuery.GroupByQuery, StartSignalEventElementQuery.IAggregationQuery, StartSignalEventElementQuery.IBooleanColumnFilterQuery, StartSignalEventElementQuery.IColumnFilterQuery, StartSignalEventElementQuery.IFilterableColumns, StartSignalEventElementQuery.IFilterLink, StartSignalEventElementQuery.IFilterQuery, StartSignalEventElementQuery.IGroupByQueryColumns, StartSignalEventElementQuery.IIntegerColumnFilterQuery, StartSignalEventElementQuery.INumberColumnFilterQuery, StartSignalEventElementQuery.IOrderByQueryColumns, StartSignalEventElementQuery.IPatternColumnFilterQuery, StartSignalEventElementQuery.IStringColumnFilterQuery, StartSignalEventElementQuery.OrderByColumnQuery, StartSignalEventElementQuery.OrderByQuery
-
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description StartSignalEventElementQuery.AggregationQuery
countRows()
Adds a result columnCount
to the query, that contains the number of (grouped) rows.StartSignalEventElementQuery.AggregationQuery
maxSignalCodePattern()
Adds a result columnMaxSignalCodePattern
to the query, that contains the maximum value of the fieldSignalCodePattern
of all (grouped) rows.StartSignalEventElementQuery.AggregationQuery
minSignalCodePattern()
Adds a result columnMinSignalCodePattern
to the query, that contains the minimum value of the fieldSignalCodePattern
of all (grouped) rows.
-
-
-
Method Detail
-
countRows
public StartSignalEventElementQuery.AggregationQuery countRows()
Description copied from interface:StartSignalEventElementQuery.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 interfaceStartSignalEventElementQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
StartSignalEventElementQuery.IAggregationQuery.countRows()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minSignalCodePattern
public StartSignalEventElementQuery.AggregationQuery minSignalCodePattern()
Description copied from interface:StartSignalEventElementQuery.IAggregationQuery
Adds a result column
MinSignalCodePattern
to the query, that contains the minimum value of the fieldSignalCodePattern
of all (grouped) rows.SQL part:
MIN(SignalCodePattern) AS MinSignalCodePattern
- Specified by:
minSignalCodePattern
in interfaceStartSignalEventElementQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
StartSignalEventElementQuery.IAggregationQuery.minSignalCodePattern()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxSignalCodePattern
public StartSignalEventElementQuery.AggregationQuery maxSignalCodePattern()
Description copied from interface:StartSignalEventElementQuery.IAggregationQuery
Adds a result column
MaxSignalCodePattern
to the query, that contains the maximum value of the fieldSignalCodePattern
of all (grouped) rows.SQL part:
MAX(SignalCodePattern) AS MaxSignalCodePattern
- Specified by:
maxSignalCodePattern
in interfaceStartSignalEventElementQuery.IAggregationQuery
- Returns:
- query for further composition
- See Also:
StartSignalEventElementQuery.IAggregationQuery.maxSignalCodePattern()
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
-