Nested Filter

Elastic Stack Elasticsearch
1

Hi All,
I am facing a problem in implementation of Nested Filter.I have attached
a document.Please first see it. My requirement is - i want to perform
nested filter on the sectionResults.itemResults.InspectionItem and
sectionResults.itemResults.DateValue(on both together). I have already
attached my couchdb database document to this mail.
and i am trying this -

GET realtek_release_v6/_search
{
"query": {
"filtered": {
"query": {
"match": {
"ChecklistName": "NP Online"
}
},
"filter": {
"nested": {
"path": "sectionResults.itemResults",
"filter":{
"bool": {
"must": [
{
"range": {
"sectionResults.itemResults.DateValue": {
"from": "2014-10-01",
"to": "2104-10-08"
}
}
},
{
"term": {
"sectionResults.itemResults.InspectionItem": "Launch
Month"
}
}
]
}
}
}
}
}
}
}

but it is not working.Please help me.

Thanks in advance.

--
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/5c5002b9-697c-464c-827d-4b1f6b2235bd%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.