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

Reply via email to