運算子會將 $comment 批註新增至查詢,以協助識別記錄和分析工具輸出中的批注。 這對於偵錯和監視資料庫作業特別有用。
語法
{
$comment: <string>
}
參數
| 參數 | Description |
|---|---|
string |
字串,包含要包含在查詢中的批注。 |
範例
請參考商店集合中的此範例檔。
{
"_id": "40d6f4d7-50cd-4929-9a07-0a7a133c2e74",
"name": "Proseware, Inc. | Home Entertainment Hub - East Linwoodbury",
"location": {
"lat": 70.1272,
"lon": 69.7296
},
"staff": {
"totalStaff": {
"fullTime": 19,
"partTime": 20
}
},
"sales": {
"totalSales": 151864,
"salesByCategory": [
{
"categoryName": "Sound Bars",
"totalSales": 2120
},
{
"categoryName": "Home Theater Projectors",
"totalSales": 45004
}
]
},
"promotionEvents": [
{
"eventName": "Massive Markdown Mania",
"promotionalDates": {
"startDate": {
"Year": 2023,
"Month": 6,
"Day": 29
},
"endDate": {
"Year": 2023,
"Month": 7,
"Day": 9
}
},
"discounts": [
{
"categoryName": "DVD Players",
"discountPercentage": 14
}
]
}
]
}
範例 1:尋找總銷售額超過 100,000 的商店,並新增日誌註解以供參考
此查詢會擷取總銷售額大於 100,000 的商店,並包含註解,以便在記錄中輕鬆識別。
db.stores.find(
{ "sales.totalSales": { $gt: 100000 } },
{ name: 1, "sales.totalSales": 1 }
).comment("Query to find high-performing stores")
此查詢會傳回下列結果。
[
{
"_id": "40d6f4d7-50cd-4929-9a07-0a7a133c2e74",
"name": "Proseware, Inc. | Home Entertainment Hub - East Linwoodbury",
"sales": {
"totalSales": 151864
}
}
]