Search.../

WixDataAggregate

Provides functionality for performing aggregations on collection data. Learn more.

Guides

Additional information about this section

Functions

Perform actions on an object

  • ascending( )

    Adds a sort to an aggregation, sorting by the items or groups by the specified properties in ascending order.

  • avg( )

    Refines a WixDataAggregate to only contain the average value from each aggregation group.

  • count( )

    Refines a WixDataAggregate to contain the item count of each group in the aggregation.

  • descending( )

    Adds a sort to an aggregation, sorting by the items or groups by the specified properties in descending order.

  • filter( )

    Filters out items from being used in an aggregation.

  • group( )

    Groups items together in an aggregation.

  • having( )

    Filters out groups from being returned from an aggregation.

  • limit( )

    Limits the number of items or groups the aggregation returns.

  • max( )

    Refines a WixDataAggregate to only contain the maximum value from each aggregation group.

  • min( )

    Refines a WixDataAggregate to only contain the minimum value from each aggregation group.

  • run( )

    Runs the aggregation and returns the results.

  • skip( )

    Sets the number of items or groups to skip before returning aggregation results.

  • sum( )

    Refines a WixDataAggregate to contain the sum from each aggregation group.