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.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
All Methods Instance Methods Concrete Methods Modifier and Type Method Description SignalEventQuery.AggregationQuery
avgSentTimestamp()
Adds a result columnAvgSentTimestamp
to the query, that contains the average of the fieldSentTimestamp
of all (grouped) rows.SignalEventQuery.AggregationQuery
countRows()
Adds a result columnCount
to the query, that contains the number of (grouped) rows.SignalEventQuery.AggregationQuery
maxSentByProcessElementPid()
Adds a result columnMaxSentByProcessElementPid
to the query, that contains the maximum value of the fieldSentByProcessElementPid
of all (grouped) rows.SignalEventQuery.AggregationQuery
maxSentByUserName()
Adds a result columnMaxSentByUserName
to the query, that contains the maximum value of the fieldSentByUserName
of all (grouped) rows.SignalEventQuery.AggregationQuery
maxSentTimestamp()
Adds a result columnMaxSentTimestamp
to the query, that contains the maximum value of the fieldSentTimestamp
of all (grouped) rows.SignalEventQuery.AggregationQuery
maxSignalCode()
Adds a result columnMaxSignalCode
to the query, that contains the maximum value of the fieldSignalCode
of all (grouped) rows.SignalEventQuery.AggregationQuery
maxSignalEventId()
Adds a result columnMaxSignalEventId
to the query, that contains the maximum value of the fieldSignalEventId
of all (grouped) rows.SignalEventQuery.AggregationQuery
minSentByProcessElementPid()
Adds a result columnMinSentByProcessElementPid
to the query, that contains the minimum value of the fieldSentByProcessElementPid
of all (grouped) rows.SignalEventQuery.AggregationQuery
minSentByUserName()
Adds a result columnMinSentByUserName
to the query, that contains the minimum value of the fieldSentByUserName
of all (grouped) rows.SignalEventQuery.AggregationQuery
minSentTimestamp()
Adds a result columnMinSentTimestamp
to the query, that contains the minimum value of the fieldSentTimestamp
of all (grouped) rows.SignalEventQuery.AggregationQuery
minSignalCode()
Adds a result columnMinSignalCode
to the query, that contains the minimum value of the fieldSignalCode
of all (grouped) rows.SignalEventQuery.AggregationQuery
minSignalEventId()
Adds a result columnMinSignalEventId
to the query, that contains the minimum value of the fieldSignalEventId
of all (grouped) rows.
-
-
-
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 interfaceSignalEventQuery.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 fieldSignalEventId
of all (grouped) rows.SQL part:
MIN(SignalEventId) AS MinSignalEventId
- Specified by:
minSignalEventId
in interfaceSignalEventQuery.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 fieldSignalEventId
of all (grouped) rows.SQL part:
MAX(SignalEventId) AS MaxSignalEventId
- Specified by:
maxSignalEventId
in interfaceSignalEventQuery.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 fieldSignalCode
of all (grouped) rows.SQL part:
MIN(SignalCode) AS MinSignalCode
- Specified by:
minSignalCode
in interfaceSignalEventQuery.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 fieldSignalCode
of all (grouped) rows.SQL part:
MAX(SignalCode) AS MaxSignalCode
- Specified by:
maxSignalCode
in interfaceSignalEventQuery.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 fieldSentTimestamp
of all (grouped) rows.SQL part:
AVG(SentTimestamp) AS AvgSentTimestamp
- Specified by:
avgSentTimestamp
in interfaceSignalEventQuery.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 fieldSentTimestamp
of all (grouped) rows.SQL part:
MIN(SentTimestamp) AS MinSentTimestamp
- Specified by:
minSentTimestamp
in interfaceSignalEventQuery.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 fieldSentTimestamp
of all (grouped) rows.SQL part:
MAX(SentTimestamp) AS MaxSentTimestamp
- Specified by:
maxSentTimestamp
in interfaceSignalEventQuery.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 fieldSentByUserName
of all (grouped) rows.SQL part:
MIN(SentByUserName) AS MinSentByUserName
- Specified by:
minSentByUserName
in interfaceSignalEventQuery.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 fieldSentByUserName
of all (grouped) rows.SQL part:
MAX(SentByUserName) AS MaxSentByUserName
- Specified by:
maxSentByUserName
in interfaceSignalEventQuery.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 fieldSentByProcessElementPid
of all (grouped) rows.SQL part:
MIN(SentByProcessElementPid) AS MinSentByProcessElementPid
- Specified by:
minSentByProcessElementPid
in interfaceSignalEventQuery.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 fieldSentByProcessElementPid
of all (grouped) rows.SQL part:
MAX(SentByProcessElementPid) AS MaxSentByProcessElementPid
- Specified by:
maxSentByProcessElementPid
in interfaceSignalEventQuery.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.
-
-