left join based on column in sequelize code example
Example 1: left join in sequelize
Shop.findAll({
where:{id:shopId},
include:[
{ model:ShopAd, as:'ads',
where:{
is_valid:1,
is_vertify:1},
required:false
}
]
})
.success(function(result) {
callback(result);
});
Example 2: sequelize left join attributes
Users.findAll({
include: [
{
model: Role,
as: 'roles',
attributes: ['columnNameToInclude']
}
]
});