Node & MongoDB – Sorting Records


Node & MongoDB – Sorting Records



”;


To sort the selected documents of a collection, you can use collection.find().sort() methods to sort documents.


database.collection("sampleCollection").find({}).sort({First_Name: -1}).toArray(function(error, result) {
   if (error) throw error;
   console.log(result);
});

Example

Try the following example to select limited documents in a mongodb collection −

Copy and paste the following example as mongodb_example.js −


const MongoClient = require(''mongodb'').MongoClient;
// Prepare URL
const url = "mongodb://localhost:27017/";
// make a connection to the database
MongoClient.connect(url, function(error, client) {
   if (error) throw error;
   console.log("Connected!");
   // Connect to the database
   const database = client.db(''myDb'');   
   database.collection("sampleCollection").find({}).sort({First_Name: -1}).toArray(function(error, result) {
      if (error) throw error;
      console.log(result);
   });  
   // close the connection
   client.close();
});

Output

Execute the mysql_example.js script using node and verify the output.


node mongodb_example.js
Connected!
[
  {
    _id: 60c4bbb40f8c3920a0e30fdd,
    First_Name: ''Radhika'',
    Last_Name: ''Sharma'',
    Date_Of_Birth: ''1995-09-26'',
    e_mail: ''[email protected]'',
    phone: ''9000012345''
  },
  {
    _id: 60c4bbb40f8c3920a0e30fde,
    First_Name: ''Rachel'',
    Last_Name: ''Christopher'',
    Date_Of_Birth: ''1990-02-16'',
    e_mail: ''[email protected]'',
    phone: ''9000054321''
  },
  {
    _id: 60c4bbb40f8c3920a0e30fdf,
    First_Name: ''Fathima'',
    Last_Name: ''Sheik'',
    Date_Of_Birth: ''1990-02-16'',
    e_mail: ''[email protected]'',
    phone: ''9000012345''
  }
]

Advertisements

”;

Leave a Reply

Your email address will not be published. Required fields are marked *