How would I execute this query in MongoDB?

Question

Let's say I have a collection of "rooms". Each room is a document that looks like this:

room = {
        perms: [ { user:"matt", visible: 1 },
                 { user:"alex", visible: 0 },
                 { user:"jennifer", visible: 1 },
};

In MongoDB, how would I find rooms that have a permission of user=alex and visible=0 ?

Sarah Roberts · Accepted Answer · 2011-05-01 00:15:54Z

1

If I understand your question correctly, the $elemMatch operator should do what you want:

{ "perms": { "$elemMatch": { "user": "alex", "visible": 0 } } }

answered May 1, 2011 at 0:15

Sarah Roberts

8608 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

How would I execute this query in MongoDB?

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