Elasticsearch bool query must match single field single term, and another field with OR terms

Question

I want to find a document with a name that contains 'Bob' and has a location that is in either 'paducah' or 'smyrna'.

Here's what I have now:

query: {
  bool: {
    must: [
      { match: { name: 'bob' } }, 
      { match: { location: ['paducah', 'smyrna'] } }
    ],
  },
},

I know the problem is in the location array, because if i change it to a single element with no array the query works just fine.

This is the closest answer i could find.

It didn't work, i receive the following error:

[term] malformed query, expected [END_OBJECT] but found [FIELD_NAME]

score 3 · Accepted Answer · answered Jul 23 '17 at 16:12

You could try this query:

{
    "query": {
      "bool": {
        "must": [
          { "match": { "name": "bob" } }
        ],
        "should": [
            { "match": { "location": "paducah" }},
            { "match": { "location": "smyrna"   }}
          ],
          "minimum_should_match": 1
      }
    }
}

score 0 · Answer 2 · answered Jul 23 '17 at 16:07

What about the following:

{
  "query": {
    "bool": {
      "must": [
        { "term": { "name": "bob" }, 
        "bool": {
          "should": [
            {"term": {"location": "paducah"}},
            {"term": {"location": "smyrna"}}
          ]
        }
        }
      ]
    }
  }
}

Elasticsearch bool query must match single field single term, and another field with OR terms

2 Answers2