Mongoid Query for Array Field

Question

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?

Accepted Answer

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

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

Answer 2

You can use Criteria all_in to make it simpler:

Model.all_in(category: ['val1','val2'])

Answer 3

This worked

Model.where(:category.in => ['val1','val2'])

From Mongo Docs

Answer 4

Or another variant:

Model.in(category: ['val1','val2'])

Mongoid Query for Array Field

4 Answers

Must Read

Your Answer

Sarah Jenkins

Mongoid Query for Array Field

4 Answers

Must Read

Your Answer

Sign up or log in

Post as a guest

Sarah Jenkins