Get only dataValues from Sequelize ORM

node.js sequelize.js sequelize-cli
Gijo Varghese picture Gijo Varghese · Sep 23, 2017 · Viewed 47.7k times · Source

I'm using the sequelize ORM to fetch data from a PSQL DB. However, when I retrieve something, a whole bunch of data is given. The only data I want is inside 'dataValues'. Of course, I can use object.dataValues. But, is there any other good solutions?

I'm using Sequelize 4.10

Answer

Shivam picture Shivam · Sep 23, 2017

Yes you can

Model.findAll({
 raw: true,
 //Other parameters
});

would return just the data and not the model instance

Related questions

How to Add, Delete new Columns in Sequelize CLI

I've just started using Sequelize and Sequelize CLI Since it's a development time, there are a frequent addition and deletion of columns. What the best the method to add a new column to an existing model? For example, I want …

Read More
Set defaultValue to todays date in a Sequelize migration

I'm using Node Express with Sequelize and I want to set the defaultValue for the column "date" in the database to todays date. I tried with the following migration, but it didn't work, as it set the default date to …

Read More
sequelize select and include another table alias

I'm using sequelize to acess a postgres database and I want to query for a city and for example include the "Building" table but I want to rename the output to "buildings" and return the http response but I have …

Read More