Match query with multiple values

Question

I have a list of values and I want all documents that have any of these values in their product_code field.

I tried this, but even though it doesn't give an error, it only gives me one of the documents:

"query": {
  "match": {
    "product_code": {
      "query": ["ABC 4", "ABC 5"]
    }
  }
}

So I'm basically looking for the functionality of the terms filter, but with analysis.

Of course I could do:

"bool": {
  "should": [
    {
      "query": {
        "match": {
          "product_code": "ABC 4"
        }
      }
    },
    {
      "query": {
        "match": {
          "product_code": "ABC 5"
        }
      }
    }
  ]
}

but this gets rather verbose for long lists.

product_code is defined like this:

"product_code": {
  "type": "string",
  "analyzer": "product_code",
}

with the product_code analyzer:

"product_code": {
  "type": "custom",
  "filter": [
    "lowercase",
    "trim"
  ],
  "tokenizer": "keyword"
}

Dan Tuffery · Accepted Answer · 2014-10-01 08:04:58Z

1

There isn't an equivalent of the terms query for match AFAIK. Another option is the query_string which is less verbose:

{
  "query": {
    "query_string": {
      "default_field": "product_code",
      "query": "\"ABC 4\" OR \"ABC 5\""
    }
  }
}

http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/query-dsl-query-string-query.html

answered Oct 1, 2014 at 8:04

Dan Tuffery

5,92433 silver badges29 bronze badges

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

2 Comments

AndreKR Over a year ago

This looks good... are there any special characters I have to escape inside the quotes besides other quotes? Or just put no quotes but escape everything special including the space?

Dan Tuffery Over a year ago

You'll need to escape the special characters that Lucene lists here:lucene.apache.org/core/2_9_4/queryparsersyntax.html#Escaping Special Characters

Dror · Accepted Answer · 2014-10-01 08:00:15Z

0

I might be missing something, but how about:

{
    "constant_score" : {
        "filter" : {
            "terms" : { "product_code" : ["ABC 4", "ABC 5"]}
        }
    }
}

Could this be what you're looking for?

answered Oct 1, 2014 at 8:00

Dror

13.2k24 gold badges101 silver badges171 bronze badges

2 Comments

AndreKR Over a year ago

Does it analyze the terms?

Dan Tuffery Over a year ago

The terms query doesn't analyze terms.

Collectives™ on Stack Overflow

Match query with multiple values

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related