# Exists filter does not respect must\_not bool filter **URL:** \ **Category:** Elasticsearch\ **Created:** [September 3, 2014, 9:07pm UTC](https://discuss.elastic.co/t/exists-filter-does-not-respect-must-not-bool-filter/19606 "2014-09-03T21:07:25Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![ayushsangani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ayushsangani/32/9612_2.png) [@ayushsangani](https://discuss.elastic.co/u/ayushsangani)\ **Post date:** [September 3, 2014, 9:07pm UTC](https://discuss.elastic.co/t/exists-filter-does-not-respect-must-not-bool-filter/19606/1 "2014-09-03T21:07:25Z")
Hi Everyone, Goal: I want to find all the documents which does not have giving.assignee field. I am executing below query on ES version 1.3.2 involving exists filter and boolean filter. { "query": { "filtered": { "query": { "match\_all": {} }, "filter": { "bool": { "must\_not": [ { "exists": { "field": "giving.assignee" } } ] } } } }, "size": 2000 } While executing this query it gives me those documents also where giving.assignee field exists or has some value in it. We have around 2 million documents and it's returning almost close to 2 million documents. I have also tried using the missing filter but no luck. { "query": { "filtered": { "query": { "match\_all": {} }, "filter": { "bool": { "must": [ { "missing": { "field": "giving.assignee" } } ] } } } }, "size": 20000 } Same result as of the above query. If someone can point me what am I doing wrong here or if further information is needed please let me know. Looking forward for help. Thanks, Ayush Sangani -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Ivan](https://avatars.discourse-cdn.com/v4/letter/i/df788c/32.png) [@Ivan](https://discuss.elastic.co/u/Ivan)\ **Post date:** [September 3, 2014, 9:17pm UTC](https://discuss.elastic.co/t/exists-filter-does-not-respect-must-not-bool-filter/19606/2 "2014-09-03T21:17:20Z")
Is giving.assignee a sub-object or a nested document? Can you provide your mapping? Use the mapping API for exact results ( > **[Elasticsearch Platform — Find real-time answers at scale](https://www.elastic.co)** > > Power insights and outcomes with the Elasticsearch Platform and AI. See into your data and find answers that matter with enterprise solutions designed to help you build, observe, and protect. Try Elasticsearch free today. ) Perhaps enabling explain would provide some hints, -- Ivan On Wed, Sep 3, 2014 at 2:07 PM, ElasticRabbit [ayushsangani@gmail.com](mailto:ayushsangani@gmail.com) wrote: > Hi Everyone, > > Goal: I want to find all the documents which does not have giving.assignee > field. > > I am executing below query on ES version 1.3.2 involving exists filter and > boolean filter. > > { > "query": { > "filtered": { > "query": { > "match\_all": {} > }, > "filter": { > "bool": { > "must\_not": [ > { > "exists": { > "field": "giving.assignee" > } > } > ] > } > } > } > }, > "size": 2000 > } > > While executing this query it gives me those documents also where > giving.assignee field exists or has some value in it. > We have around 2 million documents and it's returning almost close to 2 > million documents. > > I have also tried using the missing filter but no luck. > > { > "query": { > "filtered": { > "query": { > "match\_all": {} > }, > "filter": { > "bool": { > "must": [ > { > "missing": { > "field": "giving.assignee" > } > } > ] > } > } > } > }, > "size": 20000 > } > > Same result as of the above query. > If someone can point me what am I doing wrong here or if further > information is needed please let me know. > Looking forward for help. > > Thanks, > Ayush Sangani > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com) > [https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com?utm_medium=email&utm_source=footer) > . > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CALY%3DcQBxKY4\_GOfEP2PXhd0on16KZvT6Z%3D%2Bx2zwci%3D9KHJy6sQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CALY%3DcQBxKY4_GOfEP2PXhd0on16KZvT6Z%3D%2Bx2zwci%3D9KHJy6sQ%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\ **Post date:** [September 3, 2014, 9:20pm UTC](https://discuss.elastic.co/t/exists-filter-does-not-respect-must-not-bool-filter/19606/3 "2014-09-03T21:20:46Z")
The behavior of exists/missing has slightly changed but this is unfortunately not well documented yet. Can you please try { "query": { "filtered": { "filter": { "not": { "filter": { "range": { "giving.assignee": { } } } } } } } } instead and see if it works better for your case? See also [Search result changed since 1.24 (current 1.3.2) · Issue #7348 · elastic/elasticsearch · GitHub](https://github.com/elasticsearch/elasticsearch/issues/7348) Jörg On Wed, Sep 3, 2014 at 11:07 PM, ElasticRabbit [ayushsangani@gmail.com](mailto:ayushsangani@gmail.com) wrote: > Hi Everyone, > > Goal: I want to find all the documents which does not have giving.assignee > field. > > I am executing below query on ES version 1.3.2 involving exists filter and > boolean filter. > > { > "query": { > "filtered": { > "query": { > "match\_all": {} > }, > "filter": { > "bool": { > "must\_not": [ > { > "exists": { > "field": "giving.assignee" > } > } > ] > } > } > } > }, > "size": 2000 > } > > While executing this query it gives me those documents also where > giving.assignee field exists or has some value in it. > We have around 2 million documents and it's returning almost close to 2 > million documents. > > I have also tried using the missing filter but no luck. > > { > "query": { > "filtered": { > "query": { > "match\_all": {} > }, > "filter": { > "bool": { > "must": [ > { > "missing": { > "field": "giving.assignee" > } > } > ] > } > } > } > }, > "size": 20000 > } > > Same result as of the above query. > If someone can point me what am I doing wrong here or if further > information is needed please let me know. > Looking forward for help. > > Thanks, > Ayush Sangani > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com) > [https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com?utm_medium=email&utm_source=footer) > . > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFjgTOVnX1hfNOJEowYyz3ZUS8epu2QQjnNFK3me6TdRA%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFjgTOVnX1hfNOJEowYyz3ZUS8epu2QQjnNFK3me6TdRA%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![ayushsangani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ayushsangani/32/9612_2.png) [@ayushsangani](https://discuss.elastic.co/u/ayushsangani)\ **Post date:** [September 3, 2014, 9:24pm UTC](https://discuss.elastic.co/t/exists-filter-does-not-respect-must-not-bool-filter/19606/4 "2014-09-03T21:24:01Z")
Hi Ivan, Thanks for reply. Please find below the mapping for the giving field. { "giving": { "properties": { "assignee": { "type": "string", "fields": { "assignee": { "type": "string", "index": "analyzed", "store": "yes", "include\_in\_all": false }, "untouched": { "type": "string", "index": "not\_analyzed", "store": "yes" } } } } } } Thanks, Ayush On Wednesday, September 3, 2014 5:17:29 PM UTC-4, Ivan Brusic wrote: > Is giving.assignee a sub-object or a nested document? Can you provide your > mapping? Use the mapping API for exact results ( > [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/indices-get-mapping.html) > ) > > Perhaps enabling explain would provide some hints, > > -- > Ivan > > On Wed, Sep 3, 2014 at 2:07 PM, ElasticRabbit \<[ayushs...@gmail.com](mailto:ayushs...@gmail.com) > \\> wrote: > > > Hi Everyone, > > > > Goal: I want to find all the documents which does not have > > giving.assignee field. > > > > I am executing below query on ES version 1.3.2 involving exists filter > > and boolean filter. > > > > { > > "query": { > > "filtered": { > > "query": { > > "match\_all": {} > > }, > > "filter": { > > "bool": { > > "must\_not": [ > > { > > "exists": { > > "field": "giving.assignee" > > } > > } > > ] > > } > > } > > } > > }, > > "size": 2000 > > } > > > > While executing this query it gives me those documents also where > > giving.assignee field exists or has some value in it. > > We have around 2 million documents and it's returning almost close to 2 > > million documents. > > > > I have also tried using the missing filter but no luck. > > > > { > > "query": { > > "filtered": { > > "query": { > > "match\_all": {} > > }, > > "filter": { > > "bool": { > > "must": [ > > { > > "missing": { > > "field": "giving.assignee" > > } > > } > > ] > > } > > } > > } > > }, > > "size": 20000 > > } > > > > Same result as of the above query. > > If someone can point me what am I doing wrong here or if further > > information is needed please let me know. > > Looking forward for help. > > > > Thanks, > > Ayush Sangani > > > > -- > > You received this message because you are subscribed to the Google Groups > > "elasticsearch" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com) > > [https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com?utm_medium=email&utm_source=footer) > > . > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/465afb27-b018-4aa7-83fc-69e5cd740409%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/465afb27-b018-4aa7-83fc-69e5cd740409%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![ayushsangani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ayushsangani/32/9612_2.png) [@ayushsangani](https://discuss.elastic.co/u/ayushsangani)\ **Post date:** [September 3, 2014, 10:50pm UTC](https://discuss.elastic.co/t/exists-filter-does-not-respect-must-not-bool-filter/19606/5 "2014-09-03T22:50:09Z")
Hi Jorg, "giving.assignee" is a string field I tried your suggestion also but it didn't work. { "query": { "filtered": { "query": { "match\_all": {} }, "filter": { "not": { "filter": { "exists": { "field": "giving.assignee" } } } } } }, "size": 20000 } I wonder if it is a bug in ES 1.3.2. Please let me know there is any other way to fix this. Thanks, Ayush Sangani On Wednesday, September 3, 2014 5:20:54 PM UTC-4, Jörg Prante wrote: > The behavior of exists/missing has slightly changed but this is > unfortunately not well documented yet. > > Can you please try > > { > "query": { > "filtered": { > "filter": { > "not": { > "filter": { > "range": { > "giving.assignee": { > } > } > } > } > } > } > } > } > > instead and see if it works better for your case? > > See also [Search result changed since 1.24 (current 1.3.2) · Issue #7348 · elastic/elasticsearch · GitHub](https://github.com/elasticsearch/elasticsearch/issues/7348) > > Jörg -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/10d3b16d-1363-4dcd-ad52-0dfb3c84142e%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/10d3b16d-1363-4dcd-ad52-0dfb3c84142e%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![ayushsangani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ayushsangani/32/9612_2.png) [@ayushsangani](https://discuss.elastic.co/u/ayushsangani)\ **Post date:** [September 4, 2014, 5:01pm UTC](https://discuss.elastic.co/t/exists-filter-does-not-respect-must-not-bool-filter/19606/6 "2014-09-04T17:01:51Z")
Hi Jorg, I was in a assumption that range filter has to be used for numeric fields. But this works thanks for the help. If anyone could enlighten me why must\_not bool filter doesn't respect exists filter? Thanks, Ayush Sangani On Wednesday, September 3, 2014 5:20:54 PM UTC-4, Jörg Prante wrote: > The behavior of exists/missing has slightly changed but this is > unfortunately not well documented yet. > > Can you please try > > { > "query": { > "filtered": { > "filter": { > "not": { > "filter": { > "range": { > "giving.assignee": { > } > } > } > } > } > } > } > } > > instead and see if it works better for your case? > > See also [Search result changed since 1.24 (current 1.3.2) · Issue #7348 · elastic/elasticsearch · GitHub](https://github.com/elasticsearch/elasticsearch/issues/7348) > > Jörg > > On Wed, Sep 3, 2014 at 11:07 PM, ElasticRabbit \<[ayushs...@gmail.com](mailto:ayushs...@gmail.com) > \\> wrote: > > > Hi Everyone, > > > > Goal: I want to find all the documents which does not have > > giving.assignee field. > > > > I am executing below query on ES version 1.3.2 involving exists filter > > and boolean filter. > > > > { > > "query": { > > "filtered": { > > "query": { > > "match\_all": {} > > }, > > "filter": { > > "bool": { > > "must\_not": [ > > { > > "exists": { > > "field": "giving.assignee" > > } > > } > > ] > > } > > } > > } > > }, > > "size": 2000 > > } > > > > While executing this query it gives me those documents also where > > giving.assignee field exists or has some value in it. > > We have around 2 million documents and it's returning almost close to 2 > > million documents. > > > > I have also tried using the missing filter but no luck. > > > > { > > "query": { > > "filtered": { > > "query": { > > "match\_all": {} > > }, > > "filter": { > > "bool": { > > "must": [ > > { > > "missing": { > > "field": "giving.assignee" > > } > > } > > ] > > } > > } > > } > > }, > > "size": 20000 > > } > > > > Same result as of the above query. > > If someone can point me what am I doing wrong here or if further > > information is needed please let me know. > > Looking forward for help. > > > > Thanks, > > Ayush Sangani > > > > -- > > You received this message because you are subscribed to the Google Groups > > "elasticsearch" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com) > > [https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com?utm_medium=email&utm_source=footer) > > . > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/e2903b18-475b-48b4-b905-365d5b49e66e%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/e2903b18-475b-48b4-b905-365d5b49e66e%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\ **Post date:** [September 4, 2014, 5:58pm UTC](https://discuss.elastic.co/t/exists-filter-does-not-respect-must-not-bool-filter/19606/7 "2014-09-04T17:58:12Z")
Yes, range filter operates on all fields. The missing/exists operation has been slightly changed in recent versions. For high cardinality fields, operations on the field content were very expensive. So, an optimization was introduced: each doc carries a list of the field names in a hidden field, and missing/exists refer to this new hidden field, which is extremely fast. The downside is that operations that depend on field values (like your boolean must\_not) can no longer be mixed with the new exists/missing field name filter. Jörg On Thu, Sep 4, 2014 at 7:01 PM, ElasticRabbit [ayushsangani@gmail.com](mailto:ayushsangani@gmail.com) wrote: > Hi Jorg, > > I was in a assumption that range filter has to be used for numeric fields. > But this works thanks for the help. > > If anyone could enlighten me why must\_not bool filter doesn't respect > exists filter? > > Thanks, > Ayush Sangani > > On Wednesday, September 3, 2014 5:20:54 PM UTC-4, Jörg Prante wrote: > > > The behavior of exists/missing has slightly changed but this is > > unfortunately not well documented yet. > > > > Can you please try > > > > { > > "query": { > > "filtered": { > > "filter": { > > "not": { > > "filter": { > > "range": { > > "giving.assignee": { > > } > > } > > } > > } > > } > > } > > } > > } > > > > instead and see if it works better for your case? > > > > See also [Search result changed since 1.24 (current 1.3.2) · Issue #7348 · elastic/elasticsearch · GitHub](https://github.com/elasticsearch/elasticsearch/issues/7348) > > > > Jörg > > > > On Wed, Sep 3, 2014 at 11:07 PM, ElasticRabbit [ayushs...@gmail.com](mailto:ayushs...@gmail.com) > > wrote: > > > > > Hi Everyone, > > > > > > Goal: I want to find all the documents which does not have > > > giving.assignee field. > > > > > > I am executing below query on ES version 1.3.2 involving exists filter > > > and boolean filter. > > > > > > { > > > "query": { > > > "filtered": { > > > "query": { > > > "match\_all": {} > > > }, > > > "filter": { > > > "bool": { > > > "must\_not": [ > > > { > > > "exists": { > > > "field": "giving.assignee" > > > } > > > } > > > ] > > > } > > > } > > > } > > > }, > > > "size": 2000 > > > } > > > > > > While executing this query it gives me those documents also where > > > giving.assignee field exists or has some value in it. > > > We have around 2 million documents and it's returning almost close to 2 > > > million documents. > > > > > > I have also tried using the missing filter but no luck. > > > > > > { > > > "query": { > > > "filtered": { > > > "query": { > > > "match\_all": {} > > > }, > > > "filter": { > > > "bool": { > > > "must": [ > > > { > > > "missing": { > > > "field": "giving.assignee" > > > } > > > } > > > ] > > > } > > > } > > > } > > > }, > > > "size": 20000 > > > } > > > > > > Same result as of the above query. > > > If someone can point me what am I doing wrong here or if further > > > information is needed please let me know. > > > Looking forward for help. > > > > > > Thanks, > > > Ayush Sangani > > > > > > -- > > > You received this message because you are subscribed to the Google > > > Groups "elasticsearch" group. > > > To unsubscribe from this group and stop receiving emails from it, send > > > an email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > > > > > To view this discussion on the web visit [https://groups.google.com/d/](https://groups.google.com/d/) > > > msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf% > > > [40googlegroups.com](http://40googlegroups.com) > > > [https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/89f2193a-5f11-447f-901c-29790318ddbf%40googlegroups.com?utm_medium=email&utm_source=footer) > > > . > > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). > > > > -- > > You received this message because you are subscribed to the Google Groups > > "elasticsearch" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/e2903b18-475b-48b4-b905-365d5b49e66e%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/e2903b18-475b-48b4-b905-365d5b49e66e%40googlegroups.com) > > [https://groups.google.com/d/msgid/elasticsearch/e2903b18-475b-48b4-b905-365d5b49e66e%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/e2903b18-475b-48b4-b905-365d5b49e66e%40googlegroups.com?utm_medium=email&utm_source=footer) > > . > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFLuWCdxTh\_g4aGVp9V9UdV-U9uMHWHpA%3DsfrDPhOjaVA%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFLuWCdxTh_g4aGVp9V9UdV-U9uMHWHpA%3DsfrDPhOjaVA%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![ayushsangani](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ayushsangani/32/9612_2.png) [@ayushsangani](https://discuss.elastic.co/u/ayushsangani)\ **Post date:** [September 5, 2014, 3:46pm UTC](https://discuss.elastic.co/t/exists-filter-does-not-respect-must-not-bool-filter/19606/8 "2014-09-05T15:46:08Z")
> Appreciate your explanation, and as per your suggestion range filter gives > correct results. > I am still confused with the usage of exists filter. > > As per my understanding the implementation of exists filter is changed in > v1.3 to increase the speed but why it deviates from it's expected behavior. No doubt exists filter might be fast or optimized but it is chopping off more than half of the results. > For Example: > > I want to find out number of documents where "giving.assignee" field > exists. > Note: "giving.assignee" is a string analyzed field. > { > "query": { > "filtered": { > "filter": { > "exists": { > "field": "giving.assignee" > } > } > } > }, > "size": 2000 > } Above query returns only 25607 documents whereas it should return 110827 documents. And If I run above query using range filter it gives me expected results i.e. 110827 documents. Query: { "query": { "filtered": { "filter": { "range": { "giving.assignee": {} } } } }, "size": 2000 } Can someone please explain the difference? It would be helpful to know when to use Exists filter ? Thanks, Ayush Sangani -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/db4b6fdd-cbc1-49db-aa37-2abd4fd08247%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/db4b6fdd-cbc1-49db-aa37-2abd4fd08247%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![mrepetto](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@mrepetto](https://discuss.elastic.co/u/mrepetto)\ **Post date:** [October 26, 2015, 9:26pm UTC](https://discuss.elastic.co/t/exists-filter-does-not-respect-must-not-bool-filter/19606/9 "2015-10-26T21:26:25Z")
Hi everyone! Another noob here with the same doubts that you had Ayush. I was testing a silly thing with the exists filter, but looks like is not working at all 😕 Look at the example below, when I run it, it completly ignores the exists filter and bring me the only result I have, only when I remove the { "query":{ "match\_all":{} } } it works (giving me 0 results). **How is that about that the missing/exists operations has been slightly changed??** POST /test/tweet { "message": "some arrays in this tweet...", "tags": [ "elasticsearch", "wow" ], "lists": [ { "name": "prog\_list", "description": "programming list" }, { "name": "cool\_list", "description": "cool stuff list" } ], "numbers": [1,2,3,4] } GET /test/tweet/\_search?explain #&format=yaml { \_source:["lists.description","ttt"], "query": { "filtered": { "filter": [ { "exists": { "field": "ttt" } }, { "query": { "match\_all": {} } } ] } } } Thanks! Mauricio Repetto ---
**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, 11:42pm UTC](https://discuss.elastic.co/t/exists-filter-does-not-respect-must-not-bool-filter/19606/10 "2017-07-05T23:42:37Z")