sort in mongoose aggregate lookup

Impossible Ibis answered on January 25, 2022 Popularity 5/10 Helpfulness 4/10

answer sort in mongoose aggregate lookup

sort in mongoose aggregate lookup

Comment

db.getCollection('user').aggregate([
    {$lookup: {from: "post", localField: "_id", foreignField: "userId", as: "post"}},
    {$unwind: { path: "$post", preserveNullAndEmptyArrays: true }},
    {$sort: {"post.createdAt": -1}},
    {$group: {"_id": "$_id", "name": {$first: "$name"}, "post": {$first: "$post"}},
    {$project: {"_id": 1, "name": 1, "post": 1}}
])

Popularity 5/10 Helpfulness 4/10 Language javascript

Source: stackoverflow.com

Tags: aggregate javascript lookup mongoose

Link to this answer
Share Copy Link

Contributed on Jan 25 2022

Impossible Ibis

0 Answers Avg Quality 2/10

sort in mongoose aggregate lookup

Contents

More Related Answers

sort in mongoose aggregate lookup

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.