Sort an nested array in mongoose

Question

i have a PlaylistShema with an array or musics. In this array of musics I have an ObjectId (who ref to a Music collection), an addedAt and a title.

PlaylistShema

var PlaylistSchema = new Schema({
  title: {type : String, default : '', trim : true},
  user: {type : Schema.ObjectId, ref : 'User'},

  musics : [{ 
    musicId : {type : Schema.ObjectId , ref : 'Music'},
    title : {type : String},
    addedAt : {type : Date, default : Date.now}
  }],

  tags : { type : [], get : getTags, set : setTags},
  createdAt  : {type : Date, default : Date.now}
})

i have a statics to load a playlist :

Load function

  load: function (id, cb) {
    this.findOne({ _id : id })
      .populate('user', 'name email username')
      .populate('musics.musicId')
      .exec(cb)
  }

i want to sort my musics by addedAt... but i can't do .populate('musics.musicId', { sort: { 'addedAt': 'desc' } }) because this is not where addedAt is...

i'm very confused with populate when it comes to nested array...

thanks !

MusicShema

var MusicSchema = new Schema({
  title: {type : String, default : '', trim : true}
})

WiredPrairie · Accepted Answer · 2014-02-12 01:29:33Z

6

You can't sort an array directly in Mongoose. You can clone the data and sort it as a JavaScript object by using toObject (documentation) and the Array sort method:

Playlist.load(function(err, playList) {
    var pl = playList.toObject();
    pl.musics.sort(function(m1, m2) { return m1.addedAt - m2.addedAt; });
    // pl contains the playlist now 
});

answered Feb 12, 2014 at 1:29

WiredPrairie

59.9k18 gold badges120 silver badges149 bronze badges

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

4 Comments

Gautier Over a year ago

hum okay ! that's why ! Thanks

kobayashi Over a year ago

hi, I have a similar model. When I populate my "musics" field I don't be able to get the "name" or "description" of the ref record. How can I do that?

WiredPrairie Over a year ago

You should probably ask a new question.

dmr07 Over a year ago

@WiredPrairie, about "can't sort arrays", is that the reason why this is not working? stackoverflow.com/questions/32191086/…

Collectives™ on Stack Overflow

Sort an nested array in mongoose

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related