mongodb : Query array of nested string

Question

I have a list of objects something like

[
   { item: "journal", instock: [ { warehouse: "A", qty: 5 }, { warehouse: "C", qty: 15, type : ["hello", "world", "wassup", "yo"] } ] },
   { item: "notebook", instock: [ { warehouse: "C", qty: 5 } ] },
   { item: "paper", instock: [ { warehouse: "A", qty: 60 }, { warehouse: "B", qty: 1515, type : ["hello", "wassup", "yo"] } ] },
   { item: "planner", instock: [ { warehouse: "A", qty: 40 }, { warehouse: "B", qty: 515, type : ["hello"] } ] },
   { item: "postcard", instock: [ { warehouse: "B", qty: 15 }, { warehouse: "C", qty: 3515, type : ["wassup", "yo"] } ] }
]

How can I query list of all warehouse in which "type" contains hello

db.inventory.find( { "instock": { $elemMatch: {type :["hello"]}}} , {_id:0})

returns the objects that has only hello.

mickl · Accepted Answer · 2019-02-09 09:34:41Z

2

Dot notation works in this case, try:

db.collection.find({ "instock.type": "hello"})

MongoDB playground

answered Feb 9, 2019 at 9:34

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

Collectives™ on Stack Overflow

mongodb : Query array of nested string

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