Package ch.ivyteam.ivy.workflow.query

Class SignalEventQuery.AggregationQuery

java.lang.Object

ch.ivyteam.ivy.persistence.query.Query<ISignalEvent>

ch.ivyteam.ivy.workflow.query.SignalEventQuery

ch.ivyteam.ivy.workflow.query.SignalEventQuery.AggregationQuery

All Implemented Interfaces:

SignalEventQuery.IAggregationQuery

Enclosing class:

SignalEventQuery

public static class SignalEventQuery.AggregationQuery
extends SignalEventQuery
implements SignalEventQuery.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.SignalEventQuery

SignalEventQuery.AggregationQuery, SignalEventQuery.FilterLink, SignalEventQuery.FilterQuery, SignalEventQuery.GroupByQuery, SignalEventQuery.IAggregationQuery, SignalEventQuery.IBoolFilterQuery, SignalEventQuery.IColumnFilterQuery, SignalEventQuery.IDateColumnFilterQuery, SignalEventQuery.IFilterableColumns, SignalEventQuery.IFilterLink, SignalEventQuery.IFilterQuery, SignalEventQuery.IGroupByQueryColumns, SignalEventQuery.IIntegerColumnFilterQuery, SignalEventQuery.INumberColumnFilterQuery, SignalEventQuery.IOrderByQueryColumns, SignalEventQuery.IPatternColumnFilterQuery, SignalEventQuery.IStringColumnFilterQuery, SignalEventQuery.OrderByColumnQuery, SignalEventQuery.OrderByQuery

Method Summary

Modifier and Type	Method	Description
SignalEventQuery.AggregationQuery	avgSentByUserId()	Adds a result column AvgSentByUserId to the query, that contains the average of the field SentByUserId of all (grouped) rows.
SignalEventQuery.AggregationQuery	avgSentTimestamp()	Adds a result column AvgSentTimestamp to the query, that contains the average of the field SentTimestamp of all (grouped) rows.
SignalEventQuery.AggregationQuery	countRows()	Adds a result column Count to the query, that contains the number of (grouped) rows.
SignalEventQuery.AggregationQuery	maxSentByProcessElementPid()	Adds a result column MaxSentByProcessElementPid to the query, that contains the maximum value of the field SentByProcessElementPid of all (grouped) rows.
SignalEventQuery.AggregationQuery	maxSentByUserId()	Adds a result column MaxSentByUserId to the query, that contains the maximum value of the field SentByUserId of all (grouped) rows.
SignalEventQuery.AggregationQuery	maxSentByUserName()	Adds a result column MaxSentByUserName to the query, that contains the maximum value of the field SentByUserName of all (grouped) rows.
SignalEventQuery.AggregationQuery	maxSentTimestamp()	Adds a result column MaxSentTimestamp to the query, that contains the maximum value of the field SentTimestamp of all (grouped) rows.
SignalEventQuery.AggregationQuery	maxSignalCode()	Adds a result column MaxSignalCode to the query, that contains the maximum value of the field SignalCode of all (grouped) rows.
SignalEventQuery.AggregationQuery	maxSignalEventId()	Adds a result column MaxSignalEventId to the query, that contains the maximum value of the field SignalEventId of all (grouped) rows.
SignalEventQuery.AggregationQuery	minSentByProcessElementPid()	Adds a result column MinSentByProcessElementPid to the query, that contains the minimum value of the field SentByProcessElementPid of all (grouped) rows.
SignalEventQuery.AggregationQuery	minSentByUserId()	Adds a result column MinSentByUserId to the query, that contains the minimum value of the field SentByUserId of all (grouped) rows.
SignalEventQuery.AggregationQuery	minSentByUserName()	Adds a result column MinSentByUserName to the query, that contains the minimum value of the field SentByUserName of all (grouped) rows.
SignalEventQuery.AggregationQuery	minSentTimestamp()	Adds a result column MinSentTimestamp to the query, that contains the minimum value of the field SentTimestamp of all (grouped) rows.
SignalEventQuery.AggregationQuery	minSignalCode()	Adds a result column MinSignalCode to the query, that contains the minimum value of the field SignalCode of all (grouped) rows.
SignalEventQuery.AggregationQuery	minSignalEventId()	Adds a result column MinSignalEventId to the query, that contains the minimum value of the field SignalEventId of all (grouped) rows.
SignalEventQuery.AggregationQuery	sumSentByUserId()	Adds a result column SumSentByUserId to the query, that contains the sum of the field SentByUserId of all (grouped) rows.

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

aggregate, create, executor, groupBy, orderBy, where

Method Details

countRows

public SignalEventQuery.AggregationQuery countRows()

Description copied from interface: SignalEventQuery.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 SignalEventQuery.IAggregationQuery

Returns:

query for further composition

API:

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

minSignalEventId

public SignalEventQuery.AggregationQuery minSignalEventId()

Description copied from interface: SignalEventQuery.IAggregationQuery

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

SQL part: MIN(SignalEventId) AS MinSignalEventId

Specified by:

minSignalEventId in interface SignalEventQuery.IAggregationQuery

Returns:

query for further composition

API:

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

maxSignalEventId

public SignalEventQuery.AggregationQuery maxSignalEventId()

Description copied from interface: SignalEventQuery.IAggregationQuery

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

SQL part: MAX(SignalEventId) AS MaxSignalEventId

Specified by:

maxSignalEventId in interface SignalEventQuery.IAggregationQuery

Returns:

query for further composition

API:

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

