Collection Functions

  • Updated

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.



Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.