Try using full element path in term filter - "sectionResults.itemResults.InspectionItem"
"query": { "filtered": { "query": { "match_all": {} }, "filter": { "nested": { "path": "sectionResults.itemResults", "filter": { "bool": { "must": [ { "term": { "sectionResults.itemResults.InspectionItem": "Project Name" } } ] } } } } } } On Thursday, October 16, 2014 12:59:13 PM UTC+2, shekhar chauhan wrote: > > Hi All, > I am facing a problem in searcing a nested object.My document structure > is - > > { > "sectionResults": [ > { > "SectionName": "More Details", > "itemResults": [ > > { > "InspectionItem": "Project Name", > "ItemInfo": "" > > } > ] > } > > ] > } > > and I have used this mapping query to make itemResults object(in document) > of nested type - > PUT realtek_release_v6_nestedsearch/_mapping > { > "realtek_release_v6_nestedsearch":{ > "properties": { > "sectionResults":{ > "type": "object", > "properties": { > "itemResults":{ > "type": "nested" > } > } > } > } > } > } > > then i have checked the mapping .In mapping itemResults of nested type. > Everything if fine here. > But problem comes in searching query for nested object.my searching query > is - > > "query": { > "filtered": { > "query": { > "match_all": {} > }, > "filter": { > "nested": { > "path": "sectionResults.itemResults", > "filter": { > "bool": { > "must": [ > { > "term": { > "itemResults.InspectionItem": "Project Name" > } > } > ] > } > } > } > } > } > } > > this query returns 0 matching results.but result exists in database.I do > not know whether i am doing mistake in mapping or search query.Please help. > > -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/d538201f-39f4-48a6-ad9b-b0f83b0b68ad%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.