Package ch.ivyteam.ivy.workflow.query

Interface StartSignalEventElementQuery.IAggregationQuery

All Known Implementing Classes:

StartSignalEventElementQuery.AggregationQuery

Enclosing class:

StartSignalEventElementQuery

public static interface StartSignalEventElementQuery.IAggregationQuery

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.

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.

Method Detail

countRows

StartSignalEventElementQuery.AggregationQuery countRows()

Adds a result column Count to the query, that contains the number of (grouped) rows.

SQL part: COUNT(*) AS Count

Returns:

query for further composition

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

minSignalCodePattern

StartSignalEventElementQuery.AggregationQuery minSignalCodePattern()

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

Returns:

query for further composition

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.

maxSignalCodePattern

StartSignalEventElementQuery.AggregationQuery maxSignalCodePattern()

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

Returns:

query for further composition

API:

This public API is available in IvyScript and Java. It has the visibility EXPERT.