Filtering a multi_match query in elasticsearch by another field

Question

I'm trying to perform a search with ElasticSearch, that must match some search terms in the sections index, but only for sections that belong to certain projects, namely, the projects to which the current user has access.

So I'm trying to apply a filter to the query, so that it will filter sections that have the project_id included in a small set of 2 or 3 different values. If a section's project_id is among the valid project_id's, it should be included. Otherwise it won't.

This is all in the context of a rails api using the elasticsearch-model gem.

This is the query I'm passing in. It pretends to filter sections, so that only sections in projects 2 and 5 are included in the results.

{
  "query": {
    "filtered": {
      "query": {
        "multi_match": {
          "query": "search terms here",
          "type": "cross_fields",
          "fields": ["title^3", "contents"],
          "operator": "and"
        }
      },
      "filter": {
        "or": {
          "filters": [
            { "exists": { "project_id": 2 } },
            { "exists": { "project_id": 5 } }
          ]
        }
      }
    }
  }
}

And I get this error:

QueryParsingException[[sections] [exists] filter does not support [project_id]]

Any ideas?

Giacomo1968 · Accepted Answer · 2016-10-10 15:18:54Z

8

The exist filter means checking the fields is exist or not.refer.

To get what you trying to achieve.

 {
 "query": {
  "filtered": {
     "query": {
        "multi_match": {
           "query": "search terms here",
           "type": "cross_fields",
           "fields": [
              "title^3",
              "contents"
           ],
           "operator": "and"
        }
     },
     "filter": {
        "terms": {
           "project_id": ["1","2"]
        }
      }
    }
  }
}

HOpe it helps..!

edited Oct 10, 2016 at 15:18

Giacomo1968

25.3k11 gold badges78 silver badges106 bronze badges

answered May 14, 2014 at 6:07

BlackPOP

5,7572 gold badges36 silver badges49 bronze badges

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

1 Comment

Ernesto Over a year ago

Thanks! Even simpler than what I was doing with that weird "or" filter. This was more alike to how I thought initially it would be, but the documentation I found on the "terms" filter didn't have any examples using an array for possible values. Thanks a lot!

Collectives™ on Stack Overflow

Filtering a multi_match query in elasticsearch by another field

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related