I am having trouble to make multi level nested query by using NEST API.
Here is my mapping.
{
"log": {
"mappings":{
"LogEvent": {
"properties":{
"@timestamp":{"type":"date","store":true,"format":"yyyy-MM-dd'T'HH:mm:ss"},
"records":
{"type":"nested","properties":{
"eventtype" : {"type":"string","store":true},
"detail":{"type":"string","store":true},
"others":{
"type":"nested","properties":{
"ScrubbedContent":{"type":"string","store":true},
"RawContent":{"type":"string","store":true}
}
}
} } }
}
}
And here is the query that works
{
"from": 0,
"size": 1,
"query": {
"filtered": {
"filter": {
"and": {
"filters": [
{
"range": {
"@timestamp": {
"gte": "2015-02-12T02:37:32",
"lte": "2015-02-19T02:37:32"
}
}
},
{
"nested": {
"filter": {
"terms": {
"records.eventtype": "myeventtype"
}
},
"path": "records"
}
}
]
}
}
}
}
}
But if I change "path": "records" to "path": "records.others", no result
returned. I am pretty sure I should have results for it.
Any thought why?
--
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/CAHsnNRjY8dLpzd260Pg6rkoAHVKvZWwC9OZS%3DUinpaoXTJU6Dg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.