Facet filters using nested objects

curl_queries.sh

curl -XPUT 'http://localhost:9200/test'
curl -XPUT 'http://localhost:9200/test/type1/_mapping' -d '{"type1":{"properties":{"testobj":{"properties":{"idtest":{"type":"long","include_in_all":false},"obj1":{"type":"nested","dynamic":"true","properties":{"date":{"type":"date","format":"dateOptionalTime","include_in_all":false},"id":{"type":"long","include_in_all":false}}}}}}}}'
curl -XPOST 'http://localhost:9200/test/type1/1' -d '{"testobj":{"idtest":1,"obj1":[{"date":"2012-01-01T00:02:00Z","id":4},{"date":"2012-01-01T02:11:00Z","id":6}]}}'
curl -XPOST 'http://localhost:9200/test/type1/_search?pretty=true' -d '{"facets":{"facet1":{"date_histogram":{"field":"date","interval":"hour"},"nested":"testobj.obj1","facet_filter":{"and":[{"range":{"testobj.obj1.date":{"from":"2012-01-01T00:00:00Z","to":"2012-02-01T00:00:00Z"}}}]}}}}'
curl -XPOST 'http://localhost:9200/test/type1/_search?pretty=true' -d '{"facets":{"facet1":{"date_histogram":{"field":"date","interval":"hour"},"nested":"testobj.obj1","facet_filter":{"and":[{"exists":{"field":"testobj.idtest"}},{"range":{"testobj.obj1.date":{"from":"2012-01-01T00:00:00Z","to":"2012-02-01T00:00:00Z"}}}]}}}}'

date.js

{
   "testobj":{
      "idtest":1,
      "obj1":[
         {
            "date":"2012-01-01T00:02:00Z",
            "id":4
         },
         {
            "date":"2012-01-01T02:11:00Z",
            "id":6
         }
      ]
   }
}

mapping.js

{
   "type1":{
      "properties":{
         "testobj":{
            "properties":{
               "idtest":{
                  "type":"long",
                  "include_in_all":false
               },
               "obj1":{
                  "type":"nested",
                  "dynamic":"true",
                  "properties":{
                     "date":{
                        "type":"date",
                        "format":"dateOptionalTime",
                        "include_in_all":false
                     },
                     "id":{
                        "type":"long",
                        "include_in_all":false
                     }
                  }
               }
            }
         }
      }
   }
}

query_failed.js

{
   "facets":{
      "facet1":{
         "date_histogram":{
            "field":"date",
            "interval":"hour"
         },
         "nested":"testobj.obj1",
         "facet_filter":{
            "and":[
               {
                  "exists":{
                     "field":"testobj.idtest"
                  }
               },
               {
                  "range":{
                     "testobj.obj1.date":{
                        "from":"2012-01-01T00:00:00Z",
                        "to":"2012-02-01T00:00:00Z"
                     }
                  }
               }
            ]
         }
      }
   }
}

query_ok.js

{
   "facets":{
      "facet1":{
         "date_histogram":{
            "field":"date",
            "interval":"hour"
         },
         "nested":"testobj.obj1",
         "facet_filter":{
            "and":[
               {
                  "range":{
                     "testobj.obj1.date":{
                        "from":"2012-01-01T00:00:00Z",
                        "to":"2012-02-01T00:00:00Z"
                     }
                  }
               }
            ]
         }
      }
   }
}