Elasticsearch query string query with not equal to?

Question

Usually with a query_string query in elasticsearch, I can do:

name:"Fred"

I want to find all documents where name is not equal to Fred. What is the proper syntax for that? I tried:

name!="Fred"

Though it returns 0 documents.

score 143 · Accepted Answer · answered Nov 15 '16 at 04:54

143

You need to use the NOT operator, like this:

!(name:"Fred")

or

NOT (name:"Fred")

answered Nov 15 '16 at 04:54

Val

207,596
13
358
360

11

For those wondering how to concat multiple values `NOT(key:value1 value2 value3)` – kemicofa ghost Dec 03 '19 at 15:29
@val can you help here please https://stackoverflow.com/questions/66331236/making-filter-query-with-elastic-search – svikramjeet Feb 24 '21 at 09:10

score 86 · Answer 2 · answered Nov 15 '16 at 05:03

86

You should use bool query with must_not statement

{
  "query": {
    "bool" : {
      "must_not" : {
        "term" : {
          "name" : "Fred"
        }
      }
    }
  }
}

answered Nov 15 '16 at 05:03

Vova Bilyachat

18,765
4
55
80

Why? Which is the better option, to use Query String query or your option? – RodriKing Jun 27 '18 at 12:06
@RodriKing there is not better option it depends what you are going to do. In current question question was how to filer on specific term this is why I would use term, query_string on other hand will split your search text to multiple terms. So basically it depends on what you want to achieve. – Vova Bilyachat Jun 27 '18 at 12:33
Ok thank you, another little question, please. I want to make a wildcard query, but wildcard queries do not apply to analized/filters (match query does). I want to apply the analysis of ignoring the accents of the words. As with wildcard queries I can't, I'm using query string queries. Would that be correct? – RodriKing Jun 27 '18 at 12:41
@RodriKing create separate question with example pls. – Vova Bilyachat Jun 27 '18 at 12:42

score 29 · Answer 3 · edited Sep 03 '21 at 02:34

You can also use a combination of must and must_not. Like pull docs where name is Ajit and status is not queued.

{
    "query": {
        "bool": {
            "must": [
                {
                    "match": {
                        "name": "Ajit"
                    }
                }
            ],
            "must_not": [
                {
                    "match": {
                        "status": "queued"
                    }
                }
            ]
        }
    }
}

Om Prakash · Answer 4 · 2020-07-28T05:08:40.067

and, or and not filters

***For "and" query:***

    "filtered" : {
        "query" : {
            "term" : { "name.first" : "shay" }
        },
        "filter" : {
            "and" : {
                "filters" : [
                    {
                        "term" : { "name.first" : "something" }
                    },
                    {
                        "term" : { "name.first" : "other" }
                    }
                ]
            }
        }
    }

***For "or" query:***

{
    "filtered" : {
        "query" : {
            "term" : { "name.first" : "shay" }
        },
        "filter" : {
            "or" : {
                "filters" : [
                    {
                        "term" : { "name.first" : "something" }
                    },
                    {
                        "term" : { "name.first" : "other" }
                    }
                ]
            }
        }
    }
}

***For "not" query:***

{
    "filtered" : {
        "query" : {
            "term" : { "name.first" : "shay" }
        },
        "filter" : {
            "not" : {
                "filter" :  {
                    "term" : { "name.first" : "someting" }
                }
            }
        }
    }
}

Elasticsearch query string query with not equal to?

4 Answers4