Data from populate not sorting about mongoose-datatable HOT 3 CLOSED

Hello,

Thanks for using the module.
Can you give me the models for me to test ?

Regards,

from mongoose-datatable.

Hey,

I just changed a bit your demo project, I added a second model, looks like this:

// user model
usersSchema = new Schema(
{
  name : String
});
mongoose.model('User', usersSchema);
UModel = require('mongoose').model('User');

// reservation model
reservationsSchema = new Schema(
{
  name : String,
  startDate : String,
  endDate : {type: Schema.Types.ObjectId, ref: 'User'},
  confirmationCode : String
});
mongoose.model('reservations', reservationsSchema);
MyModel = require('mongoose').model('reservations');

And on the frontened I've changed the columns in the table like this:

"aoColumns" : [
    { "mData" : "name" },
    { "mData" : "startDate" },
    { "mData" : "endDate.name" },
    { "mData" : "confirmationCode" }
  ]

Whenever I try to sort by the endDate column is not working, although the query in populate says that is sorted by the name column in User model:

populate:
   [ { path: 'username',
       sort: { name: 'asc' },
       select: 'name' } ] }

Am I doing something wrong?

from mongoose-datatable.

Hi,

Sorry for the late reply !
The population in mongodb is done after the fetch of the root document. So it is not possible to sort by populated data.
The sort in populate just sort the array of populated elements.

Regards

from mongoose-datatable.