Elasticsearch bool query with nested as well as non-nested clauses

Question

I have data with nested as well as non-nested components. I cannot remap the data, it is in production. Sample is

{
   "name":[
      "first":"Tom",
      "last":"Smith"
   ],
   "status":"married"
}

I need to query within nested as well as non-nested values . Ie, all entries who are not 'married' but whose first names are 'Tom'.

To do a query just for 'Tom', I would do

GET /_search
{
  "query": {
    "nested": {
      "path": "name",
      "query": {
        "bool": {
          "must": [
            { 
              "match" : {"name.first" : "Tom"}}
          ]
        }
      }
    }
  }
}

But how do I combine this with a must_not query on status(which is non nested)

MrSimple · Accepted Answer · 2018-02-09 14:54:11Z

1

You need to put a must_not behind the must. I tested this in my environment (except I used term instead of match) and it filtered the unwanted elements.

GET /_search
{
  "query": {
    "nested": {
      "path": "name",
      "query": {
        "bool": {
          "must": [
            { 
              "match" : {"name.first" : "Tom"}}
          ],
          "must_not": [
            { 
              "match" : {"status" : "married"}}
          ]
        }
      }
    }
  }
}

answered Feb 9, 2018 at 14:54

MrSimple

5994 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch bool query with nested as well as non-nested clauses

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related