Mongodb query nested array documents where property not null

Question

I am trying to get all the documents where at least one element of the instock collection has the warehouse field not null. Expected result: discard only the last documents.

db.inventory.insertMany( [
   { item: "journal", instock: [ { warehouse: "A", qty: 5 }, { warehouse: "C", qty: 15 } ] },
   { item: "notebook", instock: [ { warehouse: "C", qty: 5 } ] },
   { item: "planner", instock: [ { warehouse: null, qty: 40 }, { warehouse: "B", qty: 5 } ] },
   { item: "postcard", instock: [ { warehouse: null, qty: 15 }, { warehouse: null, qty: 35 } ] }
]);

This query discards the 3 and 4.

db.getCollection('inventory').find({
    $and: [{"instock.warehouse": {$ne: null}}, {"instock.warehouse": {$exists: true}}]
})

This one returns all the elements

db.getCollection('inventory').find({
    "instock": {$elemMatch: {"warehouse": {$ne: null}, "warehouse": {$exists: true}}}
})

s7vr · Accepted Answer · 2018-03-21 21:08:51Z

5

Use below find query.

Note the use of $elemMatch & $ne which compares all the elements of array i.e. includes all the documents where instock array don't have at least one null value in warehouse field.

db.inventory.find({"instock":{"$elemMatch":{"warehouse":{"$ne":null}}}})

answered Mar 21, 2018 at 21:08

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

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

Collectives™ on Stack Overflow

Mongodb query nested array documents where property not null

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