Querying for multiple valules in array

Question

I have an Order record that looks like:

{   cust_id : 5     , ordered_pdts : [ 1,2,3 ] }

I have Vendors collection. Each vendor record has a list of products the vendor maintains:

{   vendor_id : 342     , pdts : [ 4, 5, 6, 1, 2, 7, 3 ] }

When an order is placed, I need to find the vendors who have ALL the products listed in the Order.

Can this be done with a query operation or Aggregation Framework?

Md Nazmul Hossain · Accepted Answer · 2016-01-17 05:29:31Z

3

You can try with this query :

db.Vendor.find({'pdts' : {$all : [1,2,3]}})

answered Jan 17, 2016 at 5:29

Md Nazmul Hossain

2,9635 gold badges30 silver badges51 bronze badges

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

1 Answer 1