userOrganizationModel.hasMany(organizationModel, { foreignKey: 'organization_id' }); // 此include未生效 const include = [{ model: organizationModel, required: false, where: { name: { $like: 'ext-%' } } }]; await userOrganizationModel.findAll({ include: include // 此include未生效 }) 想實現(xiàn)的原始sql: // mysql原生語句select * from user_organization where organization_id in(select id from organization where name like 'ext-%')
sequelize子查詢不生效
森林海
2019-02-28 14:11:16