MongoDB: How to fetch value for particular sub-field and its subsequent field in the array?

Question

I am new to MongoDB. I am trying to get field values for a particular sku from the array in the document. I tried query ({"items.sku":"abc"},{"items.price":1}) but it is giving prices for both skus. I would appreciate if anybody can tell me how I can get price for only sku:"abc" i.e 3.5?

{  "_id": 123,
     "store": "store1",
     "items": [ { sku: "abc", qty: 4, price: 3.5 },
              { sku: "def", qty: 3, price: 2.5 } ]
}

score 9 · Accepted Answer · answered Aug 08 '15 at 06:58

9

Please try:

db.getCollection('abhey').find({"items.sku":"abc"},{_id: 0, 'items.price.$': 1})

In case you need more help, please feel free to write.

answered Aug 08 '15 at 06:58

Abie

624
5
12

Thanks Abie . I tried your answer and it is working. – Divya Aug 08 '15 at 14:11
Nice! Can u please vote for my answer? – Abie Aug 08 '15 at 14:40
I need some more points (since am a new member) to vote. Appreciate your help, and will vote for sure next time. – Divya Aug 09 '15 at 17:16

MongoDB: How to fetch value for particular sub-field and its subsequent field in the array?

1 Answers1