Skip to main content



GetMemberValue Function

The GetMemberValue function returns the specified field value of the first collection member that satisfies a given filter criteria.

Syntax

GetMemberValue(collection, returnField, defaultReturnValue, filter)

The GetMemberValue function returns the specified field value of the first collection member that satisfies a given filter criteria.

Arguments

collection Collection - A collection.

returnField Field - Member field with the value to return.

defaultReturnValue Any - Default return value if no collection member satisfies the filter.

filter FilterExpression - The filter criteria.

Remarks

  • Example:

GetMemberValue(LineItems, ProductName, "No Large Quantity", Quantity > 12 returns "ProductX".