> For the complete documentation index, see [llms.txt](https://solr-express.gitbook.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://solr-express.gitbook.io/docs/5.0.0/tutorials/facets/query.md).

# Facet query

## Feature

Create a facet query

## How to

1. Configure facet

```csharp
    DocumentCollection<TechProductDocument> documentCollection; // from DI

    var rersult = documentCollection
        .Select()
        .FacetQuery("AliasName", q => q.Field(f => f.Features))
        .Execute();
```

1. Optionally, change one or more settings

```csharp
    DocumentCollection<TechProductDocument> documentCollection; // from DI

    var rersult = documentCollection
        .Select()
        .FacetQuery("AliasName", q => q.Field(f => f.Features), facet =>
        {
            facet.Minimum = 3;
            facet.Limit = 5;
        })
        .Execute();
```

1. Read data

```csharp
    rersult
        .Facets(out var data);

    foreach (FacetItemField facetItem in data)
    {
        // facetName = "InStock" or some alias (if configured)
        var facetName = facetItem.Name;
        //facetType = FacetType.Field
        var facetType = facetItem.FacetType;

        foreach (FacetItemQuery facetItem in data)
        {
            // facetName = "AliasName"
            var facetName = facetItem.Name;
            //facetType = FacetType.Query
            var facetType = facetItem.FacetType;
            // nested = nested facet (if configured)
            var nested = facetItem.Facets;
            // quantity = quantity of item's value
            var quantity = facetItem.Quantity;
        }
    }
```

## Settings

| Use case                                     | How to                                                                                                       |
| -------------------------------------------- | ------------------------------------------------------------------------------------------------------------ |
| Sort type of result of facet                 | .FacetQuery("AliasName", q => q.Field(f => f.Features), facet => facet.SortType = FacetSortType.CountAsc)    |
| Minimum count of itens in facet's result     | .FacetQuery("AliasName", q => q.Field(f => f.Features), facet => facet.Minimum = 2)                          |
| Limit of itens in facet's result             | .FacetQuery("AliasName", q => q.Field(f => f.Features), facet => facet.Limit = 10)                           |
| List of tags to exclude in facet calculation | .FacetQuery("AliasName", q => q.Field(f => f.Features), facet => facet.Excludes = new\[] { "tag1", "tag2" }) |