ES Query

gistfile1.txt

{
    "query": {
        "match_all": {}
    },
    "size": 20,
    "sort": [
        {
            "date_end": {
                "order": "desc"
            }
        }
    ],
    "filter": {
        "and": [
            {
                "missing": {
                    "field": "disabled"
                }
            },
            {
                "term": {
                    "category": 1
                }
            },
            {
                "missing": {
                    "field": "hidden"
                }
            },
            {
                "term": {
                    "format": 20
                }
            }
        ]
    },
    "aggregations": {
        "enabled": {
            "filter": {
                "and": [
                    {
                        "missing": {
                            "field": "disabled"
                        }
                    },
                    {
                        "term": {
                            "category": 1
                        }
                    },
                    {
                        "missing": {
                            "field": "hidden"
                        }
                    }
                ]
            },
            "aggregations": {
                "category": {
                    "terms": {
                        "field": "category"
                    },
                    "aggregations": {
                        "format": {
                            "filter": {
                                "and": []
                            },
                            "aggregations": {
                                "formats": {
                                    "terms": {
                                        "field": "format",
                                        "size": 30
                                    }
                                }
                            }
                        },
                        "genre": {
                            "filter": {
                                "and": [
                                    {
                                        "term": {
                                            "format": 20
                                        }
                                    }
                                ]
                            },
                            "aggregations": {
                                "genres": {
                                    "terms": {
                                        "field": "genres",
                                        "size": 30
                                    }
                                }
                            }
                        },
                        "price": {
                            "filter": {
                                "and": [
                                    {
                                        "term": {
                                            "format": 20
                                        }
                                    }
                                ]
                            },
                            "aggregations": {
                                "prices": {
                                    "range": {
                                        "field": "price.converted_end",
                                        "ranges": [
                                            {
                                                "to": 5000
                                            },
                                            {
                                                "from": 5000,
                                                "to": 10000
                                            },
                                            {
                                                "from": 10000,
                                                "to": 50000
                                            },
                                            {
                                                "from": 50000
                                            }
                                        ]
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    },
    "from": 0
}