Tire/Elasticsearch Filtering on Attribute

Question

so when clients are logged into the app they should only be able to search within their company so we are trying to filter on client name. The log output appears to be correct though but no search results are being returned.

#report.rb
def self.search_for_client(params, client)
 tire.search(load: true, page: params[:page], per_page: 20) do
  query  { string params[:q] } if params[:q].present?
  filter :term, :client => client
 end
end

#reports_controller.rb
def full_search
 @query = params[:q]
 if current_user.client.nil?
  @results = Report.search params
 else
  @results = Report.search_for_client params, current_user.client.title
 end
end

#log output
curl -X GET 'http://localhost:9200/reports/report/_search?load=true&size=20&pretty' -d '{"query":{"query_string":{"query":"thio"}},"filter":{"term":{"client":"ApplusRTD Norway"}},"size":20}'

Is your client term "ApplusRTD Norway" analyzed in your index? Term filters don't analyze the term provided elasticsearch.org/guide/en/elasticsearch/reference/current/… — Michael at qbox.io
– Michael at qbox.io, Commented Apr 24, 2014 at 15:18
Also you may want to use elasticsearch.org/guide/en/elasticsearch/reference/current/… instead of a queryStringquery and a filter. Zachary Tong gives a great explanation in his slide show here: speakerdeck.com/polyfractal/elasticsearch-query-optimization — Michael at qbox.io
– Michael at qbox.io, Commented Apr 24, 2014 at 15:21

Saeed Zhiany · Accepted Answer · 2016-12-06 07:24:29Z

1

Actually the main issue was that I was not restarting the elasticsearch server after indexing. I've tweaked the search_for_client method also.

#report.rb
def self.search_for_client(params, client)
tire.search(load: true, page: params[:page], per_page: 20) do
  query do
    boolean do
      must { string params[:q], default_operator: "AND" } if params[:q].present?
      must { string 'status:active' }
    end
  end
  filter :term, :client => [client]
end

end

#output
curl -X GET 'http://localhost:9200/reports/report/_search?size=20&pretty' -d '{
  "query": {
    "bool": {
      "must": [
        {
          "query_string": {
            "query": "UT-12-541"
          }
        }
      ]
    }
  },
  "filter": {
    "term": {
      "client": [
        "Fabricom GDF Suez"
      ]
    }
  },
  "size": 20
}'

edited Dec 6, 2016 at 7:24

Saeed Zhiany

2,1419 gold badges34 silver badges44 bronze badges

answered Apr 27, 2014 at 6:35

depassion

511 silver badge6 bronze badges

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

Collectives™ on Stack Overflow

Tire/Elasticsearch Filtering on Attribute

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related