Sails.js在哪里填充 [英] Sails.js populate with where

问题描述

我需要选择带狗的用户(type等于狗"的宠物)

I need to select users with dogs (pets with type equal 'dog')

var User = Waterline.Collection.extend({

  identity: 'user',

  attributes: {
    firstName: 'string',
    lastName: 'string',

    pets: {
      collection: 'pet',
      via: 'owner'
    }
  }
});

var Pet = Waterline.Collection.extend({

  identity: 'pet',

  attributes: {
    type: 'string',
    name: 'string',

    owner: {
      model: 'user'
    }
  }
});

我没有找到任何示例，我尝试过这样

I didn't find any examples, I tried like this

User.find().populate('pets', {type: 'dog'}).exec(err, users) ...

还有这个

User.find().where({'pets.type': 'dog'}).populate('pets').exec(err, users) ...

但这不起作用

如果结果用户数组没有宠物记录，那就太好了

Would be greate if result users array will has no pets records

推荐答案

您尝试过吗?

User.find().populate('pets', {
  where: {
    type: 'dog'
  }
}).exec(err, users)...

这篇关于Sails.js在哪里填充的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！