Query Object list

Jithin shared this question ago

Answered

I have a collection named 'vendors' and there is a field called 'products' in that collection.The products field is a collection of object.Each object contains a 'productno' and 'productname' field. How can I get a products with a specific 'productno'?

The same question

Replies (1)

qinghai (support@nosqlbooster.com) ●

I seems that you need $elemMatch.

db.vendors.find({
   products: { $elemMatch: { productno: 123, productname: "abc" }} 

})

or user our fluid query:

db.vendors.where("products").elemMatch({productno:123, productname:"abc"})

I seems that you need $elemMatch.

db.vendors.find({
   products: { $elemMatch: { productno: 123, productname: "abc" }} 

})

or user our fluid query:

db.vendors.where("products").elemMatch({productno:123, productname:"abc"})

Reply URL