Sorting embedded documents
In MongoDB, we can also sort embedded documents using the sort() method. In this method, we can specify the embedded document field using dot.
Syntax:
db.Collection_name.sort({“field_name.embed_field_name” : 1 or -1})
Example:
In the following example, we are working with:
Database: gfg
Collections: student
Document: Two documents contains name and a marks document, that contains the two subjects marks and the total marks of two subjects.
- Sort documents in ascending order according to the total field of the marks document:
db.student.find().pretty().sort({"marks.total":1})
- Sort documents in descending order according to the total field of the marks document:
db.student.find().pretty().sort({"marks.total":-1})
Sorting Documents in MongoDB
Sorting is the way to arrange documents in ascending or descending order. In MongoDB, we can sort documents in ascending or descending order according to field data. To sort documents in a collection we use the sort() method. This method takes a parameter that contains a field: value pair that defines the sort order of the result set, if the value of this field is 1 then this method sorts the documents in ascending order, or if the value of this field is -1 then this method sorts the documents in descending order.
Syntax:
db.Collection_name.sort({field_name : 1 or -1})
Parameter:
This method takes a document that contains a field : value pair. If the value of this field is 1 then this method sorts the documents in ascending order, or if the value of this field is -1 then this method sorts the documents in descending order.
Return:
This method return sorted documents.
Examples:
In the following examples, we are working with:
Database: gfg
Collections: student
Document: Four documents contains name and age of the students.
- Return all the documents in ascending order of the age:
db.student.find().sort({age:1})
- Return all the documents in descending order of the age:
db.student.find().sort({age:-1})