Error fetching queries in mongo db

Question

I have a collection in mongo db which looks like this:

"notifications" : [
    {
        "type" : "Shout",
        "created" : ISODate("2014-04-24T13:37:02.678Z")
    },
    {
        "type" : "Shout",
        "created" : ISODate("2014-04-25T17:34:15.388Z")
    }
          ];

I just want to sort these notifications by created date and fetch them using mongo query but not able to do it. Can anybody help me.. Thanks..

db.shouts.find({},{notifications:1}).sort({created: -1}).pretty() — Dheeraj
– Dheeraj, Commented May 1, 2014 at 5:56

Neil Lunn · Accepted Answer · 2014-05-01 09:47:01Z

2

You can probably use aggregation framework to sort your data based on date. Here is what I tried and its working fine.

db.shouts.aggregate([
  { "$unwind": "$notifications"}, 
  { "$sort": { "notifications.created": -1 }}, 
  { "$group": { "_id": "$_id", "notifications": { "$push": "$notifications" }}}
]);

and the result is:

 {
     "_id" : ObjectId("5361e2cfbf5e5bf862400210"),
     "notifications" : [
         {
             "type" : "Shout",
             "created" : ISODate("2014-04-25T17:34:15.388Z")
         },
         {
             "type" : "Shout",
             "created" : ISODate("2014-04-24T13:37:02.678Z")
         }
     ]
 }

hope it helps

edited May 1, 2014 at 9:47

Neil Lunn

151k36 gold badges356 silver badges327 bronze badges

answered May 1, 2014 at 6:09

AppleBud

1,5418 gold badges31 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

Error fetching queries in mongo db

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