Unable to parse a sequelize object in Node js

Question

Following is the output of join query using sequelize ORM

[ dashboard_grid_elements {
dataValues: 
 { id: 1,
   grid_id: '816',
   type: 1,
   subtype: 1,
   created_at: 2018-04-09T13:33:05.776Z,
   updated_at: 2018-04-09T13:33:05.776Z },
_previousDataValues: 
 { id: 1,
   grid_id: '816',
   type: 1,
   subtype: 1,
   created_at: 2018-04-09T13:33:05.776Z,
   updated_at: 2018-04-09T13:33:05.776Z },
_changed: {},
_modelOptions: 
 { timestamps: true,
   validate: {},
   freezeTableName: true,
   underscored: true,
   underscoredAll: false,
   paranoid: false,
   rejectOnEmpty: false,
   whereCollection: null,
   schema: null,
   schemaDelimiter: '',
   defaultScope: {},
   scopes: [],
   indexes: [],
   name: [Object],
   omitNull: false,
   tableName: 'dashboard_grid_elements',
   sequelize: [Object],
   hooks: {},
   uniqueKeys: {} },
_options: 
 { isNewRecord: false,
   _schema: null,
   _schemaDelimiter: '',
   include: undefined,
   includeNames: undefined,
   includeMap: undefined,
   includeValidated: true,
   raw: true,
   attributes: undefined },
__eagerlyLoadedAssociations: [],
isNewRecord: false } ]

When trying to get the value of type using dashboard_grid_elements.type,it shows undefined.Is there any way to parse this json object.

Vivek Doshi · Accepted Answer · 2018-04-11 05:42:54Z

2

Add raw : true your query , it will return plain object .

model.findOne({
    raw : true ,
    ...
}).then((user) => {
    console.log(user.type);
})

OR (Only if you are using findOne or getting single object not array of object)

model.findOne({
    ...
}).then((user) => {
    user = user.toJSON();
    console.log(user.type);
})

edited Apr 11, 2018 at 5:42

answered Apr 11, 2018 at 5:36

Vivek Doshi

58.8k12 gold badges120 silver badges126 bronze badges

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

Comments

marc_s · Accepted Answer · 2021-12-31 14:15:31Z

0

Course.findOne({raw : true ,where: {
           course_slug:slug,
           status:responseCode.STATUS_ACTIVE
       },attributes: ['id','course_title','course_slug','description','age_group','image','no_of_student_in_class',
           'class_duration','no_of_classes','per_class_fee','is_certificate','is_course_upcoming','what_we_learn','features']}).then(course_detial =>{
       result(null,course_detial);
   }).catch(err =>{
       console.log(err)
   });

edited Dec 31, 2021 at 14:15

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Dec 11, 2021 at 21:00

kush

6656 silver badges7 bronze badges

Collectives™ on Stack Overflow

Unable to parse a sequelize object in Node js

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related