admin管理员组

文章数量:1123037

I want to filter conversations based on a user Id and get all users in that conversation. Users and conversations are joined using a through model

This is my approach

user.entity.ts

@BelongsToMany(Conversation,() => ConversationMember)
conversations : Conversation[]

conversation.entity.ts

@BelongsToMany(User , () => ConversationMember)
members: User[]

service.ts

const allConversations = await Conversations.findAndCountAll({
       where: {
              $members.id$: userId
              },
       attributes: [ 'id', 'createdAt'],
       include:[
      {
        model: User,
        as: 'members',
        attributes: ['id', 'username', 'firstName', 'lastName'],
        through: {
          attributes: [],
        },
      ]
});

This returns an error"

"missing FROM-clause entry for table "members"",

I want to filter conversations using user Id and get all members of the conversation

本文标签：

版权声明：本文标题：node.js - How to filter associated models connected using through table and keeping all associated model - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1736542767a1944406.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。