Tire (Elastic Search) Nil Comparison

Question

For Tire (ElasticSearch wrapper gem), how do you query and filter out indexed records that has nil/null value for a certain attribute. For example, if I have this relationship

class Article < ActiveRecord::Base
  belongs_to :topic
end

I have article indexed but I want to avoid pulling back records with topic_id = nil. I tried this code blow but it didn't work.

class Article
  belongs_to :topic

  def search(q)
    tire.search do
       ...
         filter :missing, :field => :topic_id, { :existence => false, :null_value => false }
         ...
         ### filter :range, :topic_id => { :gt => 0 } # ==> I tried this as well but didn't work
       ...
    end
  end
end

score 2 · Answer 1 · answered Sep 12 '12 at 09:27

I think you should use exists filter if you want to filter only documents with existing topic_id value.

class Article
  belongs_to :topic

  def search(q)
     tire.search do
       ...
       filter :exists, :field => :topic_id
       ...
    end
  end
end

Or you can use query string with _exists_:topic_id query.

score 1 · Answer 2 · answered Jan 10 '13 at 06:16

1

Please try:

class Article
  belongs_to :topic

  def search(q)
    tire.search do
         ...
         filter :not, :missing => {:field => :topic_id, { :null_value => true } }
         ...
    end
  end
end

This should work. existence is required if you want to check if the field exists or not. I guess you just need the null_value check.

answered Jan 10 '13 at 06:16

Vamsi Krishna

3,742
4
20
45

You cannot set both null_value and existence to false. Atleast one or both should be set to true. – Vamsi Krishna Jan 10 '13 at 06:56

score -3 · Answer 3 · answered Sep 10 '12 at 17:40

-3

@articles = Article.where('topic_id is not ?' , nil)

answered Sep 10 '12 at 17:40

sagar pant

377
1
2
12

Sorry but this is for the Tire gem DSL (ElasticSearch wrapper). Not ActiveRecord. – RubyFanatic Sep 10 '12 at 18:04

Tire (Elastic Search) Nil Comparison

3 Answers3