Re: problem in search nested type object
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+unsubscr...@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.
Re: problem in search nested type object
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.
Re: problem in search nested type object
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+unsubscr...@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.
problem in search nested type object
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/59cadcb5-33a1-4da1-a552-95a989a77904%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
