如何使用 MongoDB 查詢指定日期范圍內(nèi) meta.timestampOccur 字段的記錄？

{   ...   "meta": {     "aaa": { // 注意，這里的aaa，每條數(shù)據(jù)都不一樣，隨機(jī)的名稱       "timestampoccur": [         {           "$date": "2023-06-19t10:18:02.000z"  // 這個(gè)是 date 類型         }       ]     },     "bbb": {       "timestampoccur": [         {           "$date": "2023-06-19t02:59:05.000z"         }       ]     }   } }

db.collection.aggregate([   // 匹配符合條件的記錄   {     $match: {       "meta.timestampOccur": {         $elemMatch: {           $gte: ISODate("2023-06-18T00:00:00.000Z"),           $lt: ISODate("2023-06-20T00:00:00.000Z")         }       }     }   },   // 展開(kāi) meta 對(duì)象，方便后續(xù)操作   {     $project: {       _id: 1,       campaign: 1,       status: 1,       workflow: 1,       user: 1,       basic: 1,       type: 1,       createdAt: 1,       updatedAt: 1,       tag: 1,       code: 1,       meta: {         $objectToArray: "$meta"       }     }   },   // 將 meta 對(duì)象轉(zhuǎn)換為數(shù)組，方便后續(xù)操作   {     $unwind: {       path: "$meta",       includeArrayIndex: "metaIndex"     }   },   // 如果 meta.timestampOccur 符合日期范圍，則輸出記錄   {     $match: {       "meta.v.timestampOccur": {         $elemMatch: {           $gte: ISODate("2023-06-18T00:00:00.000Z"),           $lt: ISODate("2023-06-20T00:00:00.000Z")         }       }     }   },   // 重新構(gòu)建 meta 對(duì)象   {     $group: {       _id: "$_id",       campaign: { $first: "$campaign" },       status: { $first: "$status" },       workflow: { $first: "$workflow" },       user: { $first: "$user" },       basic: { $first: "$basic" },       type: { $first: "$type" },       createdAt: { $first: "$createdAt" },       updatedAt: { $first: "$updatedAt" },       tag: { $first: "$tag" },       code: { $first: "$code" },       meta: {         $push: {           k: "$meta.k",           v: "$meta.v"         }       }     }   },   // 將 meta 對(duì)象轉(zhuǎn)換回原始格式   {     $project: {       _id: 1,       campaign: 1,       status: 1,       workflow: 1,       user: 1,       basic: 1,       type: 1,       createdAt: 1,       updatedAt: 1,       tag: 1,       code: 1,       meta: {         $arrayToObject: "$meta"       }     }   } ]);