How to implement elastic search not filter?

Question

I am using elastic search version 1.7.5

I've taken some ideas from this post: Elastic search Not filter inside and filter

the query below does not seem to be filtering out the items that are associated with item_category_id 17. Is there a syntax error that you can see? The terms defined outside the not, inside the filters array are working fine.

      {
      query: {
          filtered: {
              filter: {
                  and: {
                      filters: [
                          { not: {
                                  filter: {
                                      terms: {item_category_ids: [17] }
                                  }
                              }
                          },
                          { term: { user_inactive: false } },
                          { term: { kind: 1 } }
                      ]
                  }
              }
          }
      }

Val · Answer 1 · 2016-12-14T15:15:45.383

8

The filtered and and/not queries have been deprecated in ES 2.0, you should use bool/filter/must_not instead like this:

{
  "query": {
    "bool": {
      "filter": [
        {
          "bool": {
            "must_not": {
              "terms": {
                "item_category_ids": [
                  17
                ]
              }
            }
          }
        },
        {
          "term": {
            "user_inactive": false
          }
        },
        {
          "term": {
            "kind": 1
          }
        }
      ]
    }
  }
}

For ES 1.7, you need to change the query to this:

{
  "query": {
    "constant_score": {
      "filter": {
        "bool": {
          "must_not": {
            "terms": {
              "item_category_ids": [
                17
              ]
            }
          },
          "must": [
            {
              "term": {
                "user_inactive": false
              }
            },
            {
              "term": {
                "kind": 1
              }
            }
          ]
        }
      }
    }
  }
}

edited Dec 14 '16 at 15:15

answered Dec 14 '16 at 04:34

Val

207,596
13
358
360

I'm sorry, I should have specified I am using elastic search version 1.7.5 – malexanders Dec 14 '16 at 14:44
No that's a query for ES 2 and later. I've updated my answer – Val Dec 14 '16 at 15:16
I don't actually need to calculate a score for each post document, 'constant score' is unnecessary. The Query i posted below is what I'm after. – malexanders Dec 14 '16 at 22:39
`constant_score` is a query that will always return score 1, exactly like `filtered`. It's a way of only providing a filter (no score) and no queries. – Val Dec 15 '16 at 05:41
So, you are saying a default score is applied when using filtered? As in the example shown below? – malexanders Dec 19 '16 at 15:34
yes, but since that solution works for you, just use it. – Val Dec 19 '16 at 15:35
Thanks for the input. – malexanders Dec 19 '16 at 15:36

malexanders · Accepted Answer · 2016-12-14T23:12:03.607

This is what I'm after.

{
      query: {
          filtered: {
              filter: {
                  and: [
                      { terms: { published_posted_community_ids: @community_ids } },
                      { term: { user_inactive: false } },
                      { terms: { kind: 1 } },
                      { not: { terms: { item_category_ids: 17 } } }
                  ]
              }
          }
      }
  }

How to implement elastic search not filter?

2 Answers2