# Querying the latest versions of your document

**URL:** <https://discuss.elastic.co/t/querying-the-latest-versions-of-your-document/147453>\
**Category:** Elasticsearch\
**Created:** [September 5, 2018, 5:29pm UTC](https://discuss.elastic.co/t/querying-the-latest-versions-of-your-document/147453 "2018-09-05T17:29:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ndaeae](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ndaeae/32/35227_2.png) [@ndaeae](https://discuss.elastic.co/u/ndaeae)\
**Post date:** [September 5, 2018, 5:29pm UTC](https://discuss.elastic.co/t/querying-the-latest-versions-of-your-document/147453/1 "2018-09-05T17:29:04Z")

</div>

Lets say I have 3 documents

- Doc A
- Doc B
- Doc C

and each document is versioned by timeStamp. The Documents will follow this schema:

```
id: uniqueID
title: DocA, DocB, DocC, etc...
timeStamp: date
documentContents: text

```

How would I query in a way such that I query only the latest document (defined by timestamp) for each unique title?

So I might want documents which contain the word "dog" but DocA and DocB might have it in multiple versions. The query will return every version of DocA and DocB which contains "dog".

I only want the search result to return only the latest versions of DocA and DocB.

---

<div class="post-metadata">

**Author:** ![abdon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/abdon/32/9195_2.png) [@abdon](https://discuss.elastic.co/u/abdon)\
**Post date:** [September 7, 2018, 8:40am UTC](https://discuss.elastic.co/t/querying-the-latest-versions-of-your-document/147453/2 "2018-09-07T08:40:09Z")

</div>

Take a look at [field collapsing](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-request-collapse.html). This would allow you to sort the results on the timestamp, and only return the most recent version of a document, when collapsing on the title field.

---

<div class="post-metadata">

**Author:** ![ndaeae](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ndaeae/32/35227_2.png) [@ndaeae](https://discuss.elastic.co/u/ndaeae)\
**Post date:** [September 7, 2018, 12:08pm UTC](https://discuss.elastic.co/t/querying-the-latest-versions-of-your-document/147453/3 "2018-09-07T12:08:17Z")

</div>

that's amazing. Thank you very much.

---

<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:** [October 5, 2018, 12:08pm UTC](https://discuss.elastic.co/t/querying-the-latest-versions-of-your-document/147453/4 "2018-10-05T12:08:21Z")

</div>

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