# Some question about a 'missing' filter

**URL:** <https://discuss.elastic.co/t/some-question-about-a-missing-filter/10246>\
**Category:** Elasticsearch\
**Created:** [January 7, 2013, 8:55am UTC](https://discuss.elastic.co/t/some-question-about-a-missing-filter/10246 "2013-01-07T08:55:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![insoul](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/insoul/32/2554_2.png) [@insoul](https://discuss.elastic.co/u/insoul)\
**Post date:** [January 7, 2013, 8:55am UTC](https://discuss.elastic.co/t/some-question-about-a-missing-filter/10246/1 "2013-01-07T08:55:22Z")

</div>

curl -XDELETE [http://localhost:9200/twitter/tweet](http://localhost:9200/twitter/tweet)

curl -XPUT [http://localhost:9200/twitter/tweet/1](http://localhost:9200/twitter/tweet/1) -d '{  
"contents": "a"  
}'

curl -XPUT [http://localhost:9200/twitter/tweet/2](http://localhost:9200/twitter/tweet/2) -d '{  
"contents": null  
}'

curl -XPUT [http://localhost:9200/twitter/tweet/3](http://localhost:9200/twitter/tweet/3) -d '{  
"contents": "b"  
}'

curl -XPUT [http://localhost:9200/twitter/tweet/4](http://localhost:9200/twitter/tweet/4) -d '{  
"contents": "aa"  
}'

curl -XPUT [http://localhost:9200/twitter/tweet/5](http://localhost:9200/twitter/tweet/5) -d '{  
"contents": "1"  
}'

curl -XGET [http://localhost:9200/twitter/tweet/\_search?pretty](http://localhost:9200/twitter/tweet/_search?pretty) -d '{  
"query":{  
"constant\_score" : {  
"filter" : {  
"missing" : {  
"field" : "contents",  
"existence" : true,  
"null\_value" : true  
}  
}  
}  
}  
}'

result of the last query

{  
"took" : 3,  
"timed\_out" : false,  
"\_shards" : {  
"total" : 5,  
"successful" : 5,  
"failed" : 0  
},  
"hits" : {  
"total" : 2,  
"max\_score" : 1.0,  
"hits" : [ {  
"\_index" : "twitter",  
"\_type" : "tweet",  
"\_id" : "1",  
"\_score" : 1.0, "\_source" : {  
"contents": "a"  
}  
}, {  
"\_index" : "twitter",  
"\_type" : "tweet",  
"\_id" : "2",  
"\_score" : 1.0, "\_source" : {  
"contents": null  
}  
} ]  
}  
}

Results include document that has content "a"  
In my real data, include document that has content "1"

I have used 0.20.2.  
Am I missing some considerations... or is this bug?

---

<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:57am UTC](https://discuss.elastic.co/t/some-question-about-a-missing-filter/10246/2 "2017-07-06T02:57:36Z")

</div>