# Elasticsearch Nested Queries

**URL:** https://discuss.elastic.co/t/elasticsearch-nested-queries/155274
**Category:** Elasticsearch
**Created:** [November 3, 2018, 9:14pm UTC](https://discuss.elastic.co/t/elasticsearch-nested-queries/155274 "2018-11-03T21:14:24Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![arosner](https://avatars.discourse-cdn.com/v4/letter/a/c67d28/32.png) [@arosner](https://discuss.elastic.co/u/arosner)
#### Post date: [November 3, 2018, 9:14pm UTC](https://discuss.elastic.co/t/elasticsearch-nested-queries/155274/1 "2018-11-03T21:14:25Z")

</div>

Complete newbie here.

I have some documents stored in ES, where each document looks like:  
{

```
    "_index": "index1",

    "_type": "type1",

    "_id": "1_1",
    
"_score": 2,

    "_source": {

      "agencyid": 1,

      "documentId": 1,

      "entityType": "entityType1",

      "documents": [

        {

          "DocumentId": 1,

          "DocumentType": "Dt1",

          "text": "This is DT1"

        }

      ],

      "minutesEntity": {

        "minutesID": 15,

        "CancelNotice": "CancelNotice1a",

        "FormalName": "FormalName1a",

        "TypeName": "TypeName1a"

      },
    }

```

Using DSL and ultimately NEST, I would like to return all documents where the following nested fields are matched:

- DocumentId
- FormalName

Thank you.

---

<div class="post-metadata">

### Author: ![tamara](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tamara/32/47095_2.png) [@tamara](https://discuss.elastic.co/u/tamara)
#### Post date: [November 5, 2018, 4:49pm UTC](https://discuss.elastic.co/t/elasticsearch-nested-queries/155274/2 "2018-11-05T16:49:22Z")

</div>

Hi,

You can try the following query, the query might change if you have some different mapping .

```
GET test/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "match" : {
            "documents.DocumentId": 1
          } 
        },
        {
          "match": {
            "minutesEntity.FormalName": "FormalName1a"
          }
        }
      ]
    }
  }
}

```

If you want more information you can find at: [https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-bool-query.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: [December 3, 2018, 4:52pm UTC](https://discuss.elastic.co/t/elasticsearch-nested-queries/155274/3 "2018-12-03T16:52:05Z")

</div>

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