How can I search an array of subdocument fields that match a given array

Question

Say I have a collection of recipes that match this format:

{
  title: "a recipe",
  ingredients: [
    {
      description: "sugar",
      amount: "1 cup"
    },
    {
      description: "flour",
      amount: "2 cups"
    }
  ] 
}

If given an array such as ["sugar", "butter"], what is the best way to return all recipes that have an ingredient whose description is in the given array?

Give an example and what have you tried!

Salvador Dali
– Salvador Dali

2013-12-05 20:44:47 +00:00
Commented Dec 5, 2013 at 20:44 — Salvador Dali
– Salvador Dali, Commented Dec 5, 2013 at 20:44

4J41 · Accepted Answer · 2013-12-05 21:06:33Z

1

MongoDB unwinds the arrays while querying. So this query ought to do it.

{'ingredients.description':{$in:["sugar", "butter"]}}

answered Dec 5, 2013 at 21:06

4J41

5,1051 gold badge31 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

How can I search an array of subdocument fields that match a given array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related