# Query: Till maximum value of a field

**URL:** <https://discuss.elastic.co/t/query-till-maximum-value-of-a-field/10011>\
**Category:** Elasticsearch\
**Created:** [December 10, 2012, 7:17am UTC](https://discuss.elastic.co/t/query-till-maximum-value-of-a-field/10011 "2012-12-10T07:17:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![karan](https://avatars.discourse-cdn.com/v4/letter/k/58f4c7/32.png) [@karan](https://discuss.elastic.co/u/karan)\
**Post date:** [December 10, 2012, 7:17am UTC](https://discuss.elastic.co/t/query-till-maximum-value-of-a-field/10011/1 "2012-12-10T07:17:27Z")

</div>

Hi,

My documents have a version field. Only updated documents will have a new record with an incremented version number.  
Example:  
{id:1 , version:1,…}  
{id:1 , version:2,….} //This has been updated  
{id:2 , version:1,…}

In the above example id=1 has two records as it has been updated. While id=2 has a single record as it hasn’t been updated and is still sitting on version 1.

Now in elastic search are there any queries that can get a maximum version.  
Example: Get unique documents TILL version 1 should give results:  
{id:1 , version:1,…}  
{id:2 , version:1,…}

While get unique documents till version 2 should give:  
{id:1 , version:2,….}  
{id:2 , version:1,…}

(in the above result there is a mix of version 1 and version 2)

Thanks,  
Karan

---

<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 6, 2017, 3:00am UTC](https://discuss.elastic.co/t/query-till-maximum-value-of-a-field/10011/2 "2017-07-06T03:00:37Z")

</div>