querying through associations sequelize code example
Example 1: nested include sequelize
models.products.findAll({
include: [
{model: models.comments, include: [models.comments.users] }
]
})
Example 2: include with where clause in sequelize
Document.findAll({
where: {'$employee.manager.id$': id},
include: [{
model: models.Employee,
required: true,
as: 'employee',
include: [{
model: models.Manager,
required: true,
as: 'manager',
where: { id: managerId },
}],
}],