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.
The $addToSet
operator adds elements to an array if they don't already exist, while ensuring uniqueness of elements within the set.
{
"$addToSet": { <field1>: <value1>, ... }
}
Description | |
---|---|
<field1> |
The field to which you want to add elements. |
<value1> |
The value to be added to the array. |
Consider this sample document from the stores collection in the StoreData database.
{
"_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
}
],
"fullSales": 3700
},
"promotionEvents": [
{
"eventName": "Bargain Blitz Days",
"promotionalDates": {
"startDate": {
"Year": 2024,
"Month": 3,
"Day": 11
},
"endDate": {
"Year": 2024,
"Month": 2,
"Day": 18
}
},
"discounts": [
{
"categoryName": "DJ Turntables",
"discountPercentage": 18
},
{
"categoryName": "DJ Mixers",
"discountPercentage": 15
}
]
}
],
"tag": [
"#ShopLocal",
"#SeasonalSale",
"#FreeShipping",
"#MembershipDeals"
]
}
db.stores.update(
{ "_id": "7954bd5c-9ac2-4c10-bb7a-2b79bd0963c5" },
{ "$addToSet": { "tag": "#ShopLocal" } }
)
This query would return the following document as #ShopLocal
already existed.
{
"acknowledged": true,
"insertedId": null,
"matchedCount": "1",
"modifiedCount": "0",
"upsertedCount": 0
}
Add a new promotional event to the promotionEvents
array, only if it doesn't already exist.
db.stores.update(
{ "_id": "7954bd5c-9ac2-4c10-bb7a-2b79bd0963c5" },
{ "$addToSet": { "promotionEvents": {
"eventName": "Summer Sale",
"promotionalDates": {
"startDate": { "Year": 2024, "Month": 6, "Day": 1 },
"endDate": { "Year": 2024, "Month": 6, "Day": 15 }
},
"discounts": [
{ "categoryName": "DJ Speakers", "discountPercentage": 20 }
]
}
}}
)
This query would return the following document as it was a unique entry.
{
"acknowledged": true,
"insertedId": null,
"matchedCount": "1",
"modifiedCount": "1",
"upsertedCount": 0
}
- Review options for Migrating from MongoDB to Azure Cosmos DB for MongoDB (vCore)
- Read more about Feature compatibility with MongoDB