How to query nested object in mongodb

Question

I'm new to mongodb and I've been trying to query this doc for awhile now.

Im trying to query all the rooms that have a room name of 100.

json

{
"count": 3,
"reviews": [
    {
        "_id": "5f9d42a0a8e71e004643f584",
        "user": {
            "_id": "5f7308cde0a4a7a66bc3d184",
            "name": "Guest"
        },
        "room": {
            "_id": "5f98f9321fd5bb0045b3d886",
            "name": "100",
        },
        "rating": 4,
    },
    {
        "_id": "5f9d431ea8e71e004643f585",
        "user": {
            "_id": "5f7308cde0a4a7a66bc3d184",
            "name": "Guest",
        },
        "room": {
            "_id": "5f98f9321fd5bb0045b3d886",
            "name": "100",
        },
        "rating": 5,
    },
    {
        "_id": "5f9e74fea6c06a0046d3cae2",
        "user": {
            "_id": "5f7308cde0a4a7a66bc3d184",
            "name": "Guest",
        },
        "room": {
            "_id": "5f98fa8b1fd5bb0045b3d88a",
            "name": "300",
        },
        "rating": 5,   
    }
]}

what I've tried

1. find({},{"reviews.room.name": {$eq: "100"}}) // getting a projection error
2. find({"reviews.room.name": "100"}) // getting null

Any help to the right direction would be greatly appreciated.

Try find({"reviews": { $elemMatch:{"room.name": "100"} } }) — Wernfried Domscheit
– Wernfried Domscheit, Commented Nov 1, 2020 at 10:53
Are you sure? It works as it should: mongoplayground.net/p/iiBj8hITbPB — Wernfried Domscheit
– Wernfried Domscheit, Commented Nov 1, 2020 at 16:24
Thanks for your effort.But I've already found a solution.I think my problem was confusing the mongo-db structure. The reviews was my own created object my bad. — Steven Selolo
– Steven Selolo, Commented Nov 1, 2020 at 22:07

Artem Fedotov · Accepted Answer · 2020-11-01 10:57:52Z

1

Check out the docs about how to use find: https://docs.mongodb.com/manual/reference/method/db.collection.find/

and try this

db.reviews.find({
  "room.name": "100"
})

Here is the playground with your example: https://mongoplayground.net/p/dPfH5fSOePq

edited Nov 1, 2020 at 10:57

answered Nov 1, 2020 at 10:13

Artem Fedotov

4621 gold badge6 silver badges21 bronze badges

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

2 Comments

Steven Selolo Over a year ago

Thanks this works. I think I was confusing the mongo-db structure.

Artem Fedotov Over a year ago

I'm glad if it helped :)

mouheb · Accepted Answer · 2020-11-01 10:52:25Z

0

did u try this ? const response = await Room.find({name: "100"})

answered Nov 1, 2020 at 10:52

mouheb

993 bronze badges

Collectives™ on Stack Overflow

How to query nested object in mongodb

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related