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 [email protected].
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.
{
"_id": "inspectionresults-07d864fd-76ec-427a-a1c6-b70e420ce3d8",
"_rev": "12-64c44ddcfcd477dfa86cdb9d3c659748",
"ChecklistName": "NP Online",
"checklistId": "checklist-51843214-f761-4f4f-89c2-fae82fb49fec",
"CreatedOn": "2014-10-08T14:20:23.6034+05:30",
"sectionResults": [
{
"SectionName": "More Details",
"SectionInfo": "",
"SectionRepeatCount": 0,
"RepeatedChildNumber": 0,
"itemResults": [
{
"InspectionItem": "Launch Month",
"ItemInfo": "",
"Result": "inprogress",
"Value": "",
"ReportMapping": "",
"CaptionList": [
],
"Values": [
],
"NumericValue": 0,
"DoubleValue": 0,
"LongValue": 0,
"DateValue": "2014-10-08T14:20:23.6034+05:30"
}
]
}
],
"Type": "inspectionresults"
}
