# Filtering term with "\_" doesn't work **URL:** \ **Category:** Elasticsearch\ **Created:** [March 6, 2015, 12:27pm UTC](https://discuss.elastic.co/t/filtering-term-with---doesnt-work/22550 "2015-03-06T12:27:19Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Joao\_Lima](https://avatars.discourse-cdn.com/v4/letter/j/dfb087/32.png) [@Joao\_Lima](https://discuss.elastic.co/u/Joao_Lima)\ **Post date:** [March 6, 2015, 12:27pm UTC](https://discuss.elastic.co/t/filtering-term-with---doesnt-work/22550/1 "2015-03-06T12:27:19Z")
I'm trying to make a query like this: { "query" :{ "filtered" :{ "query" :{ "multi\_match" : { "query" : "Vonder Carregador de Baterias CBV 0900 - 110V", "fields" : ["nome^10", "descricao"], "operator" : "or" } }, "filter" : { "bool" : { "must" : [ {"term" : { "ativo" : 1 }}, {"term" : {"id\_instancia": "Master\_cleaner"}}, ] } } } } } But when I filter some term with "\_" it doesn't work. -- 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/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [March 6, 2015, 12:28pm UTC](https://discuss.elastic.co/t/filtering-term-with---doesnt-work/22550/2 "2015-03-06T12:28:25Z")
What is your mapping for this field? -- David Pilato - Developer | Evangelist > **[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. @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr [https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr) | @scrutmydocs [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs) > Le 6 mars 2015 à 13:27, João Lima [joao.lima@betalabs.com.br](mailto:joao.lima@betalabs.com.br) a écrit : > > I'm trying to make a query like this: > > { > "query" :{ > "filtered" :{ > "query" :{ > "multi\_match" : { > "query" : "Vonder Carregador de Baterias CBV 0900 - 110V", > "fields" : ["nome^10", "descricao"], > "operator" : "or" > } > }, > "filter" : { > "bool" : { > "must" : [ > {"term" : { "ativo" : 1 }}, > {"term" : {"id\_instancia": "Master\_cleaner"}}, > ] > } > } > } > } > } > But when I filter some term with "\_" it doesn't work. > > -- > 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) [mailto:elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%40googlegroups.com) [https://groups.google.com/d/msgid/elasticsearch/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%40googlegroups.com?utm_medium=email&utm_source=footer). > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout) [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/57C846ED-2970-462A-ACCE-C11F82158FC0%40pilato.fr](https://groups.google.com/d/msgid/elasticsearch/57C846ED-2970-462A-ACCE-C11F82158FC0%40pilato.fr). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Joao\_Lima](https://avatars.discourse-cdn.com/v4/letter/j/dfb087/32.png) [@Joao\_Lima](https://discuss.elastic.co/u/Joao_Lima)\ **Post date:** [March 6, 2015, 12:33pm UTC](https://discuss.elastic.co/t/filtering-term-with---doesnt-work/22550/3 "2015-03-06T12:33:41Z")
"id\_instancia": { "type": "string", "include\_in\_all": false } On Friday, March 6, 2015 at 9:29:21 AM UTC-3, David Pilato wrote: > What is your mapping for this field? > > -- > _David Pilato_ - Developer | Evangelist > _[Elasticsearch.com](http://Elasticsearch.com) [http://Elasticsearch.com](http://Elasticsearch.com)_ > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr > [https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr) | @scrutmydocs > [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs) > > Le 6 mars 2015 à 13:27, João Lima \\> > a écrit : > > I'm trying to make a query like this: > > { > "query" :{ > "filtered" :{ > "query" :{ > "multi\_match" : { > "query" : "Vonder Carregador de Baterias CBV 0900 - 110V", > "fields" : ["nome^10", "descricao"], > "operator" : "or" > } > }, > "filter" : { > "bool" : { > "must" : [ > {"term" : { "ativo" : 1 }}, > {"term" : {"id\_instancia": "Master\_cleaner"}}, > ] > } > } > } > } > } > But when I filter some term with "\_" it doesn't work. > > -- > 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/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%40googlegroups.com) > [https://groups.google.com/d/msgid/elasticsearch/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%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/554effd6-d633-46ac-8af9-95088cda70de%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/554effd6-d633-46ac-8af9-95088cda70de%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Joao\_Lima](https://avatars.discourse-cdn.com/v4/letter/j/dfb087/32.png) [@Joao\_Lima](https://discuss.elastic.co/u/Joao_Lima)\ **Post date:** [March 6, 2015, 12:35pm UTC](https://discuss.elastic.co/t/filtering-term-with---doesnt-work/22550/4 "2015-03-06T12:35:04Z")
I did something like this: "mappings": { "produto\_cadastro": { "properties": { "id\_instancia": { "type": "string", "include\_in\_all": false } } } } On Friday, March 6, 2015 at 9:29:21 AM UTC-3, David Pilato wrote: > What is your mapping for this field? > > -- > _David Pilato_ - Developer | Evangelist > _[Elasticsearch.com](http://Elasticsearch.com) [http://Elasticsearch.com](http://Elasticsearch.com)_ > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr > [https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr) | @scrutmydocs > [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs) > > Le 6 mars 2015 à 13:27, João Lima \\> > a écrit : > > I'm trying to make a query like this: > > { > "query" :{ > "filtered" :{ > "query" :{ > "multi\_match" : { > "query" : "Vonder Carregador de Baterias CBV 0900 - 110V", > "fields" : ["nome^10", "descricao"], > "operator" : "or" > } > }, > "filter" : { > "bool" : { > "must" : [ > {"term" : { "ativo" : 1 }}, > {"term" : {"id\_instancia": "Master\_cleaner"}}, > ] > } > } > } > } > } > But when I filter some term with "\_" it doesn't work. > > -- > 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/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%40googlegroups.com) > [https://groups.google.com/d/msgid/elasticsearch/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%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/47c6c7ba-fe84-4079-a454-2e1e224308f1%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/47c6c7ba-fe84-4079-a454-2e1e224308f1%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [March 6, 2015, 1:53pm UTC](https://discuss.elastic.co/t/filtering-term-with---doesnt-work/22550/5 "2015-03-06T13:53:51Z")
Use a not analyzed field. You field is analyzed here with the standard analyzer. Term filter compares the string you pass with the invented index. Have a look at \_analyze API as well. Should help to understand what happens. David > Le 6 mars 2015 à 13:33, João Lima [joao.lima@betalabs.com.br](mailto:joao.lima@betalabs.com.br) a écrit : > > "id\_instancia": { > "type": "string", > "include\_in\_all": false > } > > > On Friday, March 6, 2015 at 9:29:21 AM UTC-3, David Pilato wrote: > > What is your mapping for this field? > > > > -- > > David Pilato - Developer | Evangelist > > [Elasticsearch.com](http://Elasticsearch.com) > > @dadoonet | @elasticsearchfr | @scrutmydocs > > > > > Le 6 mars 2015 à 13:27, João Lima [joao...@betalabs.com.br](mailto:joao...@betalabs.com.br) a écrit : > > > > > > I'm trying to make a query like this: > > > > > > { > > > "query" :{ > > > "filtered" :{ > > > "query" :{ > > > "multi\_match" : { > > > "query" : "Vonder Carregador de Baterias CBV 0900 - 110V", > > > "fields" : ["nome^10", "descricao"], > > > "operator" : "or" > > > } > > > }, > > > "filter" : { > > > "bool" : { > > > "must" : [ > > > {"term" : { "ativo" : 1 }}, > > > {"term" : {"id\_instancia": "Master\_cleaner"}}, > > > ] > > > } > > > } > > > } > > > } > > > } > > > But when I filter some term with "\_" it doesn't work. > > > > > > -- > > > 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/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%40googlegroups.com). > > > 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/554effd6-d633-46ac-8af9-95088cda70de%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/554effd6-d633-46ac-8af9-95088cda70de%40googlegroups.com). > 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/A0B6AFB5-796E-4759-BA05-F752F636F3B0%40pilato.fr](https://groups.google.com/d/msgid/elasticsearch/A0B6AFB5-796E-4759-BA05-F752F636F3B0%40pilato.fr). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Joao\_Lima](https://avatars.discourse-cdn.com/v4/letter/j/dfb087/32.png) [@Joao\_Lima](https://discuss.elastic.co/u/Joao_Lima)\ **Post date:** [March 9, 2015, 2:23pm UTC](https://discuss.elastic.co/t/filtering-term-with---doesnt-work/22550/6 "2015-03-09T14:23:07Z")
Thanks David, I solved the problem. The field was being analyzed, so I did this: "mappings": { "produto\_cadastro": { "properties": { "id\_instancia": { "type": "string", "index": "not\_analyzed", "include\_in\_all": false } } } } And it worked perfectly. [http://www.betalabs.com.br/](http://www.betalabs.com.br/)_João_ _Lima_ joao.lima@betalabs.com.br [joão.lima@betalabs.com.br](mailto:jo%C3%83%C2%A3o.lima@betalabs.com.br) C. 11996609309 T.(11) 3522 6826 Rua Bandeira Paulista, 702, 12º andar - Itaim Bibi 04532-002 - São Paulo - SP - Brasil www.betalabs.com.br | Curta [betalabs | São Paulo SP](http://facebook.com/betalabsbr) [http://www.facebook.com/betalabsbr](http://www.facebook.com/betalabsbr) | Siga @betalabsbr [http://twitter.com/#!/betalabsbr](http://twitter.com/#!/betalabsbr) Esta mensagem contém informação confidencial, legalmente protegida e destinada ao uso exclusivo da pessoa acima nomeada. Caso o leitor não seja o seu destinatário, fica desde já notificado que a divulgação ou utilização da mesma são estritamente proibidas. Se esta mensagem foi recebida por engano, queira por favor nos informar imediatamente, respondendo este e-mail. This message transmission is intended only for the use of the addressee and may contain confidential information. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If received in error, please notify us immediately, by replying this message. On Fri, Mar 6, 2015 at 10:53 AM, David Pilato [david@pilato.fr](mailto:david@pilato.fr) wrote: > Use a not analyzed field. You field is analyzed here with the standard > analyzer. > Term filter compares the string you pass with the invented index. > > Have a look at \_analyze API as well. Should help to understand what > happens. > > David > > Le 6 mars 2015 à 13:33, João Lima [joao.lima@betalabs.com.br](mailto:joao.lima@betalabs.com.br) a écrit : > > "id\_instancia": { > "type": "string", > "include\_in\_all": false > } > > On Friday, March 6, 2015 at 9:29:21 AM UTC-3, David Pilato wrote: > > > What is your mapping for this field? > > > > -- > > _David Pilato_ - Developer | Evangelist > > _[Elasticsearch.com](http://Elasticsearch.com) [http://Elasticsearch.com](http://Elasticsearch.com)_ > > @dadoonet [https://twitter.com/dadoonet](https://twitter.com/dadoonet) | @elasticsearchfr > > [https://twitter.com/elasticsearchfr](https://twitter.com/elasticsearchfr) | @scrutmydocs > > [https://twitter.com/scrutmydocs](https://twitter.com/scrutmydocs) > > > > Le 6 mars 2015 à 13:27, João Lima [joao...@betalabs.com.br](mailto:joao...@betalabs.com.br) a écrit : > > > > I'm trying to make a query like this: > > > > { > > "query" :{ > > "filtered" :{ > > "query" :{ > > "multi\_match" : { > > "query" : "Vonder Carregador de Baterias CBV 0900 - 110V", > > "fields" : ["nome^10", "descricao"], > > "operator" : "or" > > } > > }, > > "filter" : { > > "bool" : { > > "must" : [ > > {"term" : { "ativo" : 1 }}, > > {"term" : {"id\_instancia": "Master\_cleaner"}}, > > ] > > } > > } > > } > > } > > } > > But when I filter some term with "\_" it doesn't work. > > > > -- > > 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/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7% > > [40googlegroups.com](http://40googlegroups.com) > > [https://groups.google.com/d/msgid/elasticsearch/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/481d9ee8-f5f0-43b2-a54d-06d9a6f25ae7%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/554effd6-d633-46ac-8af9-95088cda70de%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/554effd6-d633-46ac-8af9-95088cda70de%40googlegroups.com) > > [https://groups.google.com/d/msgid/elasticsearch/554effd6-d633-46ac-8af9-95088cda70de%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/554effd6-d633-46ac-8af9-95088cda70de%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 a topic in the > Google Groups "elasticsearch" group. > To unsubscribe from this topic, visit > [https://groups.google.com/d/topic/elasticsearch/rRgyD\_hn8R8/unsubscribe](https://groups.google.com/d/topic/elasticsearch/rRgyD_hn8R8/unsubscribe). > To unsubscribe from this group and all its topics, 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/A0B6AFB5-796E-4759-BA05-F752F636F3B0%40pilato.fr](https://groups.google.com/d/msgid/elasticsearch/A0B6AFB5-796E-4759-BA05-F752F636F3B0%40pilato.fr) > [https://groups.google.com/d/msgid/elasticsearch/A0B6AFB5-796E-4759-BA05-F752F636F3B0%40pilato.fr?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/A0B6AFB5-796E-4759-BA05-F752F636F3B0%40pilato.fr?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/CAPiGn9ynKYEjuWS%3D7poLmWTB5z\_Ks8f5%3DZWO%3DP8XrbfzWxAn9A%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAPiGn9ynKYEjuWS%3D7poLmWTB5z_Ks8f5%3DZWO%3DP8XrbfzWxAn9A%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**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, 12:27am UTC](https://discuss.elastic.co/t/filtering-term-with---doesnt-work/22550/7 "2017-07-06T00:27:46Z")