How to combine multiple bool queries in elasticsearch

Question

I want to create the equivalent of the following query -

(city = 'New York' AND state = 'NY') AND ((businessName='Java' and businessName='Shop') OR (category='Java' and category = 'Shop'))

I tried different combinations of bool queries using must and should but nothing seems to be working. Can this be done?

I am not able to come up with the right syntax. Always get some parsing exception. — user1935449
– user1935449, Commented Apr 3, 2016 at 19:10

Marc · Accepted Answer · 2018-01-05 14:37:53Z

33

How about something like this:

{
    "query": {
        "match_all": {}
    },
    "filter": {
        "bool": {
            "must": [
                {
                    "term": {
                        "city": "New york"
                    }
                },
                {
                    "term": {
                        "state": "NY"
                    }
                },
                {
                    "bool": {
                        "should": [
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "term": {
                                                "businessName": "Java"
                                            }
                                        },
                                        {
                                            "term": {
                                                "businessName": "Shop"
                                            }
                                        }
                                    ]
                                }
                            },
                            {
                                "bool": {
                                    "must": [
                                        {
                                            "term": {
                                                "category": "Java"
                                            }
                                        },
                                        {
                                            "term": {
                                                "category": "Shop"
                                            }
                                        }
                                    ]
                                }
                            }
                        ]
                    }
                }
            ]
        }
    }
}

edited Jan 5, 2018 at 14:37

Marc

1398 bronze badges

answered Apr 3, 2016 at 20:18

scottjustin5000

1,35612 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sarath Kumar Over a year ago

I think you might add minimum_should_match for should query

nonNumericalFloat Over a year ago

Still working in v7.5 - don't forget to remove/check the placement of minimum_should_match for queries as you could end up getting no results at all if you'r having a must query.

Collectives™ on Stack Overflow

How to combine multiple bool queries in elasticsearch

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related