How to sort sub-document array in mongoose/mongodb?

Question

user (mongodb document)

{
  "_id": "5bccfb7515bc6d0c6872ed91",
  "notification": {
    "notidata": [
      {
        "data": {
          "para": "Your Ad '1' has been successfully submitted."
        },
        "notistatus": false,
        "_id": "5be35d89113aec40c4ca7517",
        "notidate": "2018-11-07T21:47:53.803Z"
      },
      {
        "data": {
          "para": "Your Ad '2' has been successfully submitted."
        },
        "notistatus": false,
        "_id": "5be35d92113aec40c4ca7519",
        "notidate": "2018-11-07T21:48:02.729Z"
      }
    ],
    "counter": 4
  },
  "ads": [],
  "username": "mesam",
  "email": "[email protected]",
  "password": "0",
  "country": "AZE",
  "createdOn": "2018-10-21T22:19:33.377Z",
  "__v": 0
}

route.js

User.findOneAndUpdate({ _id: user._id }, { $push: { "notification.notidata": { "data.para": "Your Ad " + "'" + thisad.heading + "'" + " has been successfully submitted."} } }, { new: true }, function (err, df) { ....

I want notidata to be sorted by notidate. Using $postion: 0 did not work. Nor did $sort: notidate: -1

* failed $position attempt*

User.findOneAndUpdate({ _id: user._id }, { $push: { "notification.notidata": { "data.para": "Your Ad " + "'" + thisad.heading + "'" + " has been successfully submitted.", "$position": 0} } }, { new: true }, function (err, df) {....

failed $sort attempt

User.findOneAndUpdate({ _id: user._id }, { $push: { "notification.notidata": { "data.para": "Your Ad " + "'" + thisad.heading + "'" + " has been successfully submitted.", "$sort": {"notification.notidata.notidate": -1}} } }, { new: true }, function (err, df) {....

mickl · Accepted Answer · 2018-11-07 22:39:56Z

1

You have to use $sort with $each operator and then you just specify the name of nested field (not entire path like in your example), try:

User.findOneAndUpdate({ _id: user._id }, { 
    $push: {
        "notification.notidata": {
            "$each": [ { data: { para: "Your Ad " + "'" + thisad.heading + "'" + " has been successfully submitted." } } ],
            "$sort": {"notidate": -1}
        }
    }
}, {new: true})

answered Nov 7, 2018 at 22:39

mickl

50.1k9 gold badges71 silver badges99 bronze badges

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

3 Comments

mysamza Over a year ago

Thanks a lot! It worked. However, I wish to understand since every time this User.findOneAndUpdate will get executed in my app, it will have 1 entry of notidata.para to insert. Then why something like $eachneeds to be put in $push? Isn't $each for inserting more than one data (like an array of data)?

mickl Over a year ago

I know it might be confusing, it's even mentioned in the documentation that you should pass empty array if you only want to sort elements. That's by design

mysamza Over a year ago

Thanks a lot!

Collectives™ on Stack Overflow

How to sort sub-document array in mongoose/mongodb?

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related