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.

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`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`	`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`	`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.

Methods inherited from class ch.ivyteam.ivy.workflow.query.SignalEventQuery
aggregate, create, executor, groupBy, orderBy, where

- Method Detail
  - 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
    
    See Also:
    
    SignalEventQuery.IAggregationQuery.countRows()
    
    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
    
    See Also:
    
    SignalEventQuery.IAggregationQuery.minSignalEventId()
    
    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
    
    See Also:
    
    SignalEventQuery.IAggregationQuery.maxSignalEventId()
    
    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
    
    See Also:
    
    SignalEventQuery.IAggregationQuery.minSignalCode()
    
    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
    
    See Also:
    
    SignalEventQuery.IAggregationQuery.maxSignalCode()
    
    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
    
    See Also:
    
    SignalEventQuery.IAggregationQuery.avgSentTimestamp()
    
    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
    
    See Also:
    
    SignalEventQuery.IAggregationQuery.minSentTimestamp()
    
    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
    
    See Also:
    
    SignalEventQuery.IAggregationQuery.maxSentTimestamp()
    
    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
    
    Specified by:
    
    minSentByUserName in interface SignalEventQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    SignalEventQuery.IAggregationQuery.minSentByUserName()
    
    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
    
    Specified by:
    
    maxSentByUserName in interface SignalEventQuery.IAggregationQuery
    
    Returns:
    
    query for further composition
    
    See Also:
    
    SignalEventQuery.IAggregationQuery.maxSentByUserName()
    
    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
    
    See Also:
    
    SignalEventQuery.IAggregationQuery.minSentByProcessElementPid()
    
    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
    
    See Also:
    
    SignalEventQuery.IAggregationQuery.maxSentByProcessElementPid()
    
    API:
    
    This public API is available in IvyScript and Java. It has the visibility EXPERT.

Class SignalEventQuery.AggregationQuery

Nested Class Summary

Nested classes/interfaces inherited from class ch.ivyteam.ivy.workflow.query.SignalEventQuery

Method Summary

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

Method Detail

countRows

minSignalEventId

maxSignalEventId

minSignalCode

maxSignalCode

avgSentTimestamp

minSentTimestamp

maxSentTimestamp

minSentByUserName

maxSentByUserName

minSentByProcessElementPid

maxSentByProcessElementPid