ES Collator Query

query.json

{
    "query": {
        "filtered": {
            "query": {
                "match_all": {}
            },
            "filter": {
                "and": [
                    {
                        "nested": {
                            "path": "locations",
                            "inner_hits": {},
                            "query": {
                                "filtered": {
                                    "filter": {
                                        "and": [
                                            {
                                                "geo_shape": {
                                                    "locations.region": {
                                                        "shape": {
                                                            "type": "Circle",
                                                            "radius": 20000,
                                                            "coordinates": [
                                                                -122.8061676,
                                                                38.8328323
                                                            ]
                                                        }
                                                    }
                                                }
                                            },
                                            {
                                                "nested": {
                                                    "path": "locations.settings",
                                                    "query": {
                                                        "filtered": {
                                                            "filter": {
                                                                "and": [
                                                                    {
                                                                        "term": {
                                                                            "locations.settings.event": 50
                                                                        }
                                                                    },
                                                                    {
                                                                        "term": {
                                                                            "locations.settings.notify": true
                                                                        }
                                                                    },
                                                                    {
                                                                        "range": {
                                                                            "locations.settings.severity": {
                                                                                "lte": 0.43
                                                                            }
                                                                        }
                                                                    }
                                                                ]
                                                            }
                                                        }
                                                    }
                                                }
                                            }
                                        ]
                                    }
                                }
                            }
                        }
                    },
                    {
                        "nested": {
                            "path": "devices",
                            "query": {
                                "filtered": {
                                    "filter": {
                                        "and": [
                                            {
                                                "exists": {
                                                    "field": "devices.arn"
                                                }
                                            },
                                            {
                                                "exists": {
                                                    "field": "devices.system"
                                                }
                                            }
                                        ]
                                    }
                                }
                            }
                        }
                    }
                ]
            }
        }
    },
    "from": 0,
    "size": 5,
    "_source": {
        "include": [
            "devices"
        ]
    },
    "sort": [
        {
            "devices.system": {
                "order": "asc",
                "nested_path": "devices"
            }
        }
    ]
}