Query array element and then field, from MongoDB

Question

Suppose I have the following document in a collection:

{  
   "_id":ObjectId("1123562e7c594c12942f"),
   "figures":[  
      {  
         "shape":"square",
         "color":"blue"
      },
      {  
         "shape":"triangle",
         "color":"black"
      }
   ]
}

I would like to make a query which selects the field "shape" from the second element of the array "figures".

Using db.test.find({}, {"figures": {$slice: [2, 1]}}) you can access the second element of "figures", but can you also select only the field "shape" from there?

Using .find()? No. You can use the .aggregate() method. But it's better to do this client side. — Sede
– Sede, Commented Jan 6, 2016 at 0:34
the problem for me of doing it client side is that my actual array entries have fields which are huge, and that's why I don't want to query all the fields — davalo
– davalo, Commented Jan 6, 2016 at 1:01

msvairam · Accepted Answer · 2016-01-06 09:10:28Z

1

Use below query

db.test.find({}, {"figures": {$slice: [2, 1]}, "figures.shape": 1}).pretty();

edited Jan 6, 2016 at 9:10

answered Jan 6, 2016 at 8:56

msvairam

8725 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Query array element and then field, from MongoDB

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