GetLast Function

The GetLast function returns the last collection member that satisfies a given filter expression.

Syntax 1

GetLast(collection)

The GetLast function returns the last collection member that satisfies a given filter expression.

Arguments

collection Collection - A collection.

Syntax 2

GetLast(collection, orderby)

The GetLast function returns the last collection member that satisfies a given filter expression.

Arguments

collection Collection - A collection.

orderby SortExpression - Field or expression to order by.

Syntax 3

GetLast(collection, orderby, filter)

The GetLast function returns the last collection member that satisfies a given filter expression.

Arguments

collection Collection - A collection.

orderby SortExpression - Field or expression to order by.

filter FilterExpression - The filter criteria.

Remarks

Example:

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

Example:

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

Example:

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