# Query\_string on nested objects **URL:** \ **Category:** Elasticsearch\ **Created:** [August 22, 2016, 2:40pm UTC](https://discuss.elastic.co/t/query-string-on-nested-objects/58587 "2016-08-22T14:40:40Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Fabien\_Sarlat](https://avatars.discourse-cdn.com/v4/letter/f/7ab992/32.png) [@Fabien\_Sarlat](https://discuss.elastic.co/u/Fabien_Sarlat)\ **Post date:** [August 22, 2016, 2:40pm UTC](https://discuss.elastic.co/t/query-string-on-nested-objects/58587/1 "2016-08-22T14:40:40Z")
Hello there ! I have a problem with nested objetcts ๐Ÿ˜ƒ Field : ``` "listSecteurs": { "type" : "nested", "include_in_parent": true, "properties" : { "secteurName" : {"type": "string", "analyzer": "analyzerFr"}, "secteurExp" : {"type": "integer"} } }, ``` Values : ``` "listSecteurs": [ { "secteurName": "Ferroviaire", "secteurExp": "4" }, { "secteurName": "qwr", "secteurExp": "3" } ], ``` Search query (php api) : ``` $params = [ 'index' => 'index-fr', 'type' => 'candidat', 'body' => [ 'size' => 20, 'query' => [ 'query_string' => [ 'analyze_wildcard' => true, 'default_operator' => 'AND', 'query' => [ 'fields' => ['listSecteurs'], 'query' => qwr ] ] ] ] ]; ``` This search query doesn't find the "qwr" in my value ๐Ÿ˜„ ---
**Author:** ![colings86](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/colings86/32/44960_2.png) [@colings86](https://discuss.elastic.co/u/colings86)\ **Post date:** [August 22, 2016, 3:52pm UTC](https://discuss.elastic.co/t/query-string-on-nested-objects/58587/2 "2016-08-22T15:52:29Z")
If you are searching for attributes on nested documents you will need to use the [`nested` query](https://www.elastic.co/guide/en/elasticsearch/reference/2.3/query-dsl-nested-query.html). [This chapter](https://www.elastic.co/guide/en/elasticsearch/guide/current/nested-objects.html) of the 'Elasticsearch:The Definitive Guide` book would be worth a read to understand how nested objects work in Elasticsearch. ---
**Author:** ![Fabien\_Sarlat](https://avatars.discourse-cdn.com/v4/letter/f/7ab992/32.png) [@Fabien\_Sarlat](https://discuss.elastic.co/u/Fabien_Sarlat)\ **Post date:** [August 23, 2016, 10:10am UTC](https://discuss.elastic.co/t/query-string-on-nested-objects/58587/3 "2016-08-23T10:10:12Z")
Thanks ! ``` "nested": { "path" : ["listSecteurs"], "query": { "query_string": { "fields": ["listSecteurs.secteurName"], "query": "qwr" } } }, ``` But i want to search on other fields and they're simple string fields. I need to use query\_string (for the AND/OR), but i can't manage to combine the nested and the query string for simple fields. ---
**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\ **Post date:** [August 23, 2016, 10:28am UTC](https://discuss.elastic.co/t/query-string-on-nested-objects/58587/4 "2016-08-23T10:28:36Z")
> [@Fabien\_Sarlat](#): > > I need to use query\_string (for the AND/OR), but i can't manage to combine the nested and the query string for simple fields. You can combine the nested properties into a leaf-level equivalent of the "\_all" field that sits at the root. See the "skills.summary" in the example below: ``` PUT test { "settings": { "number_of_replicas": "0", "number_of_shards": "1" }, "mappings": { "candidate": { "dynamic": "strict", "properties": { "name": { "type": "string" }, "skills": { "type": "nested", "properties": { "summary":{ "type":"string" }, "sector": { "type": "string", "copy_to": "skills.summary" }, "experience": { "type": "string", "copy_to": "skills.summary" } } } } } } } POST test/candidate { "name":"mark", "skills":[ { "sector":"lucene", "experience":5 }, { "sector":"javascript", "experience":2 } ] } GET test/candidate/_search { "query": { "nested": { "path": "skills", "query": { "query_string": { "default_field": "skills.summary", "query": "lucene AND 5" } } } } } ``` ---
**Author:** ![Fabien\_Sarlat](https://avatars.discourse-cdn.com/v4/letter/f/7ab992/32.png) [@Fabien\_Sarlat](https://discuss.elastic.co/u/Fabien_Sarlat)\ **Post date:** [August 23, 2016, 10:44am UTC](https://discuss.elastic.co/t/query-string-on-nested-objects/58587/5 "2016-08-23T10:44:36Z")
Thanks, i actually do almost the same thing : ``` "mappings" : { "candidat": { "properties": { "usersFunction" : {"type": "string"}, "listOutils" : { "type" : "nested", "properties" : { "outilName" : {"type": "string"}, "outilRating" : {"type": "integer"} } }, } } } ``` With the nested search i can search inside listOutils, but i dont know how to search in both listOutils et usersFunction (skills.summary and name for your example) This doesn't work ``` "query": { "nested": { "path" : ["listOutils"], "query": { "query_string": { "fields": ["listOutils.outilName"], "query": "word excel" } } }, "query_string": { "analyze_wildcard": true, "default_operator": "AND", "query": { "fields": ["usersFunction"], "query": "word excel" } } } ``` ---
**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\ **Post date:** [August 23, 2016, 11:02am UTC](https://discuss.elastic.co/t/query-string-on-nested-objects/58587/6 "2016-08-23T11:02:02Z")
Inviting users to use AND/OR () type logic using `query_string` may seem appealing but the query parser lacks the syntax to express `nested` clauses and even if it did I'm not sure most end users would know how to use it or want to. It's a potentially dangerous combination to offer users the tools to write formal Boolean logic but with no clear way of expressing the logic about which values they are ANDing etc. ---
**Author:** ![Fabien\_Sarlat](https://avatars.discourse-cdn.com/v4/letter/f/7ab992/32.png) [@Fabien\_Sarlat](https://discuss.elastic.co/u/Fabien_Sarlat)\ **Post date:** [August 23, 2016, 11:40am UTC](https://discuss.elastic.co/t/query-string-on-nested-objects/58587/7 "2016-08-23T11:40:34Z")
Don't worry, our clients know how to use the boolean and want them ๐Ÿ˜ƒ We had the AND/OR, parenthesis and double quote in a home made search engine but Es if way more efficient. So i can't search inside both simple string field and nested object ? ---
**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\ **Post date:** [August 23, 2016, 11:47am UTC](https://discuss.elastic.co/t/query-string-on-nested-objects/58587/8 "2016-08-23T11:47:41Z")
The problem is the user needs to be explicit about which context they are AND or ORing in. Are they ANDing terms that come from the same nested object or are they properties they hope to find in different objects. `query_string` does not let them express that context. ---
**Author:** ![Fabien\_Sarlat](https://avatars.discourse-cdn.com/v4/letter/f/7ab992/32.png) [@Fabien\_Sarlat](https://discuss.elastic.co/u/Fabien_Sarlat)\ **Post date:** [August 23, 2016, 12:11pm UTC](https://discuss.elastic.co/t/query-string-on-nested-objects/58587/9 "2016-08-23T12:11:42Z")
Sorry i dont understand what you said. When a user search, he will write "word AND excel". I will take this search query and match fields who contains word and excel. It works with : ``` 'size' => 20, 'query' => [ 'query_string' => [ 'query' => [ 'fields' => ['usersFunction', other string field], 'query' => "word AND excel" ] ] ] ``` `listOutils.outilName` won't work there (because it's a nested object), so i have to use the `nested` to search. But if i use `nested` like this : ``` "size": 20, "nested": { "path" : ["listOutils"], "query": { "query_string": { "fields": ["listOutils.outilName"], "query": "Chef de projet รฉlรฉctronique" } } } ``` I can't perform a search on other string fields ๐Ÿ˜• That's why i ask if i can do both in one query, to search in the string fieds and nested objects. ---
**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\ **Post date:** [August 23, 2016, 1:36pm UTC](https://discuss.elastic.co/t/query-string-on-nested-objects/58587/10 "2016-08-23T13:36:05Z")
> [@Fabien\_Sarlat](#): > > Sorry i dont understand what you said. If your query is `word AND excel` I assume the user is finding a candidate with both of these skills. That would be easily achieved having a "flat" mapping and not using `nested` at all. The reason I expect you opted for nested mappings in your original example is that at some point someone wanted to query for `secteurName: qwr AND secteurExp:3`. In this case nested mappings are necessary to avoid the "cross-matching" problem of flattening all skills into a single Lucene document. However - the 2 queries `word AND excel` and `qwr AND 3` have very different assumptions about how matching should work. The first assumes you are querying across nested docs and the second assumes you are querying inside nested docs and there is no way for the user to control which behaviour they require using the `query_string` query parser. If your users are only doing cross-object ANDing like the `word AND excel` example then consider using `copy_to` to put content in the root or drop the use of nested if you have no other need for it. ---
**Author:** ![Fabien\_Sarlat](https://avatars.discourse-cdn.com/v4/letter/f/7ab992/32.png) [@Fabien\_Sarlat](https://discuss.elastic.co/u/Fabien_Sarlat)\ **Post date:** [August 23, 2016, 1:47pm UTC](https://discuss.elastic.co/t/query-string-on-nested-objects/58587/11 "2016-08-23T13:47:59Z")
Right, i understand now. And yes, your're right, the user wants to search `word and excel` but also search some specific skill by name and experience (`word 3years`). In the end, i can do like your exemple or i can have nested object and flat array in my mapping and choose which one to use. Thanks ! ๐Ÿ˜„ ---
**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\ **Post date:** [August 23, 2016, 1:54pm UTC](https://discuss.elastic.co/t/query-string-on-nested-objects/58587/12 "2016-08-23T13:54:53Z")
> [@Fabien\_Sarlat](#): > > choose which one to use Maybe run both? You can of course have a bool `should` array with the user query in a nested context and also as a flattened non-nested one. The doc that matches the nested clause will also match the flattened clause and come top. The doc that matches only the flattened clause should not rank as highly. ---
**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, 10:25pm UTC](https://discuss.elastic.co/t/query-string-on-nested-objects/58587/13 "2017-07-05T22:25:53Z")