Term query on multiple fields based on a wildcard notation

[marb (Bruno)]

Hi all,

I'm trying to do an exact match on an unknown number of fields.
I know that we can do a fulltext search on a set of fields using a multi_match like:
{
"multi_match": {
"fields":"fieldprefix_* ",
"query": "foo"
}
}
Now I would like to do the equivalent with a term query:
{
"term": {
"fields":"fieldprefix_* ",
"query": "foo"
}
}
Obviously, this notation is not supported as well as
{
"term": {
"fieldprefix_*": "foo"
}
}
So what is the closest syntax to achieve this use case? (of course, I don't know the name of all the fields starting by "fieldprefix_"

Thanks

[marb (Bruno)]

bump up this one.
Does it mean there is no equivalent for an exact match?

[abdon (Abdon Pijpelink)]

You could override the analyzer in the query to use the keyword analyzer. That way, you'll be using the multi_match query to search for exact terms:

{
  "query": {
    "multi_match": {
      "fields": "fieldprefix_*",
      "query": "foo",
      "analyzer": "keyword"
    }
  }
}

[marb (Bruno)]

thank you that's a very good idea and it indeed works.

So one more questions, how would you do the equivalent with terms?
terms accepts a list of values and not a single value.

Would you just use a should clause to test each individual value?

Thx

[abdon (Abdon Pijpelink)]

Yeah, a bool query with a number of queries in a should clause is probably the best way.