Exclude primary key attributes from a sequelize query

Question

I have a sequelize query from multiple tables inner joined together. I need to group them by on a nested include model but the sequelize query throws the primary key every time, even if I mention the attributes as: attributes:[].

However attributes:[] is working for nested include models.

Answer 1

You can exclude any attributes by passing an exclude array into the attributes option:

MyModel.findAll({
  attributes: {exclude: ['some_field']}
});

Answer 2

For included models use attributes: ['prop_name']

Remember include/exclude will not affect nested tables use through: { attributes:[]}

Model.addScope('scope_name', {
      attributes: ['id', 'name'],
      include: [
        {
          model: models.role,
          as: 'roles',
          attributes: ['name'],
          through: {
            attributes: []
          }
        }
      ]

More details can be found here: https://github.com/sequelize/sequelize/issues/4074#issuecomment-153054311