我有下一次嘗試這樣做，但據說“likesAmount”列不存在。我該怎么辦？
let pictures = await models.Picture.findAll({
attributes: {
include: [
[sequelize.literal('(SELECT COUNT(*) FROM "pictureLikes" WHERE "pictureLikes"."pictureId"=picture.id)'), 'likesAmount'],
[sequelize.literal('(SELECT COUNT(*) FROM comments WHERE comments."pictureId"=picture.id)'), 'commentsAmount']
]
},
where:{likesAmount: 2} ,
});
uj5u.com熱心網友回復：
where您應該在這樣的選項中使用此文字：
where: Sequelize.where(sequelize.literal('(SELECT COUNT(*) FROM "pictureLikes" WHERE "pictureLikes"."pictureId"=picture.id)'), Op.eq, '2');
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/480002.html
標籤：sql 节点.js PostgreSQL 续集.js