Interface SignalEventQuery.IAggregationQuery
- All Known Implementing Classes:
SignalEventQuery.AggregationQuery
- Enclosing class:
- SignalEventQuery
- API:
- This is a public API.
-
Method Summary
Modifier and TypeMethodDescriptionAdds a result columnAvgSentByUserId
to the query, that contains the average of the fieldSentByUserId
of all (grouped) rows.Adds a result columnAvgSentTimestamp
to the query, that contains the average of the fieldSentTimestamp
of all (grouped) rows.Adds a result columnCount
to the query, that contains the number of (grouped) rows.Adds a result columnMaxSentByProcessElementPid
to the query, that contains the maximum value of the fieldSentByProcessElementPid
of all (grouped) rows.Adds a result columnMaxSentByUserId
to the query, that contains the maximum value of the fieldSentByUserId
of all (grouped) rows.Adds a result columnMaxSentByUserName
to the query, that contains the maximum value of the fieldSentByUserName
of all (grouped) rows.Adds a result columnMaxSentTimestamp
to the query, that contains the maximum value of the fieldSentTimestamp
of all (grouped) rows.Adds a result columnMaxSignalCode
to the query, that contains the maximum value of the fieldSignalCode
of all (grouped) rows.Adds a result columnMaxSignalEventId
to the query, that contains the maximum value of the fieldSignalEventId
of all (grouped) rows.Adds a result columnMinSentByProcessElementPid
to the query, that contains the minimum value of the fieldSentByProcessElementPid
of all (grouped) rows.Adds a result columnMinSentByUserId
to the query, that contains the minimum value of the fieldSentByUserId
of all (grouped) rows.Adds a result columnMinSentByUserName
to the query, that contains the minimum value of the fieldSentByUserName
of all (grouped) rows.Adds a result columnMinSentTimestamp
to the query, that contains the minimum value of the fieldSentTimestamp
of all (grouped) rows.Adds a result columnMinSignalCode
to the query, that contains the minimum value of the fieldSignalCode
of all (grouped) rows.Adds a result columnMinSignalEventId
to the query, that contains the minimum value of the fieldSignalEventId
of all (grouped) rows.Adds a result columnSumSentByUserId
to the query, that contains the sum of the fieldSentByUserId
of all (grouped) rows.
-
Method Details
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
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 Java.
-
sumSentByUserId
SignalEventQuery.AggregationQuery sumSentByUserId()Adds a result column
SumSentByUserId
to the query, that contains the sum of the fieldSentByUserId
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 referencedUser
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
avgSentByUserId
SignalEventQuery.AggregationQuery avgSentByUserId()Adds a result column
AvgSentByUserId
to the query, that contains the average of the fieldSentByUserId
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 referencedUser
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
minSentByUserId
SignalEventQuery.AggregationQuery minSentByUserId()Adds a result column
MinSentByUserId
to the query, that contains the minimum value of the fieldSentByUserId
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 referencedUser
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
maxSentByUserId
SignalEventQuery.AggregationQuery maxSentByUserId()Adds a result column
MaxSentByUserId
to the query, that contains the maximum value of the fieldSentByUserId
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 referencedUser
.- Returns:
- query for further composition
- API:
- This public API is available in Java.
-
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 Java.
-
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 Java.
-