Aggregate Functions

  • Updated


Operate across collection items to return aggregate values.

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

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.

Sum

Returns the sum of a specified member or expression across a collection.

ToList

Returns a list object from a collection.

Was this article helpful?

0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.