How to get an object's array's specific objects with mongo query?

Question

I have tried the following queries and they all return an object that contains an array of all the objects in the array.

dbCollection.find({ user: req.user._id, "books.type": type });
dbCollection.find({ user: req.user._id, books: { $elemMatch: { type } } });
dbCollection.find({ $and: [{ user: req.user._id }, { "books.type": type }] });
dbCollection.find({ user: req.user._id, "books.type": { $in: type } });
dbCollection.find({ user: req.user._id, "books.type": { $in: [type] });

How to get only those objects of array which match the condition instead of whole array?

Shoaib Ahmed · Accepted Answer · 2021-11-23 08:29:30Z

1

This will work I think, give it a try

dbCollection.aggregate([
            { $match: { user: { $eq: req.user._id } } },
            {
                $project: {
                    user: 1,
                    books: {
                        $filter: {
                            input: "$books",
                            as: "book",
                            cond: { $eq: ["$$book.type", type] },
                        },
                    },
                },
            },
        ]);

edited Nov 23, 2021 at 8:29

answered Nov 23, 2021 at 6:52

Shoaib Ahmed

4804 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

How to get an object's array's specific objects with mongo query?

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