How to use nested filters in Elasticsearch?

Question

I have a set of articles. I want to filter on tags AND host.

E.g I want all articles that are tagged with 'news' OR 'sport' AND has the 'host' set to 'cnn.com' OR 'bbc.com'.

I tried to create this nested bool filter, but that did not work. It also returns articles from other hosts. Any suggestions?

GET _search
{
    "query": {
      "filtered": {
        "query": {
          "match_all": {}
        },
        "filter": {
          "bool": {
            "should": [
              // Match one or more of these tags.
              { "term" : { "tags" : "sport"} },
              { "term" : { "tags" : "news"} },
              { "bool": { 
                // Only from one of these hosts.
                "should": [
                  { "term": { "host": "bbc.com" } },
                  { "term": { "host": "cnn.com" } }
                ]
              }}
            ]
          }
        }
      }
    }
}

martins · Accepted Answer · 2015-08-25 11:57:23Z

Nesting the query like this worked. :-)

GET _search
{
    "query": {
      "filtered": {
        "query": {
          "match_all": {}
        },
        "filter": {
          "bool": {
            "must": [

              { "bool": {
                "should": [
                  { "term" : { "tags" : "sport"} },
                  { "term" : { "tags" : "news"} }
                ]
              }},

              { "bool": { 
                "should": [
                  { "term": { "host": "bbc.com" } },
                  { "term": { "host": "cnn.com" } }
                ]
              }}
            ]
          }
        }
      }
    }
}

Collectives™ on Stack Overflow

How to use nested filters in Elasticsearch?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related