How to sort a collection by date in MongoDB

Question

I am using MongoDB with Node JS  I have a collection which contains a date and other rows  The date is a JavaScript Date object   How can I sort this collection by date

User · Answer

Sorting by date doesn t require anything special  Just sort by the desired date field of the collection   Updated for the 1 4 28 node js native driver  you can sort ascending on datefield using any of the following ways   collection find   sort  datefield  1   toArray function err  docs          collection find   sort  datefield   1  toArray function err  docs          collection find   sort    datefield   1    toArray function err  docs          collection find      sort   datefield  1    toArray function err  docs          collection find      sort     datefield   1     toArray function err  docs             asc  or  ascending  can also be used in place of the 1   To sort descending  use  desc    descending   or -1 in place of the 1

User · Answer

Just a slight modification to  JohnnyHK answer  collection find   sort  datefield  -1   function err  cursor           In many use cases we wish to have latest records to be returned  like for latest updates   inserts

User · Answer

This worked for me   collection find       sort       datefield    asc      function  err  docs              Using Node js  Express js  and Monk

User · Answer

db getCollection     find     sort   id -1      This will sort your collection in descending order based on the date of insertion

User · Answer

collection find   sort  date  1  exec function err  doc         this worked for me  referred https   docs mongodb org getting-started node query

User · Answer

if your date format is like this   14 02 1989 ----  you may find some problems    you need to use ISOdate  like this    var start date   new Date 2012  07  x  x  x      -----  the result ------ ISODate  2012-07-14T08 14 00 201Z    now just use the query like this     collection find    query   query   orderby   start date   -1    function  err  cursor          that s it

User · Answer

With mongoose I was not able to use  toArray   and was getting the error  TypeError  Collection find      sort      toArray is not a function  The toArray function exists on the Cursor class from the Native MongoDB NodeJS driver  reference    Also sort accepts only one parameter  so you can t pass your function inside it   This worked for me  as answered by Emil    collection find   sort  -date   exec function error  result         Your code

User · Answer

Sushant Gupta s answers are a tad bit outdated and don t work anymore   The following snippet should be like this now    collection find       sort      datefield    asc      toArray function err docs

User · Answer

Additional Square     Bracket is required for sorting parameter to work    collection find       sort       datefield    asc       toArray function err docs

User · Answer

With mongoose it s as simple as   collection find   sort  -date   exec function err  collectionItems         here s your code

[node.js] How to sort a collection by date in MongoDB?

Examples related to node.js

Examples related to mongodb