Mongoose/MongoDB find Document with array of objects by multiple values

Question

I have the following document structure:

recipients: [
    {
        name: String,
        hidden: Boolean,
    },
    {
        name: String,
        hidden: Boolean,
    },
    // more ...
];

I want to query all documents for a given name and a given hidden value in the same object, meaning at the same index of the recipients array. How can I query for example "all documents for name = test and hidden = false" (where hidden is in the same object as the name)? I tried the following

const chats = await Model.find(
            {
                'recipients.name': name,
                'recipients.hidden': false,
            },

But this still returns the document because it does not seem to use those 2 conditions for the same object, but across all objects in the array.

ffritz · Accepted Answer · 2020-02-24 10:42:57Z

1

Nevermind, got it. See the MongoDB docs for $elemMatch (https://docs.mongodb.com/manual/reference/operator/query/elemMatch/#array-of-embedded-documents)

{ 
    "recipients": {
        "$elemMatch": {
            "name": name,
            "hidden": false 
        }, 
    }, 
}

answered Feb 24, 2020 at 10:42

ffritz

2,2712 gold badges33 silver badges67 bronze badges

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

Collectives™ on Stack Overflow

Mongoose/MongoDB find Document with array of objects by multiple values

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