我一直試圖讓它工作一段時(shí)間,并希望獲得一些見(jiàn)解。目標(biāo):我正在嘗試根據(jù)他們目前擁有的喜歡數(shù)量對(duì)帖子進(jìn)行排序。當(dāng)前的:const posts = await db.post.findAll({ include: [ db.user, { model: db.like_post, where: { user_id: user }, required: false } ], where: { category }, group: [ [ sequelize.col('like_posts.post_id') ] ], order: [ [ sequelize.fn('count', sequelize.col('like_posts.post_id')), 'DESC' ] ]});我目前收到的錯(cuò)誤是:"message": "column \"post.id\" must appear in the GROUP BY clause or be used in an aggregate function",為了獲得正確的帖子順序,有人對(duì)我可能做錯(cuò)了什么有任何建議嗎?再次感謝所有的幫助和提示。
使用 Sequalize 按連接表計(jì)數(shù)列排序
叮當(dāng)貓咪
2023-05-25 16:04:57