Package ch.ivyteam.ivy.workflow.query

Interface TaskBoundarySignalEventReceiverQuery.IAggregationQuery

All Known Implementing Classes:

TaskBoundarySignalEventReceiverQuery.AggregationQuery

Enclosing class:

TaskBoundarySignalEventReceiverQuery

public static interface TaskBoundarySignalEventReceiverQuery.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
TaskBoundarySignalEventReceiverQuery.AggregationQuery	countRows()	Adds a result column Count to the query, that contains the number of (grouped) rows.
TaskBoundarySignalEventReceiverQuery.AggregationQuery	maxSignalCodePattern()	Adds a result column MaxSignalCodePattern to the query, that contains the maximum value of the field SignalCodePattern of all (grouped) rows.
TaskBoundarySignalEventReceiverQuery.AggregationQuery	maxTaskSignalEventId()	Adds a result column MaxTaskSignalEventId to the query, that contains the maximum value of the field TaskSignalEventId of all (grouped) rows.
TaskBoundarySignalEventReceiverQuery.AggregationQuery	minSignalCodePattern()	Adds a result column MinSignalCodePattern to the query, that contains the minimum value of the field SignalCodePattern of all (grouped) rows.
TaskBoundarySignalEventReceiverQuery.AggregationQuery	minTaskSignalEventId()	Adds a result column MinTaskSignalEventId to the query, that contains the minimum value of the field TaskSignalEventId of all (grouped) rows.

Method Detail

countRows

TaskBoundarySignalEventReceiverQuery.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.

minTaskSignalEventId

TaskBoundarySignalEventReceiverQuery.AggregationQuery minTaskSignalEventId()

Adds a result column MinTaskSignalEventId to the query, that contains the minimum value of the field TaskSignalEventId of all (grouped) rows.

SQL part: MIN(TaskSignalEventId) AS MinTaskSignalEventId

Returns:

query for further composition

API:

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

maxTaskSignalEventId

TaskBoundarySignalEventReceiverQuery.AggregationQuery maxTaskSignalEventId()

Adds a result column MaxTaskSignalEventId to the query, that contains the maximum value of the field TaskSignalEventId of all (grouped) rows.

SQL part: MAX(TaskSignalEventId) AS MaxTaskSignalEventId

Returns:

query for further composition

API:

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

minSignalCodePattern

TaskBoundarySignalEventReceiverQuery.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

TaskBoundarySignalEventReceiverQuery.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.