OR query for Elasticsearch?

Question

elasticsearch

How can I make a query similar to SQL for ElasticSearch?

SELECT * FROM table WHERE ( field = 1 && field2 = 2) || (field3 = 3)

type

{
  "query": {
    "bool": {
       "must": [
          {"term": {"field": {"value": 1}}},
          {"term": {"field2": {"value": 2}}},
         // OR
          {"term": {"field3": {"value": 3}}}
        ]
     }
  }
}

Answer 1

Something like that, but now there is nothing to check on

{
  "query": {
    "bool": {
       "should": [
          {
            "bool" : {
                           "must" : [
                                            {"term": {"field": {"value": 1}}},
                                            {"term": {"field2": {"value": 2}}},
                                        ]   
                        }
           },
          {"term": {"field3": {"value": 3}}}
        ]
     }
  }
}