How to sort array element in a document (mongoose)

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": "abc@gmail.com",
  "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": "abc@gmail.com",
   "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, May 17 '18 at 14:56

Ashh · Accepted Answer · 2018-10-04T11:12:10.600

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 04 '18 at 11:12

answered May 17 '18 at 18:13

Ashh

44,693
14
105
132

this works fine but what about `email` and `fullName`, how to get them in the in response. – Arpit Suthar Jul 01 '20 at 07:24
1

@ArpitSuthar https://stackoverflow.com/questions/52215916/first-in-mongodb – Ashh Jul 01 '20 at 08:56

How to sort array element in a document (mongoose)

1 Answers1