MongoDB sort()

In MongoDB, sort() method is used to sort the documents in the collection. This method accepts a document containing list of fields along with their sorting order.

The sorting order is specified as 1 or -1.

  • 1 is used for ascending order sorting.
  • -1 is used for descending order sorting.

Syntax:

snippet
db.COLLECTION_NAME.find().sort({KEY:1})

Scenario

Consider an example which has a collection name rookienerd.

This collection has following fields within it.

snippet
[
      {
        Course: "Java",
        details: { Duration: "6 months", Trainer: "Sonoo Jaiswal" },
        Batch: [ { size: "Medium", qty: 25 } ],
        category: "Programming Language"
      },
      {
        Course: ".Net",
        details: { Duration: "6 months", Trainer: "Prashant Verma" },
        Batch: [ { size: "Small", qty: 5 }, { size: "Medium", qty: 10 }, ],
        category: "Programming Language"
      },
      {
        Course: "Web Designing",
        details: { Duration: "3 months", Trainer: "Rashmi Desai" },
        Batch: [ { size: "Small", qty: 5 }, { size: "Large", qty: 10 } ],
        category: "Programming Language"
      }
    ];

Execute the following query to display the documents in descending order.

snippet
db.rookienerd.find().sort({"Course":-1})

This will show the documents in descending order.

Output
{ "_id" : ObjectId("564dbced8e2c097d15fbb603"), "Course" : "Web Designing", "det ails" : { "Duration" : "3 months", "Trainer" : "Rashmi Desai" }, "Batch" : [ { " size" : "Small", "qty" : 5 }, { "size" : "Large", "qty" : 10 } ], "category" : " Programming Language" } { "_id" : ObjectId("564dbced8e2c097d15fbb601"), "Course" : "Java", "details" : { "Duration" : "6 months", "Trainer" : "Sonoo Jaiswal" }, "Batch" : [ { "size" : "Medium", "qty" : 25 } ], "category" : "Programming Language" } { "_id" : ObjectId("564dbced8e2c097d15fbb602"), "Course" : ".Net", "details" : { "Duration" : "6 months", "Trainer" : "Prashant Verma" }, "Batch" : [ { "size" : "Small", "qty" : 5 }, { "size" : "Medium", "qty" : 10 } ], "category" : "Progra mming Language" }
Note
Note: By default sort() method displays the documents in ascending order. If you don't specify the sorting preference, it will display documents in ascending order.
Related Tutorial
Follow Us
https://www.facebook.com/Rookie-Nerd-638990322793530 https://twitter.com/RookieNerdTutor https://plus.google.com/b/117136517396468545840 #
Contents +