Reference to the firstEnding() and lastEnding() functions

Summary

firstEnding(<eventsExpression>)
lastEnding(<eventsExpression>)

The firstEnding() function returns the event that ends earliest, from among the specified set of events.

The lastEnding() function returns the event that ends latest, from among the specified set of events.

Parameters

ParameterDescription
eventExpression Expression that describes the events from which to select the event to be returned.

Description

The firstEnding() event function inspects the specified event set, and returns the single event that has the earliest end time.

The lastEnding() event function inspects the specified event set, and returns the single event that has the latest end time.

Note: If multiple events match the condition, the result is non-deterministic. Each of these functions always returns just one event, although a different event might be returned if you run the query again with the same event set.

See Also