Better AuthBA
Better Auth•9mo 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;
    },

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")
}
image.png
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
Was this page helpful?