NOT condition in elasticsearch

Question

I am trying to implement NOT condition in elasticsearch query. Can I Implement filter inside bool or I need to write separate filter as below. Any optimum solution is there?

{
   "query": {
      "bool": {
     "must": [
        {
           "query_string": {
          "query": "fashion"
           }
        },
        {
           "term": {
          "post_status": "publish"
           }
        }
     ]
      }
   },
   "filter": {
      "not": {
     "filter": {
        "term": {
           "post_type": "page"
        }
     }
      }
   }
}

Victor Welling · Accepted Answer · 2013-12-04 10:07:44Z

7

You can use a must_not clause:

{
    "query": {
        "bool": {
            "must": [
                {
                    "match": {
                        "_all": "fashion"
                    }
                },
                {
                    "term": {
                        "post_status": "publish"
                    }
                }
            ],
            "must_not": {
                "term": {
                    "post_type": "page"
                }
            }
        }
    }
}

Also, I'd recommend using a match filter instead of query_string, as query_string requires the much more strict Lucene syntax (and is therefor more error prone), whereas match works more like a search box: it will automatically transform a human readable query to a Lucene query.

edited Dec 4, 2013 at 10:07

answered Dec 4, 2013 at 9:35

Victor Welling

1,89912 silver badges14 bronze badges

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

4 Comments

Roopendra Over a year ago

I really appreciate your suggestion. But I have tried your solution it does not return any records.

Roopendra Over a year ago

it seems problem in match query to search fashion keyword. when I remove match query part it returns data.

Victor Welling Over a year ago

Ah, I see: try changing the query property of the match clause to the name of the field you want to search. If you want to search multiple fields, have a look at multi_match.

Roopendra Over a year ago

Yeah !! Now working smoothly :) and also I am applicable to mark this as solutions. Thanks a lot @Victor Welling

Collectives™ on Stack Overflow

NOT condition in elasticsearch

1 Answer 1

4 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Related