# Missing Filter not working

**URL:** <https://discuss.elastic.co/t/missing-filter-not-working/11102>\
**Category:** Elasticsearch\
**Created:** [March 11, 2013, 6:25pm UTC](https://discuss.elastic.co/t/missing-filter-not-working/11102 "2013-03-11T18:25:38Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![victor](https://avatars.discourse-cdn.com/v4/letter/v/3e96dc/32.png) [@victor](https://discuss.elastic.co/u/victor)\
**Post date:** [March 11, 2013, 6:25pm UTC](https://discuss.elastic.co/t/missing-filter-not-working/11102/1 "2013-03-11T18:25:38Z")

</div>

I want to query the group\_moel field that contains null value, but i am not getting the right result:  
group\_model is a field using default mapping setting. the result have records which group\_model = "IS"

curl -X GET '[http://localhost:9200/manufactured\_tires/manufactured\_tire/\_search?from=0&size=100&pretty](http://localhost:9200/manufactured_tires/manufactured_tire/_search?from=0&size=100&pretty)' -d '{"filter":{"missing": {"field": "group\_model", "null\_value": null}}}'

Result:  
{  
"took" : 1,  
"timed\_out" : false,  
"\_shards" : {  
"total" : 5,  
"successful" : 5,  
"failed" : 0  
},  
"hits" : {  
"total" : 9,  
"max\_score" : 1.0,  
"hits" : [ {  
"\_index" : "manufactured\_tires-2013-03-04",  
"\_type" : "manufactured\_tire",  
"\_id" : "6f0gOX7sRZu1gQjZUhlgXA",  
"\_score" : 1.0, "\_source" : {"aspect\_ratio":"40","car\_designation":"E","load\_range":"","load\_rating\_index":"93","make":"LEXUS","model":"IS F Base","primary\_secondary":"1","radial\_construction":"R","rim\_diameter":"19","section\_width":"225","speed\_rating":"Y","tire\_designation":"1","tire\_size":"225/40R19","year":2011,"id":"6f0gOX7sRZu1gQjZUhlgXA","\_type":"manufactured\_tire","\_score":0.0,"\_index":"manufactured\_tires-2013-03-04","\_version":null,"sort":null,"highlight":null,"\_explanation":null,"group\_model":"IS"}  
}, {  
"\_index" : "manufactured\_tires-2013-03-04",  
"\_type" : "manufactured\_tire",  
"\_id" : "ep9IXrlOR4Sqvek5c41HQg",  
"\_score" : 1.0, "\_source" : {"aspect\_ratio":"35","car\_designation":"E","load\_range":"","load\_rating\_index":"96","make":"LEXUS","model":"IS F Base","primary\_secondary":"1","radial\_construction":"R","rim\_diameter":"19","section\_width":"255","speed\_rating":"Y","tire\_designation":"2","tire\_size":"255/35R19","year":2009,"id":"ep9IXrlOR4Sqvek5c41HQg","\_type":"manufactured\_tire","\_score":0.0,"\_index":"manufactured\_tires-2013-03-04","\_version":null,"sort":null,"highlight":null,"\_explanation":null,"group\_model":"IS"}

....

---

<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, 2:47am UTC](https://discuss.elastic.co/t/missing-filter-not-working/11102/2 "2017-07-06T02:47:08Z")

</div>