Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Query on Mongoid Hash Field

I want to query on a Hash field for a Mongoid Class. I'm not sure how I can do this with conditions?

Here is an example:

class Person   include Mongoid::Document    field :things, :type => Hash end 

So, let's say that I have this:

p = Person.new p.things = {} p.things[:tv] = "Samsung" 

I want to query for the first person with a tv that is a Samsung...

People.first(:conditions => ????? 

Thanks in advance.

like image 447
JP Richardson Avatar asked Nov 22 '10 04:11

JP Richardson


1 Answers

Person.where('things.tv' => 'Samsung').first 

This is where Mongoid and MongoDB really shine. Mongoid's Criteria methods (Person.where, Person.any_of, Person.excludes, etc.) will give you much more flexibility than the ActiveRecord-style finders (passing a :conditions hash to Person.find, Person.first, etc.)

Mongoid's site has some great documentation on how to use Criteria:

http://mongoid.org/en/mongoid/docs/querying.html

like image 184
bowsersenior Avatar answered Sep 23 '22 17:09

bowsersenior