Introduction

When you execute an aggregation with the run() function, it returns a Promise that resolves to a WixDataAggregateResult object, which contains the aggregated values.

Did this help?

items

itemsArray<object>Read-only

Gets the aggregated values.

The current page of items retrieved by the aggregation.

The page size is defined by the limit() function and navigating through pages is done with the next() function.

When no items match the aggregation, the items array is empty.

JavaScript
let items = results.items;
Did this help?

length

lengthnumberRead-only

Returns the number of values in the aggregate results.

JavaScript
let length = results.length; // 4
Did this help?

hasNext( )

Indicates if the aggregation has more results.

Method Declaration
Copy
function hasNext(): boolean;
Request
This method does not take any parameters
Returns
Return Type:boolean
JavaScript
let hasNext = results.hasNext(); // true
Did this help?

next( )

Retrieves the next page of aggregate results.

The next() function retrieves the next page of aggregate results.

The page size is defined by the limit() function.

If items are added or removed between calls to next() the values returned by WixDataAggregateResult may change.

Method Declaration
Copy
function next(): Promise<WixDataAggregateResult>;
Request
This method does not take any parameters
Returns
Return Type:Promise<WixDataAggregateResult>
JavaScript
oldResults
  .next()
  .then((newResults) => {
    let items = newResults.items;
    let numItems = newResults.length;
    let hasNext = newResults.hasNext();
  })
  .catch((error) => {
    let errorMsg = error.message;
    let code = error.code;
  });
Did this help?