GetFirst Function

The GetFirst function returns the first collection member that satisfies a given filter expression.

Syntax 1

GetFirst(collection)

The GetFirst function returns the first collection member that satisfies a given filter expression.

Arguments

collection Collection - A collection.

Syntax 2

GetFirst(collection, orderby)

The GetFirst function returns the first collection member that satisfies a given filter expression.

Arguments

collection Collection - A collection.

orderby SortExpression - Field to order by.

Syntax 3

GetFirst(collection, orderby, filter)

The GetFirst function returns the first collection member that satisfies a given filter expression.

Arguments

collection Collection - A collection.

orderby SortExpression - Field to order by.

filter FilterExpression - A filter expression.

Remarks

Example:

GetFirst(LineItems); // returns {Record::1}\LineItems[1].

Example:

GetFirst(LineItems, ProductID); // returns {Record::1}\LineItems[7].

Example:

GetFirst(LineItems, ProductID, Quantity > 10); // returns {Record::1}\LineItems[8].