# How to search nested docs with field condition all satisfied with range condition

**URL:** https://discuss.elastic.co/t/how-to-search-nested-docs-with-field-condition-all-satisfied-with-range-condition/60813
**Category:** Elasticsearch
**Created:** [September 18, 2016, 2:55pm UTC](https://discuss.elastic.co/t/how-to-search-nested-docs-with-field-condition-all-satisfied-with-range-condition/60813 "2016-09-18T14:55:28Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![jdgiauzn](https://avatars.discourse-cdn.com/v4/letter/j/898d66/32.png) [@jdgiauzn](https://discuss.elastic.co/u/jdgiauzn)
#### Post date: [September 18, 2016, 2:55pm UTC](https://discuss.elastic.co/t/how-to-search-nested-docs-with-field-condition-all-satisfied-with-range-condition/60813/1 "2016-09-18T14:55:28Z")

</div>

[http://sense.qbox.io/gist/7c4abcc3fb48882c36c9014c625c8bda20e517c7](http://sense.qbox.io/gist/7c4abcc3fb48882c36c9014c625c8bda20e517c7)

```auto
DELETE /test_index

PUT /test_index
{
   "settings": {
      "number_of_shards": 1
   },
   "mappings": {
      "listing": {
        "dynamic": "false",
        "properties": {
          "id": {
            "type": "integer"
          },
          "types": {
            "type": "nested",
            "properties": {
              "id": {
                "type": "integer"
              },
              "date": {
                "type": "date"
              },
              "status": {
                "type": "integer"
              }
            }
          }
        }
      }
    }
}

POST /test_index/listing/_bulk
{"index":{"_id":1}}
{"id":1,"types":[{"id":1, "date":"2016-09-07", "status": 1}, {"id":2, "date":"2016-09-08", "status": 1}, {"id":3, "date":"2016-09-09", "status": 1}]}
{"index":{"_id":2}}
{"id":2,"types":[{"id":4, "date":"2016-09-07", "status": 1}, {"id":5, "date":"2016-09-08", "status": 0}, {"id":6, "date":"2016-09-09", "status": 1}]}
{"index":{"_id":3}}
{"id":3,"types":[{"id":7, "date":"2016-09-07", "status": 0}, {"id":8, "date":"2016-09-08", "status": 0}, {"id":9, "date":"2016-09-09", "status": 0}]}

POST /test_index/_search
{
  "query": {
    "bool": {
      "must": [
        {
          "nested": {
            "path": "types",
            "filter": {
              "and": [
                {
                  "terms": {
                    "types.status": [
                      1
                    ]
                  }
                },
                {
                  "range": {
                    "types.date": {
                      "gte": "2016-09-07",
                      "lt": "2016-09-09"
                    }
                  }
                }
              ]
            }
          }
        }
      ]
    }
  },
  "_source": false
}

```

I want listing with id "1" only.

Thanks

---

<div class="post-metadata">

### Author: ![jdgiauzn](https://avatars.discourse-cdn.com/v4/letter/j/898d66/32.png) [@jdgiauzn](https://discuss.elastic.co/u/jdgiauzn)
#### Post date: [September 20, 2016, 3:18pm UTC](https://discuss.elastic.co/t/how-to-search-nested-docs-with-field-condition-all-satisfied-with-range-condition/60813/2 "2016-09-20T15:18:08Z")

</div>

Any body knows?

---

<div class="post-metadata">

### Author: ![jpountz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jpountz/32/45836_2.png) [@jpountz](https://discuss.elastic.co/u/jpountz)
#### Post date: [September 20, 2016, 4:11pm UTC](https://discuss.elastic.co/t/how-to-search-nested-docs-with-field-condition-all-satisfied-with-range-condition/60813/3 "2016-09-20T16:11:46Z")

</div>

Your current query looks good, what is the issue?

---

<div class="post-metadata">

### Author: ![jdgiauzn](https://avatars.discourse-cdn.com/v4/letter/j/898d66/32.png) [@jdgiauzn](https://discuss.elastic.co/u/jdgiauzn)
#### Post date: [September 21, 2016, 7:21am UTC](https://discuss.elastic.co/t/how-to-search-nested-docs-with-field-condition-all-satisfied-with-range-condition/60813/4 "2016-09-21T07:21:42Z")

</div>

current query result will return listings of id 1 and 2.

I just want the listing id of 1, because all status is 1, but listing id of 2 is not

thanks

---

<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 5, 2017, 10:18pm UTC](https://discuss.elastic.co/t/how-to-search-nested-docs-with-field-condition-all-satisfied-with-range-condition/60813/5 "2017-07-05T22:18:37Z")

</div>