In Mongoose how do I sort by date node js

Question

let s say I run this query in Mongoose      Room find      err docs    gt                sort  date -1      This doesn t work

User · Answer

Short solution   const query      const projection      const options     sort    id  1    limit  2  skip  10    Room find query  projection  options  exec function err  docs

User · Answer

Sorting in Mongoose has evolved over the releases such that some of these answers are no longer valid  As of the 4 1 x release of Mongoose  a descending sort on the date field can be done in any of the following ways      Room find     sort  -date   exec  err  docs    gt                Room find     sort  date  -1   exec  err  docs    gt                Room find     sort  date   desc    exec  err  docs    gt                Room find     sort  date   descending    exec  err  docs    gt                Room find     sort    date   -1    exec  err  docs    gt                Room find     null   sort   -date     err  docs    gt                Room find     null   sort   date  -1     err  docs    gt             For an ascending sort  omit the - prefix on the string version or use values of 1  asc  or ascending

User · Answer

Post find   sort  date -1   function err  posts         Should work as well  EDIT   You can also try using this if you get the error sort   only takes 1 Argument    Post find             id   0        select keys to return here     sort   -date    function err  posts           use it here

User · Answer

ES6 solution with Koa    async recent         data   await ReadSchema find       sort   created at          ctx body   data

User · Answer

This one works for me   Post find   sort  postedon  -1   find function  err  sortedposts       if  err           return res status 500  send   message   quot No Posts  quot          res status 200  send  sortedposts   sortedposts

User · Answer

The correct answer is   Blah find     sort  date  -1   execFind function err docs

User · Answer

I do this   Data find     query    user  req user     orderby    dateAdded  -1     function   results                  This will show the most recent things first

User · Answer

Been dealing with this issue today using Mongoose 3 5  2  and none of the answers quite helped me solve this issue  The following code snippet does the trick  Post find   sort  -posted   find function  err  posts           user posts array       You can send any standard parameters you need to find    e g  where clauses and return fields  but no callback  Without a callback it returns a Query object which you chain sort   on  You need to call find   again  with or without more parameters -- shouldn t need any for efficiency reasons  which will allow you to get the result set in your callback

User · Answer

See if this helps   How to sort in mongoose   Also read this   http   www mongodb org display DOCS Sorting and Natural Order

User · Answer

You can also sort by the  id field  For example  to get the most recent record  you can do   const mostRecentRecord   await db collection findOne   sort    id  -1       It s much quicker too  because I m more than willing to bet that your date field is not indexed

[node.js] In Mongoose, how do I sort by date? (node.js)

Examples related to node.js

Examples related to mongodb

Examples related to mongoose