# Nested query max value

**URL:** <https://discuss.elastic.co/t/nested-query-max-value/263569>\
**Category:** Elasticsearch\
**Created:** [February 8, 2021, 9:55am UTC](https://discuss.elastic.co/t/nested-query-max-value/263569 "2021-02-08T09:55:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sivanzakay](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sivanzakay/32/83562_2.png) [@sivanzakay](https://discuss.elastic.co/u/sivanzakay)\
**Post date:** [February 8, 2021, 9:55am UTC](https://discuss.elastic.co/t/nested-query-max-value/263569/1 "2021-02-08T09:55:47Z")

</div>

For a set of documents like this:

{  
"took" : 1,  
"timed\_out" : false,  
"\_shards" : {  
"total" : 1,  
"successful" : 1,  
"skipped" : 0,  
"failed" : 0  
},  
"hits" : {  
"total" : {  
"value" : 3,  
"relation" : "eq"  
},  
"max\_score" : 1.0,  
"hits" : [  
{  
"\_index" : "drivers",  
"\_type" : "\_doc",  
"\_id" : "1",  
"\_score" : 1.0,  
"\_source" : {  
"driver" : {  
"last\_name" : "McQueen",  
"vehicle" : [  
{  
"make" : "Powell Motors",  
"model" : "Canyonero",  
"grade" : 23  
},  
{  
"make" : "Miller-Meteor",  
"model" : "Ecto-2",  
"grade" : 2  
}  
]  
}  
}  
},  
{  
"\_index" : "drivers",  
"\_type" : "\_doc",  
"\_id" : "2",  
"\_score" : 1.0,  
"\_source" : {  
"driver" : {  
"last\_name" : "McQueen",  
"vehicle" : [  
{  
"make" : "Powell Motors",  
"model" : "Canyonero",  
"grade" : 1  
},  
{  
"make" : "Miller-Meteor",  
"model" : "Ecto-1",  
"grade" : 100  
}  
]  
}  
}  
},  
{  
"\_index" : "drivers",  
"\_type" : "\_doc",  
"\_id" : "3",  
"\_score" : 1.0,  
"\_source" : {  
"driver" : {  
"last\_name" : "McQueen",  
"vehicle" : [  
{  
"make" : "Powell Motors",  
"model" : "Canyonero",  
"grade" : 72  
},  
{  
"make" : "Miller-Meteor",  
"model" : "Ecto-1",  
"grade" : 46  
}  
]  
}  
}  
}  
]  
}  
}

How do I get all documents that field driver.vehicle.make "Powell Motors" has the max grade in the array ? (It should return only doc 1 and doc 3)  
I would like it will be executed in one query

---

<div class="post-metadata">

**Author:** ![sivanzakay](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sivanzakay/32/83562_2.png) [@sivanzakay](https://discuss.elastic.co/u/sivanzakay)\
**Post date:** [February 10, 2021, 10:04am UTC](https://discuss.elastic.co/t/nested-query-max-value/263569/3 "2021-02-10T10:04:15Z")

</div>

Clear structure:

**doc 1 :**

```
"driver": {
  "last_name": "McQueen",
  "vehicle": [
    {
      "make": "Powell Motors",
      "model": "Canyonero",
      "grade": 23
    },
    {
      "make": "Miller-Meteor",
      "model": "Ecto-1",
      "grade": 2
    }
  ]
}

```

**doc 2 :**

```
 "driver": {
  "last_name": "McQueen",
  "vehicle": [
    {
      "make": "Powell Motors",
      "model": "Canyonero",
      "grade": 1
    },
    {
      "make": "Miller-Meteor",
      "model": "Ecto-1",
      "grade": 100
    }
  ]
}

```

**doc 3 :**

```
"driver": {
"last_name": "McQueen",
"vehicle": [
  {
    "make": "Powell Motors",
    "model": "Canyonero",
    "grade": 72
  },
  {
    "make": "Miller-Meteor",
    "model": "Ecto-1",
    "grade": 46
  }
]}
```

---

<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:** [March 10, 2021, 10:04am UTC](https://discuss.elastic.co/t/nested-query-max-value/263569/4 "2021-03-10T10:04:27Z")

</div>

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