mongodb populate 过后的查询问题

Question

我有两个collection:
user:

let userSchema = mongoose.Schema({
  userid: String,
  name: String,
  avatar: String,
  mobile: String,
  roles: [{
    type: mongoose.Schema.Types.ObjectId,
    ref: 'Role'
  }]
}, {
  versionKey: false
})

let User = mongoose.model('User', userSchema)

和role:

let roleSchema = mongoose.Schema({
  name: String,
  nike: String
}, {
  versionKey: false
})

let Role = mongoose.model('Role', roleSchema)

现在有以下数据：

> db.user.find()
{
    "_id" : ObjectId("5dc371291c7f84365fa05eba"),
    "userid" : "suadmin",
    "name" : "超级管理员",
    "roles" : [ 
        ObjectId("5dc6767a1c7f84365fa0a377")
    ]
},
{
    "_id" : ObjectId("5dc681311c7f84365fa0a7c0"),
    "userid" : "lisi",
    "password" : "123456",
    "avatar" : "",
    "mobile" : "15652663001",
    "name" : "李四",
    "roles" : [ 
        ObjectId("5dc679301c7f84365fa0a4f1")
    ]
}

> db.roles.find()
{
    "_id" : ObjectId("5dc6767a1c7f84365fa0a377"),
    "name" : "超级管理员",
    "nike" : "suadmin"
},
{
    "_id" : ObjectId("5dc679301c7f84365fa0a4f1"),
    "name" : "普通用户",
    "nike" : "normal"
},
{
    "_id" : ObjectId("5dc79af38dd5e510e6ab0db7"),
    "name" : "评审员",
    "nike" : "checker"
}

然后我用populate role:

User.find().populate({
  path: 'roles',
  module: 'Role'
}).then(res => {
  console.log(res)
})
===>
{
    "_id" : ObjectId("5dc371291c7f84365fa05eba"),
    "userid" : "suadmin",
    "name" : "超级管理员",
    "roles" : [ 
        {
            "_id" : ObjectId("5dc6767a1c7f84365fa0a377"),
            "name" : "超级管理员",
            "nike" : "suadmin"
        }
    ]
},
{
    "_id" : ObjectId("5dc681311c7f84365fa0a7c0"),
    "userid" : "lisi",
    "password" : "123456",
    "avatar" : "",
    "mobile" : "15652663001",
    "name" : "李四",
    "roles" : [ 
        {
            "_id" : ObjectId("5dc79af38dd5e510e6ab0db7"),
            "name" : "评审员",
            "nike" : "checker"
        }
    ]
}

然后问题来了 我要怎么对populate后的数据过滤
比如我想找roles里有nike为checker的user
我这么查为什么没有结果：

 User.find().populate({
  path: 'roles',
  module: 'Role'
}).where('roles.nike').equals('checker')
.then(res => {
  console.log(res)
})
===>
[]

.where('roles.nike').equals('checker')写得有问题吗
有没有大佬提点一下，困扰一晚上了

Answer 1

在populate里加个 match

User.find().populate({
  path: 'roles',
  module: 'Role',
  match: { nike: 'checker'}
})