Mongoid query for array field

ruby-on-rails mongoid
mrudult picture mrudult · Nov 8, 2013 · Viewed 13.9k times · Source

I have a category field of type Array in Mongoid.

Ex. category: ["val1","val2","val3"]

Now I want to query this Model with `category: ["val1","val2"] such that it returns me the merge of

Model.where(category: "val1") and Model.where(category: "val2")

I can do it individually for each element of the array but that will be slow I guess because for every individual element it will search all the documents.

I also tried Model.all_of({category: "val1"},{category: "val2"}).all but that is not working.

How should I do this?

Answer

kd12 picture kd12 · Nov 8, 2013

In mongoid, there is '$in' operator. So you can do this :

Model.where(category: { '$in': ['val1', 'val2'] })

Related questions

Select where not null or empty in mongoid

I modified a model so it includes a new field, such as... field :url, :type => String I use activeadmin, so when I create a new entry @model.url is empty, and in entries created before changing the schema it's …

Read More
ERROR Original Error: ImageMagick/GraphicsMagick is not installed

I have an app that is using Imagemagick, but I had to rebuild my environment and now when I try and upload an avatar (which is why I am using Imagemagick), it keeps giving me the following error when I …

Read More
How to implement has_many :through relationships with Mongoid and mongodb?

Using this modified example from the Rails guides, how does one model a relational "has_many :through" association using mongoid? The challenge is that mongoid does not support has_many :through as ActiveRecord does. # doctor checking out patient class Physician &…

Read More