Elasticsearch match list against field

Question

I have a list, array or whichever language you are familiar. E.g. names : ["John","Bas","Peter"] and I want to query the name field if it matches one of those names.

One way is with OR Filter. e.g.

{
    "filtered" : {
        "query" : {
            "match_all": {}
        },
        "filter" : {
            "or" : [
                {
                    "term" : { "name" : "John" }
                },
                {
                    "term" : { "name" : "Bas" }
                },
                {
                    "term" : { "name" : "Peter" }
                }
            ]
        }
    }
}

Any fancier way? Better if it's a query than a filter.

score 26 · Accepted Answer · answered Apr 01 '14 at 07:54

{
  "query": {
    "filtered" : {
      "filter" : {
        "terms": {
          "name": ["John","Bas","Peter"]
        }
      }
    }
  }
}

Which Elasticsearch rewrites as if you hat used this one

{
  "query": {
    "filtered" : {
      "filter" : {
        "bool": {
          "should": [
            {
              "term": {
                "name": "John"
              }
            },
            {
              "term": {
                "name": "Bas"
              }
            },
            {
              "term": {
                "name": "Peter"
              }
            }
          ]
        }
      }
    }
  }
}

When using a boolean filter, most of the time, it is better to use the bool filter than and or or. The reason is explained on the Elasticsearch blog: http://www.elasticsearch.org/blog/all-about-elasticsearch-filter-bitsets/

Thanks, so [terms](http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-terms-query.html) is what I needed. I put in the query in my case — Diolor, Apr 01 '14 at 09:40

score 23 · Answer 2 · answered Nov 25 '18 at 18:43

As I tried the filtered query I got no [query] registered for [filtered], based on answer here it seems the filtered query has been deprecated and removed in ES 5.0. So I provide using:

{
    "query": {
        "bool": {
            "filter": {
                "terms": {
                    "name": ["John","Bas","Peter"]
                }
            }
        }
    }
}

score 0 · Answer 3 · answered Dec 24 '21 at 12:46

example query = filter by keyword and a list of values

{
    "query": {
        "bool": {
            "must": [
                {
                    "term": {
                        "fguid": "9bbfe844-44ad-4626-a6a5-ea4bad3a7bfb.pdf"
                    }
                }
            ],
            "filter": {
                "terms": {
                    "page": [
                        "1",
                        "2",
                        "3"
                    ]
                }
            }
        }
    }
}

Elasticsearch match list against field

3 Answers3

Linked