elasticsearch - Elastic search combine two must with OR

Question

I need to achieve following logic in elasic search

(ticketype=1 AND customerid= id AND available >1) OR(tickettype = 2 AND available >1 )

I have below query with me

"query": {
                          "bool": {
                             "minimum_should_match": 1,
                             "should": [
                              {
                                 "bool": {
                                   "must": [
                                      {
                                         "range": {
                                            "ticket_group.available": {
                                               "gte": 1
                                            }
                                         }
                                      },
                                      {
                                         "match": {
                                            "ticket_group.customer_id": (q.customer_id) ? q.customer_id : ""
                                         } 
                                      },
                                      {
                                         "match": {
                                            "ticket_group.ticket_type": 1
                                         }
                                      }
                                   ]
                                }
                             }
                             ,
                              {  
                                 "bool":{  
                                        "must":[  
                                           {  
                                              "range":{  
                                                 "ticket_group.available":{  
                                                    "gte":1
                                                 }
                                              }
                                           },
                                           {  
                                              "match":{  
                                                 "ticket_group.ticket_type":2
                                              }
                                           }
                                        ]
                                     }
                              }

                           ]
                          }

                       }

But it seems that it is taking all conditions in AND even after use of should. What should be the correct query ?

Answer 1

I have used nested query, without it search on nested properties does not work properly. I have simplified your query to AND ((ticketype=1 AND customerid = id) OR ( tickettype = 2 ) ) AND available >1

Try following query:

{
"query": {
  "nested": {
     "path": "ticket_group",
     "query": {
        "bool": {
           "must": [
              {
                 "range": {
                    "ticket_group.available": {
                       "gte": 1
                    }
                 }
              },
              {
                 "bool": {
                    "minimum_should_match": 1,
                    "should": [
                       {
                          "match": {
                             "ticket_group.ticket_type": 2
                          }
                       },
                       {
                          "match": {
                             "ticket_group.customer_id": 1
                          }
                       }
                    ]
                 }
              }
           ]
        }
     }
   }
  }
 }