ElasticSearch Filter by Array Field Not containing certain values

Question

I have the following data set:

[
  {
    "name": "Name 1",
    "countries": [
      "AF", "AL", "DZ", "AS", "AD", "AO", "AI", "AQ", "AG", "AR", "AM", "AW", "AU", "AT", "AZ", "BS", "BH", "UM", "BD", "BB", "BY", "BE", "BZ", "BJ", "BM", "BT", "BO", "BA", "BW", "BV", "BR", "IO", "BN", "BG", "BF", "BI", "KH", "CM", "CA", "CV", "KY", "CF", "TD", "CL", "CN", "CX", "CC", "CO", "KM", "CG", "CK", "CR", "HR", "CU", "CY", "CZ", "DK", "DJ", "DM", "DO", "TP", "EC", "EG", "SV", "GQ", "ER", "EE", "ET", "FK", "FO", "FJ", "FI", "FR", "FX", "GF"
    ]
  },
  {
    "name": "Name 2",
    "countries": [
      "US", "GB"
    ]
  }
]

How can I filter items which DO NOT contain certain specific countries like ["GB", "FR"].

That do not contain BOTH of them or ANY of them?

Jozef - Spatialized.io
– Jozef - Spatialized.io

2020-03-20 11:14:18 +00:00
Commented Mar 20, 2020 at 11:14 — Jozef - Spatialized.io
– Jozef - Spatialized.io, Commented Mar 20, 2020 at 11:14
That do not contain any of them

Dev Sahoo
– Dev Sahoo

2020-03-20 15:31:30 +00:00
Commented Mar 20, 2020 at 15:31 — Dev Sahoo
– Dev Sahoo, Commented Mar 20, 2020 at 15:31

Karthick Vinod · Accepted Answer · 2020-03-20 12:05:17Z

4

Assuming that countries is a field of type keyword, the below query should return items which do not contain ANY of the countries.

{
  "query": {
    "bool": {
      "must_not": [
        {
          "terms": {
            "countries": [
              "GB",
              "FR"
            ]
          }
        }
      ]
    }
  }
}

answered Mar 20, 2020 at 12:05

Karthick Vinod

1,49710 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

ElasticSearch Filter by Array Field Not containing certain values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related