MongoDB Atlas层级$lookup表达式不被允许，求代码故障排查

报错信息 #

Error validating $lookup value. err=$lookup against an expression value is not allowed in this atlas tier.

相关Schema定义 #

Movies Schema #

const mongoose = require("mongoose");

const MovieSchema = new mongoose.Schema(
  {
    title: { type: String, required: true, unique: true },
    desc: { type: String },
    img: { type: String },
    imgTitle: { type: String },
    imgSm: { type: String },
    trailer: { type: String },
    video: { type: String },
    year: { type: String },
    limit: { type: Number },
    genre: { type: String },
    isSeries: { type: Boolean, default: false },
  },
  { timestamps: true }
);

module.exports = mongoose.model("movies", MovieSchema);

Lists Schema #

const mongoose = require("mongoose");

const ListSchema = new mongoose.Schema(
  {
    title: { type: String, required: true, unique: true },
    type: { type: String },
    genre: { type: String },
    content: [
      { type: mongoose.Schema.Types.ObjectId, required: false, ref: "movies" },
    ],
  },
  { timestamps: true }
);

module.exports = mongoose.model("lists", ListSchema);

问题代码（聚合查询） #

const list = await List.aggregate([
  { $sample: { size: 4 } },
  {
    $lookup: {
      from: "$movies",
      foreignField: "_id",
      localField: "content",
      as: "content",
    },
  },
]);
res.status(200).json(list);

问题原因及解决方法 #

• 问题根源：$lookup的from字段错误加了$符号，MongoDB会把$movies识别为表达式引用，而你的Atlas套餐 tier不支持这种用法。from字段需要直接填写关联集合的实际名称，不需要加美元符号。
• 修复后的代码：

const list = await List.aggregate([
  { $sample: { size: 4 } },
  {
    $lookup: {
      from: "movies", // 去掉前面的$符号
      foreignField: "_id",
      localField: "content",
      as: "content",
    },
  },
]);
res.status(200).json(list);

• 补充说明：如果你的集合在数据库中是Mongoose自动复数化后的名称，需要确认实际名称后填入from字段。这里Movie模型导出时指定的集合名是"movies"，所以直接填写即可。

内容的提问来源于stack exchange，提问作者Lakruwan Pathirage