Sequelize, how to retrieve specific fields from joined tables

Question

Sequelize, how to retrieve specific fields from joined tables

I have:

db.Animal.findAll({ attributes: ['id', 'name'], include: [db.Age] }).success(function(results) {
    console.log(JSON.stringify(results));
});

It gives me the fields ID and NAME from table Animal... but I also want to get specific fields from table Age and not all the fields (this is how it is working right now).

What can I do?

node.js
express
sequelize.js

Answer 1

You can specify attributes within the include array. Try rearranging like so:

db.Animal.findAll({ attributes: ['id', 'name'], 
  include: [{ model: db.Age, attributes: ['field1'] }]
})
.success(function(res){ console.log( JSON.stringify(res) ) })