在mongodb中按年和月获取所有文档

{
  $project: {
    year: { $year: "$date" },
    month: { $month: "$date" }
  }
}

{
  $group: {
    _id: {
      year: "$year",
      month: "$month"
    },
    documents: { $push: "$$ROOT" }
  }
}

{
  $sort: {
    "_id.year": 1,
    "_id.month": 1
  }
}

db.collection.aggregate([
  {
    $project: {
      year: { $year: "$date" },
      month: { $month: "$date" }
    }
  },
  {
    $group: {
      _id: {
        year: "$year",
        month: "$month"
      },
      documents: { $push: "$$ROOT" }
    }
  },
  {
    $sort: {
      "_id.year": 1,
      "_id.month": 1
    }
  }
])