# Search latest events and unique by field

**URL:** <https://discuss.elastic.co/t/search-latest-events-and-unique-by-field/244199>\
**Category:** Elasticsearch\
**Created:** [August 7, 2020, 4:16pm UTC](https://discuss.elastic.co/t/search-latest-events-and-unique-by-field/244199 "2020-08-07T16:16:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dikkini](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dikkini/32/71958_2.png) [@dikkini](https://discuss.elastic.co/u/dikkini)\
**Post date:** [August 7, 2020, 4:16pm UTC](https://discuss.elastic.co/t/search-latest-events-and-unique-by-field/244199/1 "2020-08-07T16:16:46Z")

</div>

Hello.

I got the following data in my indice:

```json
{"username": "michael", "is_vac": true, "created_date": 1596647898006}
{"username": "kate", "is_vac": true, "created_date": 1596647898007}
{"username": "michael", "is_vac": true, "created_date": 1596647898016}
{"username": "kate", "is_vac": true, "created_date": 1596647898017}

```

I want to search and get latest documents (by field `created_date` - it is unixtime with milliseconds) and unique (distinct) by field `username`.

In this case i want to see the following result:

```json
{"username": "michael", "is_vac": true, "created_date": 1596647898016}
{"username": "kate", "is_vac": true, "created_date": 1596647898017}

```

Unique usernames (`michael` and `kate`) and latest documents:  
in `michael` case: `1596647898016 > 1596647898006`  
in `kate` case: `1596647898017 > 1596647898007`

Example #2. Dataset:

```json
{"username": "jonh", "is_vac": true, "created_date": 1596647898001}
{"username": "michael", "is_vac": true, "created_date": 1596647898001}
{"username": "kate", "is_vac": true, "created_date": 1596647898002}
{"username": "michael", "is_vac": true, "created_date": 1596647898006}
{"username": "kate", "is_vac": true, "created_date": 1596647898007}
{"username": "michael", "is_vac": true, "created_date": 1596647898016}
{"username": "kate", "is_vac": true, "created_date": 1596647898017}
{"username": "kate", "is_vac": true, "created_date": 1596647898027}

```

Desireable search result:

```json
{"username": "jonh", "is_vac": true, "created_date": 1596647898001}
{"username": "michael", "is_vac": true, "created_date": 1596647898016}
{"username": "kate", "is_vac": true, "created_date": 1596647898027}

```

How i can achieve this?

---

<div class="post-metadata">

**Author:** ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)\
**Post date:** [August 12, 2020, 9:56am UTC](https://discuss.elastic.co/t/search-latest-events-and-unique-by-field/244199/2 "2020-08-12T09:56:44Z")

</div>

Check out [collapsing search results](https://www.elastic.co/guide/en/elasticsearch/reference/7.8/collapse-search-results.html)

---

<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 9, 2020, 9:56am UTC](https://discuss.elastic.co/t/search-latest-events-and-unique-by-field/244199/3 "2020-09-09T09:56:45Z")

</div>

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