Package ch.ivyteam.ivy.workflow.query

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 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 field SignalEventId 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 field SignalEventId 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 field SignalCode 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 field SignalCode 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 field SentTimestamp 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 field SentTimestamp 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 field SentTimestamp 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 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.


      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 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.


      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 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.


      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 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.


      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 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.


      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 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.


      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 field SentByProcessElementPid 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 field SentByProcessElementPid of all (grouped) rows.

      SQL part: MAX(SentByProcessElementPid) AS MaxSentByProcessElementPid

      Returns:
      query for further composition
      API:
      This public API is available in Java.