Finding a specific value in a specific position of an array with MongoDB

Question

I am fairly new to MongoDB and I am trying to figure out how I can query a collection for a document that contains a specific value in a specific array position. I have a general idea but I am getting syntax errors when I try to use $position so I know I'm off track here despite my best effort with the mongo docs.

As an example document for what I am trying to do, I'll use a recipes database collection:

{
  "_id": ObjectId("1234"),
  "recipeName": "Super tasty cilantro lime chicken",
  "ingredients": ["chicken breast", "cilantro", "lime"]
},
{
  "_id": ObjectId("4321"),
  "recipeName": "Radical Cilantro Dip",
  "ingredients": ["cilantro", "lime", "sour cream"]
}

What is the best method for finding only the document(s) that contains cilantro in the 2nd position of the ingredients array instead of all documents containing cilantro in any position?

Try this `db.collectionName.find({"ingredients.1": "cilantro"})` — Ali Dehghani, Jun 06 '16 at 20:48
@RobertMoskal thank you. I can usually find my answer here without posting but I couldn't think of how to word the search properly to get good results. — HellaDev, Jun 06 '16 at 21:38
@AliDehghani That was so simple THANK YOU. (I was doing it in reverse) — HellaDev, Jun 06 '16 at 21:39

score 0 · Accepted Answer · answered Jun 06 '16 at 22:34

0

Credit to @Ali Dehghani for the answer!

Try this db.collectionName.find({"ingredients.1": "cilantro"}) – Ali Dehghani

answered Jun 06 '16 at 22:34

HellaDev

408
2
8
24

Finding a specific value in a specific position of an array with MongoDB

1 Answers1