Mongoose sort nested array of object not working

Question

I'm new with NodeJS and MongoDB and I encounter an issue when I want to execute a Find() query with a Sort() using Mongoose.

I would like to sort my results by notifications date and it doesn't work

Here's my Query:

UsersNotifications
            .find({user_id: new ObjectId(req.user._id)})
            .sort({'notifications.date': -1})
            .select('notifications').exec().then(usersNotifications => {
                res.locals.usersNotifications = usersNotifications;
            });

Here's my models:

Thank you for your help !

eol · Accepted Answer · 2020-06-12 14:04:29Z

6

Afaik you cannot sort by nested objects, but you could unwind the notifications array, apply your descending sort and regroup the result. Something like:

.aggregate([
    { $match: { _id: new ObjectId(req.user._id) }},
    { $unwind: '$notifications' },
    { $sort: { 'notifications.date': -1 }},
    { $group: { _id: '$_id', notifications: { $push: '$notifications'}}}])

answered Jun 12, 2020 at 14:04

eol

24.7k6 gold badges53 silver badges72 bronze badges

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

2 Comments

Stefano Martines Over a year ago

Perfect! It work as expected :) Thank you very much

eol Over a year ago

Great, happy to help! :)

Collectives™ on Stack Overflow

Mongoose sort nested array of object not working

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related