如何使用mongoose从Mongo中的多个集合中获取数据

Question

当数据存储在多个集合中时，如何显示配置文件的详细数据

尝试了此链接

 const profile = await userKushala
      .find({_id: '5cd407c741f9e7373f10362c'})
      .populate({
        path: 'settingId',
        populate : {
            path : 'specialty',
          populate : {
            path: 'hospital_attached'
          }
        }
      })

const userRegisterSchema = new Schema({
userType: {
    type: String,
    required: true
},
mobile: {
    type: Number,
    required: true,
    unique: true
},
userId: {
    type: String,
    required: true
},
name: {
    type: String,
    required: true
},
email: {
    type: String,
    required: true
},
age: {
    type: Number,
    required: true
},
gender: {
    type: String,
    required: true
},
settingId: {
    type: mongoose.Schema.Types.ObjectId,
    ref: 'providerSetting'
}
})

const serviceProfileUpdate = new Schema({
   specialty :[{
    type: mongoose.Schema.Types.ObjectId,
    ref: 'specialtyMasterCsv'
}],
category: [{
    type: mongoose.Schema.Types.ObjectId,
    ref: 'categoryMasterCsv'
}],
subscriptionPlan: {
    type: mongoose.Schema.Types.ObjectId,
    ref: 'planMasterCsv'
},
medicine: {
    type : mongoose.Schema.Types.ObjectId,
    ref: 'kushalaUser' 
}
})

{  
   "_id":{  
      "$oid":"5cd93ea6bd96e43664f49bf3"
   },
   "specialty":[  
      {  
         "$oid":"5cda85f26ffe60259a75ba17"
      },
      {  
         "$oid":"5cda85f26ffe60259a75ba18"
      }
   ],
   "category":[  
      {  
         "$oid":"5cda85f26ffe60259a75ba17"
      },
      {  
         "$oid":"5cda85f26ffe60259a75ba18"
      }
   ],
   "subscriptionPlan":{  
      "$oid":"5cda85f26ffe60259a75ba17"
   },
   "medicine":{  
      "$oid":"5cd407c741f9e7373f10362c"
   },
   "__v":{  
      "$numberInt":"0"
   }
}

预期的结果将来自数据应该获取的所有集合，但使用我的代码，它给出的结果直到specialty，但在此之后，它只打印ObjectID

Answer 1

这就是我所做的，如果有人有更好的解决方案，它仍然有效，非常欢迎。希望能帮到别人。

const profile = await userKushala
      .find({_id: '5cd407c741f9e7373f10362c'})
      .populate({
        path: 'settingId',
        populate : {
            path : 'specialty category subscriptionPlan medicine'
            }
      })