I am trying to order by the count of the associated model, and have been getting the following error from Sequelize

Cannot read property '_modelAttribute' of undefined

I have following code:

db.user.belongsToMany(db.user, {
  as: "User",
  through: "UserFollowers",
  foreignKey: "user_id"
});
db.user.belongsToMany(db.user, {
  as: "Follower",
  through: "UserFollowers",
  foreignKey: "follower_id"
});

and

   User.findAll({
          attributes:["username",db.sequelize.literal('(SELECT COUNT(*) FROM "public"."Users","public"."UserFollowers" WHERE "Users".user_id = "UserFollowers".user_id GROUP BY "Users".user_id)'),'followercount'],
          include:[{model:User,as:'Follower'}],
          order:[{ model: User, as: 'Follower' }[db.sequelize.literal('followercount')],'DESC']
      }).then(users => {
          res.json(users)
      })

I appreciate any help!

I am trying to order by the count of the associated model, and have been getting the following error from Sequelize

Cannot read property '_modelAttribute' of undefined

I have following code:

db.user.belongsToMany(db.user, {
  as: "User",
  through: "UserFollowers",
  foreignKey: "user_id"
});
db.user.belongsToMany(db.user, {
  as: "Follower",
  through: "UserFollowers",
  foreignKey: "follower_id"
});

and

   User.findAll({
          attributes:["username",db.sequelize.literal('(SELECT COUNT(*) FROM "public"."Users","public"."UserFollowers" WHERE "Users".user_id = "UserFollowers".user_id GROUP BY "Users".user_id)'),'followercount'],
          include:[{model:User,as:'Follower'}],
          order:[{ model: User, as: 'Follower' }[db.sequelize.literal('followercount')],'DESC']
      }).then(users => {
          res.json(users)
      })

I appreciate any help!

• javascript
• sql
• node.js
• sequelize.js

Share Improve this question Follow asked Feb 1, 2019 at 9:38 TripleNTripleN 3111 silver badge44 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 6

From glancing at the code, the issue seems to be on the ordering clause. Change it to:

order: [[{ model: User, as: 'Follower' }, 'followercount', 'DESC']]

If that doesn't cut it, try logging the oute of the query by adding logging: console.log. That should help you identify what part is failing by analyzing the sql query.