Sort Records in MongoDB

The sort() Method

We need to use sort() method to sort documents in MongoDB, it accepts a document field along with their sorting order. To specify sorting order 1 and -1 are used. 1 is used for ascending order while -1 is used for descending order.


Basic syntax of the sort() method is given below


Example: Point out the collection testCol has the following data

{ "_id" : ObjectId(5983548781331adf45ec5), "title":"MongoDB Overview", "by":""}
{ "_id" : ObjectId(5983548781331adf45ec6), "title":" ASP.Net Over view ", "by":""}
{ "_id" : ObjectId(5983548781331adf45ec7), "title":" SQL Server 2014", "by":""}

The following example will display the documents sorted by title in descending order.

{"title":" SQL Server 2014"}
{"title":" MongoDB Overview "}
{"title":" SQL Server 2014"}

Please note if you don't specify the sorting preference, then sort() method will display documents in ascending order.

No comments:

Post a Comment

Please do not enter any spam link in the comment box.

Related Posts

Fatal Error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails.

Problem: Sometimes, we get the following error when trying to make a connection in Rails.  FATAL ERROR: Peer authentication failed for us...