Get specific attributes from database using sequelize model query

Question

I have red the documentation of sequelize but could not get the idea/concept i wanted ,I don't want just one attribute to be shown. We have the following syntax to get the attributes we need

Model.findAll({
    attributes:['foo','bar]          
})

In my case I have many attributes in single table , I just want to hide one attribute.Is there any way in sequelize that we define the attribute which we don't want to see and get all other by default..

For Example....

    Model.findAll({
       attributes:hide foo , show all other attributes
})

AnyOne Can help..

Sujeet · Accepted Answer · 2021-06-24 14:56:31Z

2

You can use below syntax.

Model.findAll({
  attributes: {
    exclude: ['foo'] // hide this
  }
});

You can also exclude fields on model level by adding in their default scope like below.

const Model = sequelize.define('model',{
  secretColumn: Sequelize.STRING,
  //... and other columns
}, {
  defaultScope: {
    attributes: { exclude: ['secretColumn'] }
  }
});

answered Jun 24, 2021 at 14:56

Sujeet

3,8385 gold badges35 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get specific attributes from database using sequelize model query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related