BA
Better Auth•7d ago
Maqed

How can I get member with user in adapter

I'm trying to create a plugin that needs the listing of organization members. So I want it to get members and also users. 
listMembers: async (organizationId: string): Promise<Member[]> => {
      const members: Member[] = await adapter.findMany({
        model: "member",
        where: [
          {
            field: "organizationId",
            value: organizationId,
          },
        ],
      });
      return members;
    },
listMembers: async (organizationId: string): Promise<Member[]> => {
      const members: Member[] = await adapter.findMany({
        model: "member",
        where: [
          {
            field: "organizationId",
            value: organizationId,
          },
        ],
      });
      return members;
    },
How can I get the members & also their user object as shown in the following schema: 
model Member {
  id               String            @id
  organizationId   String
  organization     Organization      @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  userId           String
  user             User              @relation(fields: [userId], references: [id], onDelete: Cascade)
  role             String
  teamId           String?
  createdAt        DateTime

  @@map("member")
}
model Member {
  id               String            @id
  organizationId   String
  organization     Organization      @relation(fields: [organizationId], references: [id], onDelete: Cascade)
  userId           String
  user             User              @relation(fields: [userId], references: [id], onDelete: Cascade)
  role             String
  teamId           String?
  createdAt        DateTime

  @@map("member")
}
No description
Solution:
You can't using the current implementation of our adapter system. You'll need to use the adapter and fetch each user by user ID as well....
Jump to solution
2 Replies
Solution
Ping
Ping•7d ago
You can't using the current implementation of our adapter system. You'll need to use the adapter and fetch each user by user ID as well.
Maqed
MaqedOP•7d ago
Okay thank you!

Did you find this page helpful?