Collection Functions
Return values from a collection based on a filter.
| Collection Function | Description |
|---|---|
| Average | Returns the average of a specified field or expression across a collection. |
| Avg | Returns the average of a specified field or expression across a collection. |
| CollectionLookup | The CollectionLooup function returns the value of a field or expression for the first collection member that satisfies a given filter expression. |
| Count | The Count function returns the number of members in a collection. |
| Current | Returns the value of a field within the context of current expression. |
| CurrentContext | Returns the value of a field within the context of current expression. |
| GetFirst | The GetFirst function returns the first collection member that satisfies a given filter expression. |
| GetFirstValue | Returns the specified field value of first member of collection which can be sorted and filtered. In case of failed lookup, a default value must be specified. |
| GetLast | The GetLast function returns the last collection member that satisfies a given filter expression. |
| GetLastValue | Returns the specified field value of last member of collection which can be sorted and filtered. In case of failed lookup, a default value must be specified. |
| GetMember | Returns the first member that matches the filter criteria. |
| GetMemberByIndex | Returns the member at an index in a collection which can be ordered and filtered using filter expression. |
| GetMemberValue | The GetMemberValue function returns the specified field value of the first collection member that satisfies a given filter criteria. |
| GetMemberValueByIndex | Returns the specified field value of member at an index in collection which can be ordered and filtered using filter expression. |
| Max | Returns largest value of a member field or expression across a collection. |
| Min | Returns smallest value of a member field or expression across a collection. |
| Outer | Returns the value of a field within the outer context of an aggregate expression. |
| OuterContext | Returns the value of a field within the outer context of an aggregate expression. |
| Sum | Returns the sum of a specified member or expression across a collection. |