Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
APPLIES TO:
MongoDB vCore
The $sort
operator is used to sort an array in ascending or descending order within a document during an update operation. This operator is useful for maintaining ordered arrays based on specific fields.
{
"$sort": {
"<field1>": <sortOrder>,
"<field2>": <sortOrder>
}
}
Description | |
---|---|
field |
The field in the array to sort by. |
sortOrder |
The sort order (1 for ascending, -1 for descending). |
Let's review the usage with a sample json document from stores
collection.
{
"_id": "7954bd5c-9ac2-4c10-bb7a-2b79bd0963c5",
"name": "Lakeshore Retail | DJ Equipment Stop - Port Cecile",
"location": { "lat": 60.1441, "lon": -141.5012 },
"staff": { "totalStaff": { "fullTime": 2, "partTime": 0 } },
"sales": {
"salesByCategory": [
{ "categoryName": "DJ Headphones", "totalSales": 35921 },
{ "categoryName": "DJ Cables", "totalSales": 1000 }
],
"fullSales": 3700
},
"promotionEvents": [
{
"eventName": "Cyber Monday Event",
"promotionalDates": {
"startDate": { "Year": 2024, "Month": 8, "Day": 1 },
"endDate": { "Year": 2024, "Month": 8, "Day": 7 }
},
"discounts": [ { "categoryName": "DJ Speakers", "discountPercentage": 25 } ]
},
{
"eventName": "Black friday Event",
"promotionalDates": {
"startDate": { "Year": 2024, "Month": 8, "Day": 1 },
"endDate": { "Year": 2024, "Month": 8, "Day": 7 }
},
"discounts": [ { "categoryName": "DJ Speakers", "discountPercentage": 25 } ]
},
{
"eventName": "Mega Discount Days",
"promotionalDates": {
"startDate": { "Year": 2024, "Month": 5, "Day": 11 },
"endDate": { "Year": 2024, "Month": 5, "Day": 18 }
},
"discounts": [ { "categoryName": "DJ Lights", "discountPercentage": 20 } ]
}
],
"tag": [
"#ShopLocal",
"#NewArrival",
"#FashionStore",
"#SeasonalSale",
"#FreeShipping",
"#MembershipDeals"
]
}
The example sorts the salesByCategory
array in place based on the totalSales
field in ascending order.
db.stores.update( { "_id": "7954bd5c-9ac2-4c10-bb7a-2b79bd0963c5" }
, { $push: { "sales.salesByCategory": { $each: [], $sort: { "totalSales": 1 } } } }
)
- Review options for Migrating from MongoDB to Azure Cosmos DB for MongoDB (vCore)
- Read more about Feature compatibility with MongoDB