sequelize query association 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 },
        }],
      }],