Query MongoDb collection regarding an array of objects in a Go project

Question

In a Go project I stored some data like this in a MongoDb Collection:

{
    _id:ObjectId("631f0752da589137a71687f6"),
    target: { roomId: '11' }
}

{
    _id:ObjectId("43150752da589137a71687f6"),
    target: { roomId: '12' }
}
.
.
.

I have a target array of objects and I want to check the database that if a roomId in database is equal to one of my array of objects values or not.

My target array of objects:

 userRooms:[{"roomId":"12"}, {"roomId":"13"}, {"roomId":"14"}]

I create a new array containing just room Id's like this:

var roomIds []string
for _, v := range RESPONSE.USERROOMS {
    roomIds = append(roomIds, v.ROOMID)
}

I do it like this:

bson.M{ "target": bson.M{"roomId":bson.M{"$in": roomIds }}}}}})

It doesn't work. it returns zero results.

I create an array like you said. but still I get zero results. Its possible you to give me the correct query? — Fcoder
– Fcoder, Commented Sep 14, 2022 at 17:27

icza · Accepted Answer · 2022-09-14 17:42:46Z

2

To construct a filter for a nested field, use the dot . to designate the field with its full "path":

bson.M{"target.roomId": bson.M{"$in": roomIds}}

Where roomIds should be the slice of IDs, e.g. of type []string or []any, but it should contain the room IDs as strings.

answered Sep 14, 2022 at 17:42

icza

423k78 gold badges1k silver badges905 bronze badges

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

Collectives™ on Stack Overflow

Query MongoDb collection regarding an array of objects in a Go project

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