MongoDb, find specific objects, nested values matching specific value

Question

db.Rooms.find({"name" : "room3"}).pretty()
{
        "_id" : ObjectId("57f50608ace5ceb9af033528"),
        "name" : "room3",
        "userData" : {
                "user" : ObjectId("57f4d142ace5ceb9af033521"),
                "date" : "Wed Oct 05 2016 15:54:16 GMT+0200"
        },
        "active" : true,
        "users" : [
                {
                        "uid" : ObjectId("57f383a6ace5ceb9af033511")
                },
                {
                        "uid" : ObjectId("57f4d142ace5ceb9af033521")
                }
        ],
        "messages" : [
                {
                        "msg" : "first test since statement ",
                        "time" : "Wed Oct 05 2016 15:55:26 GMT+0200",
                        "user" : ObjectId("57f383a6ace5ceb9af033511")
                },
                {
                        "msg" : "second test since statement ",
                        "time" : "Wed Oct 05 2016 15:57:35 GMT+0200",
                        "user" : ObjectId("57f4d142ace5ceb9af033521")
                },
                {
                        "msg" : "third test since statement ",
                        "time" : "Wed Oct 05 2016 15:58:11 GMT+0200",
                        "user" : ObjectId("57f383a6ace5ceb9af033511")
                }
        ]
}

i am quite new to Mongo, and i am having trouble solving this. actually i have tried on my own for half a day allready :(

What i want, is to find "ONLY" the messages, that a certain user has inserted..

This is my collection.

(if it looks messy, i will link to an image instead) image as link

What i want is to show: all the "msg" from the "user" with _id : ObjectId("57f383a6ace5ceb9af033511")

i hope that someone can guide me or even tell me if this collection is bad or anything..

thx ;)

Could you share the code you tried to access the msg?

Martin Gottweis
– Martin Gottweis

2016-10-05 14:33:54 +00:00
Commented Oct 5, 2016 at 14:33 — Martin Gottweis
– Martin Gottweis, Commented Oct 5, 2016 at 14:33

Community · Accepted Answer · 2017-05-23 10:27:45Z

1

1 Comment

Terkel Jungløw Over a year ago

thank you for the answer.. it did what i wanted :) you are a time savior :P

Community · Accepted Answer · 2017-05-23 12:02:59Z

0

There is another question regarding this topic:

How to select a single field in MongoDB?

In the find method you can pass another object (except for the query) that tells what field(s) to return.

For you it would looks something like this:

db.student.find({"_id" : ObjectId("57f50608ace5ceb9af033528")}, {messages:1})

where 1 in {messages:1} = select the "messages" field.

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Oct 5, 2016 at 14:29

ToreDenStore

464 bronze badges

Collectives™ on Stack Overflow

MongoDb, find specific objects, nested values matching specific value

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related