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".