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