Rails mongoid query string in array of hashes

Question

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"))

What is your question?

fuz
– fuz

2015-09-01 20:07:52 +00:00
Commented Sep 1, 2015 at 20:07 — fuz
– fuz, Commented Sep 1, 2015 at 20:07

mu is too short · Accepted Answer · 2015-09-01 20:19:24Z

1

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 })

answered Sep 1, 2015 at 20:19

mu is too short

436k71 gold badges863 silver badges822 bronze badges

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

2 Comments

Guido Over a year ago

Thank you @mu_is_too_short! It worked. Could you reference me where to read more about ignoring the array as you have proposed?

mu is too short Over a year ago

The $eq operator docs are probably the best starting point. There used to be a section specifically about this behavior but it seems to have gone away.

Collectives™ on Stack Overflow

Rails mongoid query string in array of hashes

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