Skip to main content



GetMemberByIndex Function

Returns the member at an index in a collection which can be ordered and filtered using filter expression.

Syntax 1

GetMemberByIndex(collection, index)

Returns the member at an index in a collection which can be ordered and filtered using filter expression.

Arguments

collection Collection - A collection.

index Integer - The index of the member to return.

Syntax 2

GetMemberByIndex(collection, index, orderby)

Returns the member at an index in a collection which can be ordered and filtered using filter expression.

Arguments

collection Collection - A collection.

index Integer - The index of the member to return.

orderby SortExpression - Field to order by.

Syntax 3

GetMemberByIndex(collection, index, orderby, filter)

Returns the member at an index in a collection which can be ordered and filtered using filter expression.

Arguments

collection Collection - A collection.

index Integer - The index of the member to return.

orderby SortExpression - Field to order by.

filter FilterExpression - A filter expression.

Remarks

Example:

GetMemberByIndex(LineItems, 2); 
// returns {Record::1}\LineItems[2]

Example:

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

Example:

GetMemberByIndex(LineItems, 2, ProductID, Quantity > 10); 
// returns {Record::1}\LineItems[9]