How to use bool to limit Elasticsearch query results?

Question

In my Rails app I have 2 models: User(id) & Document(id,user_id, document_title,document)

  def self.search(query)
    __elasticsearch__.search(
      {
        query: {
          multi_match: {
            query: query,
            fields: ['document_title^10', 'document']
          }
        },
      }
  end

I'm using the above search query which works great for return results across the entire table. The problem is, the results are not limited to the current_user. I'm trying to update the search method to only return results for the current_user. Per the docs, I'm doing:

  def self.search(query, user_id)
    __elasticsearch__.search(
      {
        bool: {
          filter: ["user_id", user_id]
        },
        query: {
          multi_match: {
            query: query,
            fields: ['document_title^10', 'document']
          }
        },
      }
  end

However, that is erroring with:

[400] {"error":{"root_cause":[{"type":"search_parse_exception","reason":"failed to parse search source. unknown search element [bool]","line":1,"col":2}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"query","grouped":true,"failed_shards":[{"shard":0,"index":"documents","node":"52GAD0HbT4OlekjesTZY_A","reason":{"type":"search_parse_exception","reason":"failed to parse search source. unknown search element [bool]","line":1,"col":2}}]},"status":400}

Frederick Cheung · Accepted Answer · 2016-07-04 19:50:13Z

2

I'm not sure what docs you are looking at but that query isn't right: the multi match query should be in the must clause of the bool query.

{
   query: {
     bool: {
       must: [{
        multi_match: {...}
      }],
      filter: [{
        term: {user_id: user_id}
      }]
    }
  }
}

edited Jul 4, 2016 at 19:50

answered Jul 4, 2016 at 18:26

Frederick Cheung

84.3k9 gold badges157 silver badges175 bronze badges

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

3 Comments

AnApprentice Over a year ago

thank you. Are any updates required to the index to make this work? Thanks

AnApprentice Over a year ago

hmm, I'm getting "unknown search element [bool]"

Frederick Cheung Over a year ago

The query does need to go inside the query top level element

Collectives™ on Stack Overflow

How to use bool to limit Elasticsearch query results?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related