Elasticsearch query multiple subfields

Question

I'm curious if anyone knows how to query multiple subfields in an Elasticsearch index. For example records:

{
  "foo": [
    {
      "bar": "Good example",
      "subfield":  32
    }
  ]
},
{
  "foo": [
    {
      "bar": "Good example",
      "subfield":  50
    }
  ]
},
{
  "foo": [
    {
      "bar": "Bad example",
      "subfield":  32
    }
  ]
}

I'm hoping to build a query foo.bar = "Good example" AND foo.subfield = 32 where only the first record returns. Elasticsearch's query DSL or query string's are welcomed.

Chris Heald · Accepted Answer · 2019-10-30 20:48:40Z

5

You want a nested query.

{
  "query": {
    "nested": {
      "path": "foo",
      "query": {
        "bool": {
          "must": [
            { "term": { "foo.bar": "Good example" } },
            { "term": { "foo.subfield": 32 } }
          ]
        }
      }
    }
  }
}

Note that you'll have to update your mapping to include a nested field mapping, per the documentation.

answered Oct 30, 2019 at 20:48

Chris Heald

62.8k10 gold badges131 silver badges143 bronze badges

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

2 Comments

MarkII Over a year ago

already have the nested field type in the mapping, haven't tried with 'term' yet. But using the bool and match it returns all 3 objects.

MarkII Over a year ago

That worked! And realized my match usage was working too, I just was querying it wrong. Thanks!

Collectives™ on Stack Overflow

Elasticsearch query multiple subfields

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related