使用 populate() 和 Mongoose 引用文档的子索引

我正在尝试返回创建文档的用户的名字和姓氏，以及最后修改它的用户。我populate()以前在两个集合之间进行 JOIN，但它对我不起作用。

这是区域模型

var mongo     = require('mongoose'),
    validator = require('mongoose-unique-validator'),
    Schema    = mongo.Schema


var model = new Schema({
    NAME:       { type: String, required: true, unique: true, max: 50, min: 3 },
    STATUS:     { type: String, default: 'active' },
    ADDED_BY:   { type: Schema.Types.ObjectId, ref: 'users' },
    ADDED_DATE: { type: Date, default: Date.now },
    MODIFY_BACKLOG :[{
        USER:     { type: Schema.Types.ObjectId, ref:'users' },
        DATE:     { type: Date, default: Date.now },
        CURRENT:  { type: String },
        MODIFIED: { type: String }
    }]


}, {collection :'areas'})

model.plugin( validator, { message: 'The {PATH} is not valid or duplicated' } )
module.exports = mongo.model('Area', model )

正如您所看到的索引ADDED_BY，MODIFY_BACKLOG.USER它们指的是集合users。

这是用户模型

var mongo     = require('mongoose'),
    validator = require('mongoose-unique-validator'),
    Schema = mongo.Schema

var userSchema = new Schema({
    PERSONAL_DATA: {
        NAME:            { type: String, required: [ true, 'The name is necessary' ], max: 50 },
        LAST_NAME:       { type: String, required: [ true, 'the lastname is necessary' ], max: 100 },
        PHOTO:           { type: String, max: 100 },
        BIRTHDAY:        { type: Date },
        MARITIAL_STATUS: { type: Schema.Types.ObjectId, ref: 'maritial_statuses' },
        GENDER:          { type: String, max: 1 },
        EMAIL:           { type: String, required: true  },
    },
    COMPANY_DATA: {
        JOB:      { type: Schema.Types.ObjectId, ref: 'jobs' },
        AREA:     { type: Schema.Types.ObjectId, ref: 'areas' },
        ROLE:     { type: Schema.Types.ObjectId, ref: 'roles' },
        BOSS:     { type: Schema.Types.ObjectId, ref: 'users' },
    }
}, { collection: 'users' } )

model.plugin( validator, { message: 'The {PATH} is not valid or duplicated' } )

module.exports = mongo.model('User', userSchema )

由于该模型中的信息非常可靠，因此我决定将其分成PERSONAL_DATA, COMPANY_DATA另外两个索引PAYMENT_DATA, ENGINE_DATA，每个索引都保留引用父亲姓名的索引，但我不感兴趣，因为它们与问题，它是大约的模型。300 行。

里面COMPANY_DATA.AREA是包含用户所属区域的地方，我认为与这个问题无关，但以防万一。

这是区域模型消耗的路径

var express = require('express'),
    Areas   = require('../../models/catalogs/areas'),
    app     = express()

app.get('/:from', (req, res) => {

    var from = parseInt( req.params.from )
    var populate = { 
        path: 'users', 
        select: 'NAME LAST_NAME'
    }
    Areas.find()
        .sort('NAME').populate( populate )
        .limit(10).skip(from)
        .exec((error, data) => {
            if (error) {
                return res.status(500).json({
                    success: false,
                    error
                })
            }

            Areas.count({}, ( err, total ) => {
                res.status(200).json({
                    success: true,
                    data,
                    total
                })
            })
            
        })
})

module.exports = app

对于该方法populate()，我传递了一个具有相同名称的变量，我在其中引用集合以及我需要用户提供的数据。这就是我卡住的地方，因为它没有给我带来用户的信息，它只给我带来了该地区的信息，在这里我有三个问题

我怎样才能让收藏的加入尊重我？

我如何告诉它我需要的索引不是在文档的顶层，而是在 PERSONAL_DATA 中？我试过了

var populate = { 
        path: 'users', 
        select: 'PERSONAL_DATA.NAME PERSONAL_DATA.LAST_NAME'
    }

但最后还是一样

区域模型中的索引MODIFY_BACKLOG也有修改用户的ObjectId，怎么能说对用户的JOIN也是对那个索引做的呢？

我留下一个答案的例子

{
    "success": true,
    "data": [{
        "STATUS": "active",
        "_id": "5c547f4adadf433914f72c8c",
        "NAME": "Contabilidad y Finanzas",
        "ADDED_BY": "5c4f562deec6f4defeea759b",
        "ADDED_DATE": "2019-02-01T17:18:02.680Z",
        "__v": 0,
        "MODIFY_BACKLOG": []
    }, {
        "STATUS": "active",
        "_id": "5c645f476491cf093c51c38e",
        "NAME": "Recursos Humanos",
        "ADDED_BY": "5c4f562deec6f4defeea759b",
        "ADDED_DATE": "2019-02-13T18:17:43.036Z",
        "__v": 0,
        "MODIFY_BACKLOG": [{
            "DATE": "2019-02-13T19:43:18.273Z",
            "_id": "5c6473561370462754939107",
            "USER": "5c4f562deec6f4defeea759b",
            "CURRENT": "active",
            "MODIFIED": "{\"STATUS\":\"inactive\"}"
        }, {
            "DATE": "2019-02-13T19:43:24.213Z",
            "_id": "5c64735c1370462754939108",
            "USER": "5c4f562deec6f4defeea759b",
            "CURRENT": "inactive",
            "MODIFIED": "{\"STATUS\":\"active\"}"
        }]
    }],
    "total": 5
}