如何在$ Mongoose中$查找后过滤对象字段上的查询基础

Question

我想获得一个以顶级（速率）排序的博客的评论 评论模型：

const CommentSchema = new Schema({
    content: {type: String, maxLength: 100, required: true},
    user: {type: Schema.Types.ObjectId, ref: 'User', required: true },
    blog: {type: Schema.Types.ObjectId, ref: 'Blog', required: true},
    reactions: [{type: Schema.Types.ObjectId, ref: 'Reaction'}],
},{ timestamps: true})

const ReactionSchema = new Schema({
    user: {type: Schema.Types.ObjectId, ref: 'User', required: true},
    comment: {type: Schema.Types.ObjectId, ref: 'Comment', required: true},
    date: {type: Schema.Types.Date, default: Date.now, required: true}
})

我的查询：

this.model.Reaction.aggregate([            
        {
          $group: {
            _id: "$comment",
            num: { $sum: 1 }
          }
        },
        { $sort: { num: -1 } },
        {
          $lookup: {
            from: "comments",
            localField: "_id",
            foreignField: "_id",
            as: "Com",
          }
        },
        { $unwind: "$Com" },
        {
            $match: {"Com.blog": '629af177e03ab4cfe845a9a4'}
        },
        {
          $project: {
            content: "$Com.content",
            num: 1,
          }
        },
      ])

但是$ tookup后不接受$匹配！我也尝试使用“ $ filter”，但是它会得到一个“数组”，并且有一个对象！ 我的查询工作没有$匹配。但是需要过滤基于博客ID的评论

Answer 1

你能尝试一下吗？

this.model.Reaction.aggregate([            
    {
      $group: {
        _id: "$comment",
        num: { $sum: 1 }
      }
    },
    { $sort: { num: -1 } },
    {
      $lookup: {
        from: "comments",
        localField: "_id",
        foreignField: "_id",
        as: "Com",
      }
    },
    { $unwind: "$Com" },
    {
        $match: {"Com.blog": mongoose.Types.ObjectId('629af177e03ab4cfe845a9a4')}
    },
    {
      $project: {
        content: "$Com.content",
        num: 1,
      }
    },
  ])