Mongoose关联查询中用自定义userId替代_id的解决方法

问题 #

现有后端系统中User模型使用自定义生成的userId（无法修改），新增Report接口时需要关联查询User数据，但因系统使用userId而非默认_id，导致populate关联映射失败，抛出CastError。

User模型代码 #

export const userSchema: Schema<User> = new Schema<User>({
  userId: { type: String, required: true },
  email: { type: String, required: true, unique: true },

});

const UserModel = mongoose.model<User>("User", userSchema);
export default UserModel;

Report模型代码 #

// Schema for the Report model
const reportSchema: Schema<IReport> = new Schema({
  reportedUserId: { type: String, ref: "User" },
  reporterId: { type: String, required: true, ref: "User" },
  reason: { type: String, required: true },
  createdAt: { type: Date, default: Date.now },
});

export const Report = mongoose.model<IReport>("Report");

查询代码 #

const reports = await Report.find(query)
    .populate({
          path: "reportedUserId",
          select: "userId email name nickname",
          model: UserModel,
          options: { localField: "reportedUserId", foreignField: "userId" },
        })
      
    .skip((page - 1) * limit)
    .limit(limit);
return reports;

报错信息 #

Error fetching reports: CastError: Cast to ObjectId failed for value "92e15ec7-f34d-4bd3-9b9e-95ba3fa99999" (type string) at path "_id" for model "User"
    at SchemaObjectId.cast (XXX\node_modules\mongoose\lib\schema\objectId.js:250:11)
    at SchemaType.applySetters (XXX\node_modules\mongoose\lib\schemaType.js:1221:12)
    at SchemaType.castForQuery (XXX\node_modules\mongoose\lib\schemaType.js:1636:17)
    at XXX\node_modules\mongoose\lib\schemaType.js:1597:18
    at Array.map (<anonymous>)
    at SchemaObjectId.handle$in (XXX\node_modules\mongoose\lib\schemaType.js:1593:14)
    at SchemaType.castForQuery (XXX\node_modules\mongoose\lib\schemaType.js:1632:20)
    at cast (XXX\node_modules\mongoose\lib\cast.js:352:39)
    at Query.cast (XXX\node_modules\mongoose\lib\query.js:4778:12)
    at Query._castConditions (XXX\node_modules\mongoose\lib\query.js:2199:10)
    at model.Query._find (XXX\node_modules\mongoose\lib\query.js:2225:8)
    at model.Query.exec (XXX\node_modules\mongoose\lib\query.js:4322:80)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
  stringValue: '"92e15ec7-f34d-4bd3-9b9e-95ba3fa99999"',
  messageFormat: undefined,
  kind: 'ObjectId',
  value: '92e15ec7-f34d-4bd3-9b9e-95ba3fa99999',
  path: '_id',
  reason: BSONError: input must be a 24 character hex string, 12 byte Uint8Array, or an integer
      at new ObjectId (XXX\node_modules\bson\lib\bson.cjs:2251:23)
      at castObjectId (XXX\node_modules\mongoose\lib\cast\objectid.js:25:12)
      at SchemaObjectId.cast (XXX\node_modules\mongoose\lib\schema\objectId.js:248:12)
      at SchemaType.applySetters (XXX\node_modules\mongoose\lib\schemaType.js:1221:12)
      at SchemaType.castForQuery (XXX\node_modules\mongoose\lib\schemaType.js:1636:17)
      at XXX\node_modules\mongoose\lib\schemaType.js:1597:18
      at Array.map (<anonymous>)
      at SchemaObjectId.handle$in (XXX\node_modules\mongoose\lib\schemaType.js:1593:14)
      at SchemaType.castForQuery (XXX\node_modules\mongoose\lib\schemaType.js:1632:20)
      at cast (XXX\node_modules\mongoose\lib\cast.js:352:39)
      at Query.cast (XXX\node_modules\mongoose\lib\query.js:4778:12)
      at Query._castConditions (XXX\node_modules\mongoose\lib\query.js:2199:10)
      at model.Query._find (XXX\node_modules\mongoose\lib\query.js:2225:8)
      at model.Query.exec (XXX\node_modules\mongoose\lib\query.js:4322:80)
      at process.processTicksAndRejections (node:internal/process/task_queues:95:5),
  valueType: 'string',
  model: Model { User }
}

尝试将reportedUserId和reporterId改为mongoose.Types.ObjectId类型并使用_id关联时查询正常，但无法修改User表或前端认证令牌传递逻辑，求正确的关联查询实现方式。

解决方案 #

核心问题 #

报错原因是Mongoose默认会用关联字段的值去匹配User模型的_id字段（ObjectId类型），但你的关联字段是自定义的字符串类型userId，因此触发类型转换错误。需要显式指定Mongoose使用自定义字段进行关联匹配。

修正后的查询代码 #

将localField和foreignField从options中移出，作为populate配置的顶级属性，明确指定关联字段：

const reports = await Report.find(query)
  // 关联被举报用户
  .populate({
    path: "reportedUserId",
    select: "userId email name nickname",
    model: UserModel,
    localField: "reportedUserId", // Report模型中存储关联值的字段
    foreignField: "userId"        // User模型中对应的关联字段
  })
  // 关联举报人（按需添加）
  .populate({
    path: "reporterId",
    select: "userId email name nickname",
    model: UserModel,
    localField: "reporterId",
    foreignField: "userId"
  })
  .skip((page - 1) * limit)
  .limit(limit);

return reports;

优化建议 #

1. 添加索引提升性能：在User模型的userId字段添加唯一索引，确保关联查询效率：

   userId: { type: String, required: true, unique: true, index: true },
   

2. 确认字段一致性：确保Report模型中存储的reportedUserId和reporterId与User模型的userId完全匹配（大小写、格式一致）。

内容的提问来源于stack exchange，提问作者Sudaraka Senevirathne