How to sort array element in a document (mongoose) [duplicate]

Question

how can I sort addressBook.default in descending order when I want to select document with id.My sample structure (based on my model) below:

{  
  "_id" : ObjectId("9afd8416e7913223b09a89333"),
  "email": "[email protected]",
  "fullName": "william",
  "addressBook": [
     {
       "_id": ObjectId("5afd8416e7913223b09a89333"),
       "default ": 1,
       "country": "hong kong"
     },
     {
       "_id": ObjectId("6afd8416e7913223b09a89333"),
       "default ": 0,
       "country": "india"
     },
     {
       "_id": ObjectId("7afd8416e7913223b09a89333"),
       "default ": 1,
       "country": "thailand"
     },
  ]
}

I tried something like this with findByID() and sort() function but I can get my desire result.

WebsiteUser.findById(req.user.id).sort('-addressBook.default').exec(function(err,result){
});

My desire result that I want when I select a document with document id:

 {  
   "_id" : ObjectId("9afd8416e7913223b09a89333"),
   "email": "[email protected]",
   "fullName": "william",
   "addressBook": [
      {
        "_id": ObjectId("5afd8416e7913223b09a89333"),
        "default ": 1,
         "country": "hong kong"
      },
      {
        "_id": ObjectId("7afd8416e7913223b09a89333"),
        "default ": 1,
        "country": "thailand"
      },
      {
        "_id": ObjectId("6afd8416e7913223b09a89333"),
        "default ": 0,
        "country": "india"
      }
    ]
 }

to achieve your desire result, I think you should use the aggregation framework — Kxng Kombian
– Kxng Kombian, Commented May 17, 2018 at 14:56

Ashh · Accepted Answer · 2018-10-04 11:12:10Z

1

You need to first $unwind the addressBook and then apply sort on default

db.collection.aggregate([
  {
    "$unwind": "$addressBook"
  },
  {
    "$sort": {
      "addressBook.default": 1
    }
  },
  {
    "$group": {
      "_id": "$_id",
      "addressBook": {
        "$push": "$addressBook"
      }
    }
  }
])

edited Oct 4, 2018 at 11:12

answered May 17, 2018 at 18:13

Ashh

46.6k16 gold badges111 silver badges137 bronze badges

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

2 Comments

Arpit Suthar Over a year ago

this works fine but what about email and fullName, how to get them in the in response.

Ashh Over a year ago

@ArpitSuthar stackoverflow.com/questions/52215916/first-in-mongodb

Collectives™ on Stack Overflow

How to sort array element in a document (mongoose) [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related