mongoose-paginate-v2 Sort doesn't work with mongoose-paginate (but works with vanilla mongoose)

Sort doesn't work with mongoose-paginate (but works with vanilla mongoose)

Open JoshuaPerk opened this issue 3 years ago • 5 comments

I have a collection of calendar Events and in their schema is a start key which holds a proper date. If I run a vanilla mongoose query such as...

Event.find(filter).sort( { start: 1 } ).limit(250)

...as expected, I get a list of events, sorted oldest to newest.

However, when I run...

const options = {
   sort: 'start'
   // or sort: { start: 1 }
}
Event.paginate(filter, options)

...I successfully have paginated results returned; however, they're not in any specific order.

I've attempted to make start an index at both the field and schema level but to no avail. Am I missing a step or syntax?

Dec 08 '21 03:12 JoshuaPerk

I just came from mongoose-aggregate-paginate-v2 here because it seems it's bugged when it comes to sorting, and now I'm reading this. Please if someone can confirm if this is a confirmed bug?

Actually I realised I don't need aggregation in my query and this paginate-v2 would suit me really well because it has same output fields as aggregate version, so I don't have to change my frontend. But I do need sorting of paginated results pretty badly...