Built-in Functions → Filter Functions

These functions are used to filter data to those items before or after a specified date. It is also possible to filter the data in groups.

FunctionSignatureDescription
firstVersion()firstVersion(<type> value, <type> group_by, date order_by)Returns the first occurrence of a value with respect to a order_by
lastVersion()lastVersion(<type> value, <type> group_by, date order_by)Returns the last occurrence of a value with respect to a order_by