How do you filter a query with elasticsearch-rails gem?

Question

I have a Piece model with a boolean attribute of published.

I want the search results to only contain Pieces that are plublished: true.

My index action for the PiecesController is:

def index
    @list = params[:list]
    @sort = params[:sort]
    if params[:q]
      @pieces = Piece.search(params[:q]).records
    else
      @pieces = Piece.all_in_category(@list, @sort)
    end
end

From searching around it seems that I should overwrite the search method in the Piece controller but I am not sure the correct way of doing this to maintain the current search methods functionality.

What is the best way to filter the elasticsearch results using the elasticsearch-rails gem?

does adding a scope to Piece work? eg. scope :published, -> {where(published: true)} and then calling Piece.published.search(params[:q]).records? I have limited experience with elastic but it is very well documented so I would start there. — engineersmnky
– engineersmnky, Commented Jun 30, 2015 at 17:46
No unfortunately not, I did try that but had no luck. I haven't been able to work out how the gem api lets you assign the filter property that the elasticsearch documentation talks about. I may end up switching to the chewy gem instead at this rate :) — Cu1ture
– Cu1ture, Commented Jun 30, 2015 at 17:49
Yeah it sound like you will need to modify the hash that is passed in which means it might be easier to just build the hash and inject the appropriate query methods. This I can help with if you show me what your search object params[:q] looks like. Or checkout elastic-scopes as it seems to modify AR scope to fit nicely with elasticsearch — engineersmnky
– engineersmnky, Commented Jun 30, 2015 at 19:02

Aaron Breckenridge · Accepted Answer · 2022-12-09 19:30:43Z

2

Try this format:

Elasticsearch v2.4

@customers = Customer.__elasticsearch__.search(
        query: { 
          bool: {
            filter: {
              term: {"account_id" => current_account.id.to_s}
            },
            must: {
              query_string: {
                query: "*#{params[:q]}*"
              }
            }
          },
        },
        size: options[:per_page],
        from: options[:from]
      ).records

edited Dec 9, 2022 at 19:30

Aaron Breckenridge

1,82919 silver badges26 bronze badges

answered Nov 28, 2016 at 22:29

Oleksandr Bondar

413 bronze badges

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

Comments

CoupDeMistral · Accepted Answer · 2015-06-30 21:22:24Z

-1

have you tried

@pieces = Piece.search(params[:q]).records.where(published: true)

it works on one of my ES models

answered Jun 30, 2015 at 21:22

CoupDeMistral

1981 silver badge9 bronze badges

2 Comments

Cu1ture Over a year ago

Yes this works however it is filtering the records in the sql db query rather than the elasticsearch index query. I would prefer to do it in the elasticsearch query to prevent loading unnecessary query data and taking advantage of the elasticsearch index filter abilities. I've decided to switch to the chewy gem now because this has a really neat api for filtering queries thats much more accessible.

freeze Over a year ago

We need to filter on elasticsearch. Not a solution in most cases.

Collectives™ on Stack Overflow

How do you filter a query with elasticsearch-rails gem?

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related