Nested boolean queries in elastic search

Question

I am trying to make a query in elastic search that will do the following: I want it to check for a result that has (metropolitan_area of 16 AND starts_at of 05072013) OR (metropolitan_id of 16 AND starts_at "blank".

This is my current query, but I feel like it needs to be nested somehow and I am unsure how to do that.

{
  "query" : { 
    "bool" : {
      "must" : [
        {
          "term" : {"user" : "a"}
        }, 
        { 
          "term" :{"metropolitan_area" : "16"}
        }
      ], 
      "must_not" : [], 
      "should" :   []
    }
  }, 
  "filter" : {
    "or" : {
      "filters" : [
        {
          "term" : {"user":"519"}
        }, 
        {
          "term" : {"user":"6"}
        }, 
        {
          "term" : {"user":"5"}
        }, 
        {
          "term" : {"user":"36"}
        }, 
        {
          "term" : {"starts_at":"05072013"}
        }, 
        {
          "term" : {"starts_at":"blank"}
        }
      ]
    }
  }
}

see also Nesting Boolean Queries

Ricardo
– Ricardo

2018-02-09 00:56:32 +00:00
Commented Feb 9, 2018 at 0:56 — Ricardo
– Ricardo, Commented Feb 9, 2018 at 0:56

mbj · Accepted Answer · 2013-04-26 19:53:02Z

12

The correctly nested boolean expression is shown below:

{
  "filter": {
    "or" : [{
       "and" : [
          { "term" : { "metropolian_area" : 16 } },
          { "term" : { "starts_at" : 0123213 } }
       ]
    }, {
       "and" : [
          { "term" : ... },
          { "term" : ... }
       ]
    }]
  }
}

answered Apr 26, 2013 at 19:53

mbj

1,0429 silver badges19 bronze badges

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

4 Comments

Churro Over a year ago

Do you happen to know the answer to this question? I've tried all sorts of things, but still had no luck. stackoverflow.com/questions/18647228/…

mbj Over a year ago

I'm busy, can you ping me in #rom-rb at freenode later the week? I think I can help you, it looks easy.

Zouzias Over a year ago

Is there a way to provide the same functionality with "Boolean queries"?

csdaraujo Over a year ago

elastic.co/guide/en/elasticsearch/guide/master/…

Dorjee Dhondup · Accepted Answer · 2018-09-22 00:55:46Z

and, or, and not queries are deprecated in elasticsearch 2.x. Elasticsearch documentation recommends the bool query instead. For instance, you could write your nested bool query as follow in filter context:

{
  "query":{
    "bool":{
      "must":[
        {
          "term":{
            "user":"a"
          }
        },
        {
          "term":{
            "metropolitan_area":"16"
          }
        }
      ],
      "filter":{
        "bool":{
          "should":[
            {
              "term":{
                "user":"519"
              }
            },
            {
              "term":{
                "user":"6"
              }
            },
            {
              "term":{
                "user":"5"
              }
            },
            {
              "term":{
                "user":"36"
              }
            },
            {
              "term":{
                "starts_at":"05072013"
              }
            },
            {
              "term":{
                "starts_at":"blank"
              }
            }
          ]
        }
      }
    }
  }
}

Collectives™ on Stack Overflow

Nested boolean queries in elastic search

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related