> Portal Navigation:
> 
> - Append `.md` to any URL under `https://dev.wix.com/docs/` to get its markdown version.
> - Pages are either content pages (article or reference text) or menu pages (a list of links to child pages).
> - To get a menu page, truncate any URL to a parent path and append `.md` (e.g. `https://dev.wix.com/docs/sdk.md`, `https://dev.wix.com/docs/sdk/core-modules.md`).
> - Top-level index of all portals: https://dev.wix.com/docs/llms.txt
> - Full concatenated docs: https://dev.wix.com/docs/llms-full.txt

# Method name: having(filter: WixDataFilter)

# Method package: wixData

# Method menu location: wixData --> WixDataAggregate --> having

# Method Link: https://dev.wix.com/docs/velo/apis/wix-data/wix-data-aggregate/having.md

# Method Description:

Filters out groups from being returned from an aggregation.

The `having()` function refines a `WixDataAggregate` so that it only
 includes groups from the aggregate's grouping which match the specified
 filter criteria.

 To create a filter, use the wix-data [`filter()`](wix-data.html#filter) function.

 Filtering using `having()` takes place after grouping is performed on the
 aggregation. To filter items before grouping, use the [`filter()`](#filter) function.
 > **Note:** Aggregations can only be used on collections you have created. They cannot be
 used on [Wix App Collections](https://support.wix.com/en/article/cms-formerly-content-manager-working-with-wix-app-collections).



# Method Code Examples:

*** Note: do not assume any prop names or enum values other than the ones in the example.

## Filter out groups in an aggregation

```javascript
let having = wixData.filter().gt("maxPopulation", 1000000);

let newAggregate = aggregate.having(having);
```

## Filter out groups in an aggregation and run the aggregation

```javascript
import wixData from 'wix-data';

// ...

let having = wixData.filter().gt("maxPopulation", 1000000);

wixData.aggregate("PopulationData")
  .group("city", "state")
  .max("population", "maxPopulation")
  .having(having)
  .run()
  .then((results) => {
    if (results.items.length > 0) {
      let items = results.items;        // see below
      let numItems = results.length;    // 3
      let hasNext = results.hasNext();  // false
    } else {
      // handle case where no matching items found
    }
  })
  .catch((error) => {
    let errorMsg = error.message;
    let code = error.code;
  });

/* Given the sample data above, items is:
 * [
 *   {
 *     "_id": {"city": "San Diego", "state": "CA"},
 *     "maxPopulation": 1306000,
 *     "city": "San Diego",
 *     "state": "CA"
 *   }, {
 *     "_id": {"city": "New York", "state": "NY"},
 *     "maxPopulation": 8192000,
 *     "city": "New York",
 *     "state": "NY"
 *   }, {
 *     "_id": {"city": "Los Angeles", "state": "CA"},
 *     "maxPopulation": 3796000,
 *     "city": "Los Angeles",
 *     "state": "CA"
 *   }
 * ]
 */
```

## Create an aggregation with filtering and grouping and run it

```javascript
import wixData from 'wix-data';

// ...

const filter = wixData.filter().eq("year", 2010);
const having = wixData.filter().gt("maxPopulation", 1000000);

wixData.aggregate("PopulationData")
  .filter(filter)
  .group("state")
  .max("population", "maxPopulation")
  .having(having)
  .descending("maxPopulation")
  .skip(5)
  .limit(3)
  .run()
  .then((results) => {
    if (results.items.length > 0) {
      let items = results.items;
      let numItems = results.length;
      let hasNext = results.hasNext();
    } else {
      // handle case where no matching items found
    }
  })
  .catch((error) => {
    let errorMsg = error.message;
    let code = error.code;
  });
```

---