minSignalCode

public SignalEventQuery.AggregationQuery minSignalCode()

Description copied from interface: SignalEventQuery.IAggregationQuery

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

SQL part: MIN(SignalCode) AS MinSignalCode

Specified by:

minSignalCode in interface SignalEventQuery.IAggregationQuery

Returns:

query for further composition

API:

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

maxSignalCode

public SignalEventQuery.AggregationQuery maxSignalCode()

Description copied from interface: SignalEventQuery.IAggregationQuery

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

SQL part: MAX(SignalCode) AS MaxSignalCode

Specified by:

maxSignalCode in interface SignalEventQuery.IAggregationQuery

Returns:

query for further composition

API:

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

avgSentTimestamp

public SignalEventQuery.AggregationQuery avgSentTimestamp()

Description copied from interface: SignalEventQuery.IAggregationQuery

Adds a result column AvgSentTimestamp to the query, that contains the average of the field SentTimestamp of all (grouped) rows.

SQL part: AVG(SentTimestamp) AS AvgSentTimestamp

Specified by:

avgSentTimestamp in interface SignalEventQuery.IAggregationQuery

Returns:

query for further composition

API:

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

minSentTimestamp

public SignalEventQuery.AggregationQuery minSentTimestamp()

Description copied from interface: SignalEventQuery.IAggregationQuery

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

SQL part: MIN(SentTimestamp) AS MinSentTimestamp

Specified by:

minSentTimestamp in interface SignalEventQuery.IAggregationQuery

Returns:

query for further composition

API:

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

maxSentTimestamp

public SignalEventQuery.AggregationQuery maxSentTimestamp()

Description copied from interface: SignalEventQuery.IAggregationQuery

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

SQL part: MAX(SentTimestamp) AS MaxSentTimestamp

Specified by:

maxSentTimestamp in interface SignalEventQuery.IAggregationQuery

Returns:

query for further composition

API:

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

minSentByUserName

public SignalEventQuery.AggregationQuery minSentByUserName()

Description copied from interface: SignalEventQuery.IAggregationQuery

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

SQL part: MIN(SentByUserName) AS MinSentByUserName

This is a virtual column. It contains the same value as the column Name of the referenced SecurityMember.

Specified by:

minSentByUserName in interface SignalEventQuery.IAggregationQuery

Returns:

query for further composition

API:

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

maxSentByUserName

public SignalEventQuery.AggregationQuery maxSentByUserName()

Description copied from interface: SignalEventQuery.IAggregationQuery

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

SQL part: MAX(SentByUserName) AS MaxSentByUserName

This is a virtual column. It contains the same value as the column Name of the referenced SecurityMember.

Specified by:

maxSentByUserName in interface SignalEventQuery.IAggregationQuery

Returns:

query for further composition

API:

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

sumSentByUserId

public SignalEventQuery.AggregationQuery sumSentByUserId()

Description copied from interface: SignalEventQuery.IAggregationQuery

Adds a result column SumSentByUserId to the query, that contains the sum of the field SentByUserId of all (grouped) rows.

SQL part: SUM(SentByUserId) AS SumSentByUserId

This is a virtual column. It contains the same value as the column UserId of the referenced User.

Specified by:

sumSentByUserId in interface SignalEventQuery.IAggregationQuery

Returns:

query for further composition

API:

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

avgSentByUserId

public SignalEventQuery.AggregationQuery avgSentByUserId()

Description copied from interface: SignalEventQuery.IAggregationQuery

Adds a result column AvgSentByUserId to the query, that contains the average of the field SentByUserId of all (grouped) rows.

SQL part: AVG(SentByUserId) AS AvgSentByUserId

This is a virtual column. It contains the same value as the column UserId of the referenced User.

Specified by:

avgSentByUserId in interface SignalEventQuery.IAggregationQuery

Returns:

query for further composition

API:

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

minSentByUserId

public SignalEventQuery.AggregationQuery minSentByUserId()

Description copied from interface: SignalEventQuery.IAggregationQuery

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

SQL part: MIN(SentByUserId) AS MinSentByUserId

This is a virtual column. It contains the same value as the column UserId of the referenced User.

Specified by:

minSentByUserId in interface SignalEventQuery.IAggregationQuery

Returns:

query for further composition

API:

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

maxSentByUserId

public SignalEventQuery.AggregationQuery maxSentByUserId()

Description copied from interface: SignalEventQuery.IAggregationQuery

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

SQL part: MAX(SentByUserId) AS MaxSentByUserId

This is a virtual column. It contains the same value as the column UserId of the referenced User.

Specified by:

maxSentByUserId in interface SignalEventQuery.IAggregationQuery

Returns:

query for further composition

API:

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

minSentByProcessElementPid

public SignalEventQuery.AggregationQuery minSentByProcessElementPid()

Description copied from interface: SignalEventQuery.IAggregationQuery

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

SQL part: MIN(SentByProcessElementPid) AS MinSentByProcessElementPid

Specified by:

minSentByProcessElementPid in interface SignalEventQuery.IAggregationQuery

Returns:

query for further composition

API:

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

maxSentByProcessElementPid

public SignalEventQuery.AggregationQuery maxSentByProcessElementPid()

Description copied from interface: SignalEventQuery.IAggregationQuery

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

SQL part: MAX(SentByProcessElementPid) AS MaxSentByProcessElementPid

Specified by:

maxSentByProcessElementPid in interface SignalEventQuery.IAggregationQuery

Returns:

query for further composition

API:

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