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

Modifier and Type	Method	Description
StartSignalEventElementQuery.AggregationQuery	countRows()	Adds a result column Count to the query, that contains the number of (grouped) rows.
StartSignalEventElementQuery.AggregationQuery	maxSignalCodePattern()	Adds a result column MaxSignalCodePattern to the query, that contains the maximum value of the field SignalCodePattern of all (grouped) rows.
StartSignalEventElementQuery.AggregationQuery	minSignalCodePattern()	Adds a result column MinSignalCodePattern to the query, that contains the minimum value of the field SignalCodePattern of all (grouped) rows.

Methods inherited from class ch.ivyteam.ivy.workflow.query.StartSignalEventElementQuery

aggregate, create, executor, groupBy, orderBy, where

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 interface StartSignalEventElementQuery.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 field SignalCodePattern of all (grouped) rows.

SQL part: MIN(SignalCodePattern) AS MinSignalCodePattern

Specified by:

minSignalCodePattern in interface StartSignalEventElementQuery.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 field SignalCodePattern of all (grouped) rows.

SQL part: MAX(SignalCodePattern) AS MaxSignalCodePattern

Specified by:

maxSignalCodePattern in interface StartSignalEventElementQuery.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.