Combining Multiple Queries with 'OR' or 'AND' in Elasticsearch

Question

I have two distinct query, and I want to combine them with an 'OR'/'AND' in between. How do I do that?

For example, for the given queries I just want to run Query1 OR Query2 in the elasticsearch.

Query1:

{
   "query": {
      "filtered": {
         "query": { 
            "query_string":{  
               "query":"Batman",
               "default_operator":"AND",
               "fields"::[  
                  "Movies._all"
               ]
            }
         },
         "filter": {
            "bool": {
               "must": [  
                  {  
                     "query":{  
                        "filtered":{  
                           "filter":{  
                              "and":[  
                                 {  
                                    "term":{  
                                       "cast.firstName":"Christian "
                                    }
                                 },
                                 {  
                                    "term":{  
                                       "cast.lastName":"Bale"
                                    }
                                 }
                              ]
                           }
                        }
                     }
                  }
               ]
            }
         }
      }
   }
}

Query2:

{
   "query": {
      "filtered": {
         "query": { 
            "query_string":{  
               "query":"Dark Knight",
               "default_operator":"AND",
               "fields"::[  
                  "Movies._all"
               ]
            }
         },
         "filter": {
            "bool": {
               "must": [  
                  {  
                     "query":{  
                        "filtered":{  
                           "filter":{  
                              "and":[  
                                 {  
                                    "term":{  
                                       "director.firstName":"Christopher"
                                    }
                                 },
                                 {  
                                    "term":{  
                                       "director.lastName":"Nolan"
                                    }
                                 }
                              ]
                           }
                        }
                     }
                  }
               ]
            }
         }
      }
   }
}

tomasbasham · Accepted Answer · 2015-12-12 02:16:02Z

16

You need to use a bool query Something like below will work fine -

{
  "query" : {
    "bool" : { 
      "must" : [
        { // Query1 },
        { // Query2}
      ]
    }
  }
}

Use must for AND and should for OR

edited Dec 12, 2015 at 2:16

tomasbasham

1,7432 gold badges20 silver badges42 bronze badges

answered Feb 19, 2015 at 4:43

Vineeth Mohan

19.4k9 gold badges70 silver badges81 bronze badges

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

1 Comment

GrantD71 Over a year ago

This doesn't work as I would expect. It still returns documents even if one of the must clauses doesn't hit.

Collectives™ on Stack Overflow

Combining Multiple Queries with 'OR' or 'AND' in Elasticsearch

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related