mongoose 多表查询,查不到数据
//创建了两个 schema
var productSchema = new Schema({
id: Number,
specval:{type: Schema.Types.ObjectId,ref:'product_specval'}
},{collection:'product'})
var productSpecValSchema = new Schema({
_id: Schema.Types.ObjectId,
},{collection:'product_specval'})
//然后创建model,再去查询
var productModel = mongoose.model('product',ProductSchema);
var productSpecValModel = mongoose.model('product_specval',productSpecValSchema);
productModel.findOne({"_id":id})
.populate('specval')
.exec(function(err,docs){
console.log(docs)
})
只查到了product表中的数据,但是关联的product_specval的数据没有查到
数据是我自己用循环创建的了简单的几个json,导进去的,ObjectId的值也对得上