mongodb - 如何根据MongoDB中where条件中引用的文档详细信息获取父文档详细信息？

Question

我有两个文件，如下所示。

const ClaimDetailsSchema = mongoose.Schema({
    _id: mongoose.Schema.Types.ObjectId,
    benefitArea: String,
    gfo: String,
    productForm: String,
    type: String,
    status: String,
    claimTitle: String,
    claimId: String,
    claimName: String,
    exception: String,
    createdBy: String,
    createdByNtId: String,
    lastModifiedBy: String,
    claimType: {
        historyId: String,
        commentId: String,
        exportId: String,
        version: String,
        reason: String
    },
    Substantiations: [{ type: mongoose.Schema.Types.ObjectId, ref: 'Substantiations' }],
    Formulaes: [{ type: mongoose.Schema.Types.ObjectId, ref: 'Formulaes' }],
    regions: [String],
    favorites: [String],
    claimCreatedDate: { type: Date, default: Date.now },
    lastModifiedDate: { type: Date }
});

module.exports = mongoose.model('ClaimDetails', ClaimDetailsSchema);

const mongoose = require('mongoose'), Schema = mongoose.Schema;

const SubstantiationSchema = mongoose.Schema({
    _id: mongoose.Schema.Types.ObjectId,
    substantiation: String
});

module.exports = mongoose.model('Substantiations', SubstantiationSchema);

我需要根据 where 子句中的证实文本来获取 ClaimDetails。

我试过像下面这样，但没有运气。

exports.testCase = (req, res) => {
    Claimdetails.find().populate({ path: 'Substantiations', match: { substantiation: 'rel' } }).exec(function (err, claims) {
        res.send({ data: claims });
    });
};

标签： mongodbmongoose