Elastic 0.90.2 : facet & nested object

createindex.sh

#!/bin/sh

curl -XDELETE http://localhost:9200/records
curl -XPOST http://localhost:9200/records
curl -XPUT http://localhost:9200/records/record/_mapping -d "`cat mapping.json`"
curl -XPUT http://localhost:9200/records/record/1 -d "`cat record-1.json`"
curl -XPUT http://localhost:9200/records/record/2 -d "`cat record-2.json`"

mapping.json

{
    "record": {
        "properties": {
            "id": {"type" : "long"},
            "reference" : {"type" : "string", "index": "not_analyzed"},    
            
            "situations": {
                "type": "nested",
                "properties": {
                    "beginDate": {"type" : "date"},
                    "endDate": {"type" : "date"},
                    "type": { "type" : "string", "index": "not_analyzed"}
                }
            }
        }
    }
}

record-1.json

{
    "id": 1,
    "reference": "RECORD-1",
    "situations": [
        {
            "beginDate": 1136847600000,
            "endDate": 32472140400000,
            "type": "FOO"
        }
    ],
    "score": null
}

record-2.json

{
    "id": 2,
    "reference": "RECORD-2",
    "situations": [
        {
            "beginDate": 1136847600000,
            "endDate":   3247214040000,
            "type": "BAR"
        },
        {
            "beginDate": 1131564600000,
            "endDate":   2654240400000,
            "type": "BAZ"
        }
    ],
    "score": null
}

request.json

{
    "query": {
        "match_all": {}
    },
    "facets": {
        "facet_situations": {
            "global": true,
            "nested": "situations",
            "terms": {
                "field": "situations.type"
            },
            "facet_filter": {
                "term": {
                    "record.reference": "RECORD-2"
                }
            }
        }
    }
}

request.sh

#!/bin/sh

curl -XPOST http://localhost:9200/records/record/_search?pretty=true -d "`cat request.json`"