Queryin nested collections in mongodb using Spring MongoRepository

Question

I have my mongo data as follows: group:{"name":group1, members: [{"id":1,"name": "member1"},{"id":2,"name": "member2"}]}

I would like to this collection 'group' to fetch all the groups where a person with 'id=1' is part of. The complication is that 'members' is a collection.

Volodymyr Synytskyi · Accepted Answer · 2015-12-22 21:46:49Z

2

You can do it with simple find:

db.groups.find({'members.id':personId})

From documentation: If the array holds embedded documents, you can query for specific fields in the embedded documents using dot notation.

The query will check each element in the array for matching specific field and if there is any match the whole document will be returned.

edited Dec 22, 2015 at 21:46

answered Dec 22, 2015 at 21:15

Volodymyr Synytskyi

4,0751 gold badge18 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Queryin nested collections in mongodb using Spring MongoRepository

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