Elastic search Not filter inside and filter

Question

I am trying to add a "not" filter inside "and" filter

Sample input:

{
   "query":{
      "filtered":{
         "query":{
            "query_string":{
               "query":"error",
               "fields":[
                  "request"
               ]
            }
         },
         "filter":{
            and:[
               {
                  "terms":{
                     "hashtag":[
                        "br2"
                     ]
                  },
                  "not":{
                     "terms":{
                        "hashtag":[
                           "br1"
                        ]
                     }
                  }
               }
            ]
         }
      }
   }
},

}

But above is giving error, i also tried various combination but in vain. Above is just an example in short i require a query in which both "and", "not" filter are present.

Provinciality

Answer 1

you forgot the "filters" array.

Write it like this :

{
    "from" : 0,
    "size" : 25,
    "query" : {
        "filtered" : {
            "query" : {
                "match_all" : {}

            },
            "filter" : {
                "and" : {
                    "filters" : [{
                            "term" : {
                                "field1" : "val1"
                            }                           
                        }, {
                            "not" : {
                                "filter" : {
                                    "term" : {
                                        "field2" : "val2",
                                    }
                                }
                            }
                        }
                    ]
                }
            }
        }
    }
}

Ptarmigan