Interface SignalEventQuery.IAggregationQuery
-
- All Known Implementing Classes:
SignalEventQuery.AggregationQuery
- Enclosing class:
- SignalEventQuery
public static interface SignalEventQuery.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
All Methods Instance Methods Abstract 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
SignalEventQuery.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.
-
minSignalEventId
SignalEventQuery.AggregationQuery minSignalEventId()
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
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxSignalEventId
SignalEventQuery.AggregationQuery maxSignalEventId()
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
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minSignalCode
SignalEventQuery.AggregationQuery minSignalCode()
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
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxSignalCode
SignalEventQuery.AggregationQuery maxSignalCode()
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
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
avgSentTimestamp
SignalEventQuery.AggregationQuery avgSentTimestamp()
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
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minSentTimestamp
SignalEventQuery.AggregationQuery minSentTimestamp()
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
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxSentTimestamp
SignalEventQuery.AggregationQuery maxSentTimestamp()
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
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minSentByUserName
SignalEventQuery.AggregationQuery minSentByUserName()
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
This is a virtual column. It contains the same value as the column
Name
of the referencedSecurityMember
.- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxSentByUserName
SignalEventQuery.AggregationQuery maxSentByUserName()
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
This is a virtual column. It contains the same value as the column
Name
of the referencedSecurityMember
.- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
minSentByProcessElementPid
SignalEventQuery.AggregationQuery minSentByProcessElementPid()
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
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
maxSentByProcessElementPid
SignalEventQuery.AggregationQuery maxSentByProcessElementPid()
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
- Returns:
- query for further composition
- API:
- This public API is available in IvyScript and Java. It has the visibility EXPERT.
-
-