วิธีเรียงลำดับข้อมูลใน MongoDB ด้วย sort()

การเรียงลำดับข้อมูลใน MongoDB ด้วย sort()

กรณีที่ 1: เรียงน้อยไปมาก (Ascending)

db.yourCollectionName.find().sort({yourField: 1});

กรณีที่ 2: เรียงมากไปน้อย (Descending)

db.yourCollectionName.find().sort({yourField: -1});

สร้างข้อมูลตัวอย่าง

> db.sortingDemo.insertOne({"Value":100});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8f8e2ed3c9d04998abf006") }
> db.sortingDemo.insertOne({"Value":1});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8f8e31d3c9d04998abf007") }
> db.sortingDemo.insertOne({"Value":150});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8f8e34d3c9d04998abf008") }
> db.sortingDemo.insertOne({"Value":250});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8f8e37d3c9d04998abf009") }
> db.sortingDemo.insertOne({"Value":5});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8f8e3bd3c9d04998abf00a") }
> db.sortingDemo.insertOne({"Value":199});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8f8e3ed3c9d04998abf00b") }
> db.sortingDemo.insertOne({"Value":243});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8f8e44d3c9d04998abf00c") }
> db.sortingDemo.insertOne({"Value":290});
{ "acknowledged" : true, "insertedId" : ObjectId("5c8f8e48d3c9d04998abf00d") }

เรียงน้อยไปมาก (Ascending: 1)

> db.sortingDemo.find().sort({Value:1});

{ "_id" : ObjectId("5c8f8e31d3c9d04998abf007"), "Value" : 1 }
{ "_id" : ObjectId("5c8f8e3bd3c9d04998abf00a"), "Value" : 5 }
{ "_id" : ObjectId("5c8f8e2ed3c9d04998abf006"), "Value" : 100 }
{ "_id" : ObjectId("5c8f8e34d3c9d04998abf008"), "Value" : 150 }
{ "_id" : ObjectId("5c8f8e3ed3c9d04998abf00b"), "Value" : 199 }
{ "_id" : ObjectId("5c8f8e44d3c9d04998abf00c"), "Value" : 243 }
{ "_id" : ObjectId("5c8f8e37d3c9d04998abf009"), "Value" : 250 }
{ "_id" : ObjectId("5c8f8e48d3c9d04998abf00d"), "Value" : 290 }

เรียงมากไปน้อย (Descending: -1)

> db.sortingDemo.find().sort({Value:-1});

{ "_id" : ObjectId("5c8f8e48d3c9d04998abf00d"), "Value" : 290 }
{ "_id" : ObjectId("5c8f8e37d3c9d04998abf009"), "Value" : 250 }
{ "_id" : ObjectId("5c8f8e44d3c9d04998abf00c"), "Value" : 243 }
{ "_id" : ObjectId("5c8f8e3ed3c9d04998abf00b"), "Value" : 199 }
{ "_id" : ObjectId("5c8f8e34d3c9d04998abf008"), "Value" : 150 }
{ "_id" : ObjectId("5c8f8e2ed3c9d04998abf006"), "Value" : 100 }
{ "_id" : ObjectId("5c8f8e3bd3c9d04998abf00a"), "Value" : 5 }
{ "_id" : ObjectId("5c8f8e31d3c9d04998abf007"), "Value" : 1 }

ใช้ 1 สำหรับ Ascending และ -1 สำหรับ Descending