ReferenceSQL ReferenceAggregate Functions

sequenceMatch

Checks whether the sequence of events, ordered by the timestamp argument, contains a chain of events matching the given pattern.

Checks whether the sequence of events, ordered by the timestamp argument, contains a chain of events matching the given pattern.

sequenceCount

Counts the number of non-overlapping chains of events, ordered by the timestamp argument, that match the given pattern.

sequenceMatchEvents

A variant of sequenceMatch that returns information about the events that matched the given pattern.