# Search query working in One environment and not in another **URL:** \ **Category:** Elasticsearch\ **Created:** [July 11, 2018, 8:50am UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516 "2018-07-11T08:50:12Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![mohammedEssabri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohammedessabri/32/42177_2.png) [@mohammedEssabri](https://discuss.elastic.co/u/mohammedEssabri)\ **Post date:** [July 11, 2018, 8:50am UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/1 "2018-07-11T08:50:12Z")
Dear team, > [@Multi\_match query issue](https://discuss.elastic.co/t/multi-match-query-issue/136988): > > Hi Team, I'm using ES 1.7 I have an index containing a field named proceedingslanguage which contains a language EN, FR or DE. The following script using Curl is giving me an empty result : curl -XGET 'http://localhost:9200/\_search?pretty' -d'{ "from" : 0, "size" : 6, "query" : { "filtered" : { "query" : { "bool" : { "must" : [ { "bool" : { "must" : { "multi\_match" : { "query" : "EN", … ---
**Author:** ![Igor\_Motov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igor_motov/32/45193_2.png) [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)\ **Post date:** [July 13, 2018, 4:33pm UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/2 "2018-07-13T16:33:46Z")
Not really sure what you mean here. ---
**Author:** ![mohammedEssabri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohammedessabri/32/42177_2.png) [@mohammedEssabri](https://discuss.elastic.co/u/mohammedEssabri)\ **Post date:** [July 16, 2018, 1:55pm UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/3 "2018-07-16T13:55:15Z")
Dear @Igor_Motov, Sorry, I was writing two topics, and i did a mistake in the title. The problem is that this query is working in on environment and not in another. ---
**Author:** ![Igor\_Motov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igor_motov/32/45193_2.png) [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)\ **Post date:** [July 16, 2018, 2:50pm UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/4 "2018-07-16T14:50:17Z")
Which query, what do you mean by "not working"? ---
**Author:** ![mohammedEssabri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohammedessabri/32/42177_2.png) [@mohammedEssabri](https://discuss.elastic.co/u/mohammedEssabri)\ **Post date:** [July 31, 2018, 3:33pm UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/5 "2018-07-31T15:33:44Z")
Hi @Igor_Motov, Thank you for the help! This one: ``` curl -XGET 'http://localhost:9200/_search?pretty' -d'{ "from" : 0, "size" : 6, "query" : { "filtered" : { "query" : { "bool" : { "must" : [ { "bool" : { "must" : { "multi_match" : { "query" : "EN", "fields" : ["proceedingslanguage_*", "proceedingslanguage_en^5.0"], "type" : "best_fields" } } } } ] } }, "filter" : { "type" : { "value" : "decision" } } } } }' ``` ---
**Author:** ![Igor\_Motov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igor_motov/32/45193_2.png) [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)\ **Post date:** [July 31, 2018, 3:45pm UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/6 "2018-07-31T15:45:36Z")
What do you mean by "not working"? ---
**Author:** ![mohammedEssabri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohammedessabri/32/42177_2.png) [@mohammedEssabri](https://discuss.elastic.co/u/mohammedEssabri)\ **Post date:** [July 31, 2018, 4:34pm UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/7 "2018-07-31T16:34:36Z")
It's not giving any hits(the number of hits is 0). Thanks ! ---
**Author:** ![Igor\_Motov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igor_motov/32/45193_2.png) [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)\ **Post date:** [July 31, 2018, 10:38pm UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/8 "2018-07-31T22:38:59Z")
How does the document that you expect it to return look like and what is the mapping? ---
**Author:** ![mohammedEssabri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohammedessabri/32/42177_2.png) [@mohammedEssabri](https://discuss.elastic.co/u/mohammedEssabri)\ **Post date:** [August 1, 2018, 8:39am UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/9 "2018-08-01T08:39:21Z")
Dear @Igor_Motov, Thank you for the help, please find it in dg\_creation.txt by following this [link](https://gist.github.com/mohammedESSABRI/34a210caa4465a0d02ea613913ec78ce) Dear @Igor_Motov, Can you please help me in this [topic](https://discuss.elastic.co/t/field-names-in-query-string-syntax-doesnt-filter-this-search/142419/2) as it is more urgent and i'm blocked in it? Many thanks! Best regards, Mohammed ESSABRI ---
**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:** [August 1, 2018, 9:35am UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/10 "2018-08-01T09:35:57Z")
> [@mohammedEssabri](#): > > Dear @Igor_Motov, > Can you please help me in this [topic](https://discuss.elastic.co/t/field-names-in-query-string-syntax-doesnt-filter-this-search/142419/2) as it is more urgent and i'm blocked in it? Please don't ping people who are not yet involved in a given topic. ---
**Author:** ![mohammedEssabri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohammedessabri/32/42177_2.png) [@mohammedEssabri](https://discuss.elastic.co/u/mohammedEssabri)\ **Post date:** [August 1, 2018, 1:53pm UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/11 "2018-08-01T13:53:03Z")
OK, I am sorry. Thank you! ---
**Author:** ![Igor\_Motov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igor_motov/32/45193_2.png) [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)\ **Post date:** [August 1, 2018, 5:30pm UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/12 "2018-08-01T17:30:57Z")
@mohammedEssabri you ignored the first part of my question "How does the document that you expect it to return look like?" ---
**Author:** ![mohammedEssabri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohammedessabri/32/42177_2.png) [@mohammedEssabri](https://discuss.elastic.co/u/mohammedEssabri)\ **Post date:** [August 3, 2018, 8:59am UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/13 "2018-08-03T08:59:33Z")
Sorry, I look like following ( This is a hit ): ``` { "_index" : "dg3_v11", "_type" : "decision", "_id" : "dg3decisions/name.xml", "_score" : 1.0, "_source":{ "path":"dg3decisions/name.xml", "decision_content":"...........content text...........\n", "DIS":"D", "KEY":"\nsome text\n", "DDO":"20040503", "title":["t010011eu1","t010011","t0011/01","t 0011/01","t11/01","t 11/01"], "APN":"95907427.9", "ART":"EPC1973 Art 111", "APL":"\nsome text.\n", "CSN":["t010011","T0011/01","t_0011/01","t11/01","t 11/01"], "ORD":"\nORDER\n.... some text", "TLE":" some text", "DAT":"20040427", "BOA":"3.4.02" } } ``` Thanks ! ---
**Author:** ![Igor\_Motov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igor_motov/32/45193_2.png) [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)\ **Post date:** [August 6, 2018, 3:24pm UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/14 "2018-08-06T15:24:50Z")
You are searching for the fields `proceedingslanguage_*` but you don't have these fields in ether the document that you expect to find nor in the mapping that you have provided. The closest field that I see there is `proceedingslanguage`. ---
**Author:** ![mohammedEssabri](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mohammedessabri/32/42177_2.png) [@mohammedEssabri](https://discuss.elastic.co/u/mohammedEssabri)\ **Post date:** [August 7, 2018, 11:10am UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/15 "2018-08-07T11:10:19Z")
I absolutely agree with you, but the question is why the same code ( using the same query, same mapping, similar data) is working in other environments? Thanks! ---
**Author:** ![Igor\_Motov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igor_motov/32/45193_2.png) [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)\ **Post date:** [August 7, 2018, 1:37pm UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/16 "2018-08-07T13:37:07Z")
My best guess is the other environment doesn't have the same mapping, data is not similar enough or query is different. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 4, 2018, 1:37pm UTC](https://discuss.elastic.co/t/search-query-working-in-one-environment-and-not-in-another/139516/17 "2018-09-04T13:37:13Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.