Problem in search nested type object

Elastic Stack Elasticsearch
1

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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/59cadcb5-33a1-4da1-a552-95a989a77904%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

2

Hi.

What kind of analyzer do you use? I think it might be a problem with the
whitespace (Or do you have the same problem if the value does not contain
whitespaces?).
In this case you can use a keyword analyzer (so you will not separate the
words into single token) or map the fields to not_analyzed.

Am Donnerstag, 16. Oktober 2014 12:59:13 UTC+2 schrieb shekhar chauhan:

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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/57701159-6000-493b-a0a6-28c054ac22ee%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

3

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+unsubscribe@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.

4

Hi Krešimir Slugan,
Thanks for your reply.I tried full element path in term filter -
"sectionResults.itemResults.InspectionItem".But still facing same problem(0
results found).

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/0aad42fd-8fb9-4fbc-b25d-c97d881f3664%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.