# Unique return like GROUP BY

**URL:** <https://discuss.elastic.co/t/unique-return-like-group-by/135537>\
**Category:** Elasticsearch\
**Created:** [June 12, 2018, 12:41pm UTC](https://discuss.elastic.co/t/unique-return-like-group-by/135537 "2018-06-12T12:41:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Stephan\_Daratha](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephan_daratha/32/32177_2.png) [@Stephan\_Daratha](https://discuss.elastic.co/u/Stephan_Daratha)\
**Post date:** [June 12, 2018, 12:41pm UTC](https://discuss.elastic.co/t/unique-return-like-group-by/135537/1 "2018-06-12T12:41:51Z")

</div>

Hi there,

I thought it would be easy. But I failed.

We have an index with objects like

{'objectNumber: '123', 'persons':4, 'uniqueKey': 'abc'}  
{'objectNumber: '456', 'persons':2, 'uniqueKey': 'def'}  
{'objectNumber: '789', 'persons':6, 'uniqueKey': 'abc'}

My problem is that if I query objects where persons gte: 4 I will get 2 results.  
Is it possible that I only get one object per uniqueKey?

If I change the query to gte: 2 persons I want 2 hits.

How is that possible?

---

<div class="post-metadata">

**Author:** ![klof](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/klof/32/31590_2.png) [@klof](https://discuss.elastic.co/u/klof)\
**Post date:** [June 12, 2018, 1:56pm UTC](https://discuss.elastic.co/t/unique-return-like-group-by/135537/2 "2018-06-12T13:56:33Z")

</div>

You could use field collapsing and collapse on field `uniqueKey`

[https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-collapse.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-collapse.html)

---

<div class="post-metadata">

**Author:** ![Stephan\_Daratha](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephan_daratha/32/32177_2.png) [@Stephan\_Daratha](https://discuss.elastic.co/u/Stephan_Daratha)\
**Post date:** [June 12, 2018, 2:32pm UTC](https://discuss.elastic.co/t/unique-return-like-group-by/135537/3 "2018-06-12T14:32:17Z")

</div>

That is perfect. Thank you for your advice

---

<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:** [July 10, 2018, 2:32pm UTC](https://discuss.elastic.co/t/unique-return-like-group-by/135537/4 "2018-07-10T14:32:22Z")

</div>

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