ruby-on-railsmongodbmongoidmongoid3querying

Rails mongoid query string in array of hashes

I have a Model that is called teams.

When I do Teams.account_ids it returns something like:

 [{"_id"=>"145952912234658", "_type"=>"Page"},
 {"_id"=>"465641870160985", "_type"=>"Account"}]

Lets say I want to get all Teams that have one specific account id regardless of its _type.

Something like:

Team.where(some_id.in => account_ids.map{|k| k["_id"))
Solution

  • You can use multi-keys to effectively ignore the array when searching and then use the standard "key inside a hash" notation to look at the _ids:

    Teams.where('account_ids._id' => { :$in => array_of_ids })