How to filter search by attribute only if it exists using ElasticSearch and Tire?

Question

Right now I wrote

Tire.search INDEX_NAME do
  query do
    filtered do
      query { string term }
      filter :or, { missing: { field: :app_id } },
                  { terms: { app_id: app_ids } }
    end
  end
end.results.to_a

Frederick Cheung · Accepted Answer · 2013-01-10 14:28:16Z

1

Well returning items that either have no app_id or one that matches your terms sounds like a job for an or filter - I'd try

filter :or, [
    {:not => {:exists => {:field => :app_id}}},
    {:terms => {:app_id => app_ids}}
  ]

answered Jan 10, 2013 at 14:28

Frederick Cheung

84.3k9 gold badges157 silver badges175 bronze badges

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

2 Comments

tomekfranek Over a year ago

You solution has any advantages over my missing filter? filter :or, { missing: { field: :app_id } }

Frederick Cheung Over a year ago

Don't think so, although your missing thing easn't there when I wrote my post

Collectives™ on Stack Overflow

How to filter search by attribute only if it exists using ElasticSearch and Tire?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related