First

filter category: filter no `||` resultSize: 1

Passes through only the records with the lowest ordering value within each group.

First is a source-table filter rule. It groups source records by one set of fields and, within each group, lets through the single record with the smallest value across a second set of ordering fields.

Parameters

1 — group Mandatory — accepts: array of fields (@table:field notation)

Defines how the source records must be grouped. All records that share the same values for every field in this array belong to the same group.

2 — order Mandatory — accepts: array of fields (@table:field notation)

Defines how to select the first value within each group. The record with the lowest collective value across these fields is the one passed through.

Requires

• All referenced fields must exist on the source table.

Examples

First([:person_id],[:move_date])

See also

Last