# Get Distinct value in Elastic App Search

**URL:** <https://discuss.elastic.co/t/get-distinct-value-in-elastic-app-search/245291>\
**Category:** Elastic Search\
**Tags:** elastic-app-search\
**Created:** [August 17, 2020, 5:30pm UTC](https://discuss.elastic.co/t/get-distinct-value-in-elastic-app-search/245291 "2020-08-17T17:30:49Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![DILIP\_SHARMA](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dilip_sharma/32/42672_2.png) [@DILIP\_SHARMA](https://discuss.elastic.co/u/DILIP_SHARMA)\
**Post date:** [August 17, 2020, 5:30pm UTC](https://discuss.elastic.co/t/get-distinct-value-in-elastic-app-search/245291/1 "2020-08-17T17:30:49Z")

</div>

Hi  
i am using Elastic Enterprise Search for searching document , where i have requirement where i want to get distinct value of 1 field -  
for example i want to get distinct brand name available in my engine .  
this is my simple search request

```
{

    "query": "coke",

    "result_fields": {

        "brand": {

            "raw": {},

            "snippet": {

                "size": 100,

                "fallback": true

            }

        }

    }

}

```

but this will give all the record , i know how to get distinct value in Elasticsearch , but am not sure is same is possible in App Search .  
Thanks

---

<div class="post-metadata">

**Author:** ![JasonStoltz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jasonstoltz/32/49893_2.png) [@JasonStoltz](https://discuss.elastic.co/u/JasonStoltz)\
**Post date:** [August 18, 2020, 11:20am UTC](https://discuss.elastic.co/t/get-distinct-value-in-elastic-app-search/245291/2 "2020-08-18T11:20:52Z")

</div>

Hey @DILIP_SHARMA,

Can you give me an example of what results you were expecting to see? Were you expecting to see a list of distinct brand names?

Jason

---

<div class="post-metadata">

**Author:** ![DILIP\_SHARMA](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dilip_sharma/32/42672_2.png) [@DILIP\_SHARMA](https://discuss.elastic.co/u/DILIP_SHARMA)\
**Post date:** [August 18, 2020, 11:44am UTC](https://discuss.elastic.co/t/get-distinct-value-in-elastic-app-search/245291/3 "2020-08-18T11:44:48Z")

</div>

Hi @JasonStoltz

Yes ,  
For example if my search engine have thise record

| Brand | ItemCode | ItemDescription |
| --- | --- | --- |
| Coke | I1 | Coke 200 ml |
| Coke | I2 | Coke 1.2 ltr |
| Thumsup | I3 | Thumsup 500 ltr |
| Thumsup | i4 | Thumsup 1 ltr |
| Fenta | i5 | fenta 200 ml |

**so i want result**  
coke  
Thumsup  
Fenta

thanks

---

<div class="post-metadata">

**Author:** ![JasonStoltz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jasonstoltz/32/49893_2.png) [@JasonStoltz](https://discuss.elastic.co/u/JasonStoltz)\
**Post date:** [August 18, 2020, 12:15pm UTC](https://discuss.elastic.co/t/get-distinct-value-in-elastic-app-search/245291/4 "2020-08-18T12:15:20Z")

</div>

I understand. I think Facets are the solution you are looking for: [https://www.elastic.co/guide/en/app-search/7.8/facets.html#facets-value-facet](https://www.elastic.co/guide/en/app-search/7.8/facets.html#facets-value-facet).

---

<div class="post-metadata">

**Author:** ![DILIP\_SHARMA](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dilip_sharma/32/42672_2.png) [@DILIP\_SHARMA](https://discuss.elastic.co/u/DILIP_SHARMA)\
**Post date:** [August 18, 2020, 5:58pm UTC](https://discuss.elastic.co/t/get-distinct-value-in-elastic-app-search/245291/5 "2020-08-18T17:58:23Z")

</div>

i have looked the facet , yes not thought before but yes may be its can serve the desire input . Thanks

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 15, 2020, 5:58pm UTC](https://discuss.elastic.co/t/get-distinct-value-in-elastic-app-search/245291/6 "2020-09-15T17:58:31Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.