Hi, I have a schema akin to this. I have a need where I need to fetch all posts by

id

of the user as well as the

uuid

.

model User {
  id    Int    @id @default(autoincrement())
  uuid  String @default(cuid())
  posts Post[]
}

model Post {
  id       Int  @id @default(autoincrement())
  author   User @relation(fields: [authorId], references: [id])
  authorId Int
}

I get all the posts by authorId by this. How can I do something similar also with UUID?

const event = await prisma.posts.findMany({
    where: {
      authorId: 1
    }
  });

I don’t quite understand your query findUnique will return 1 post and not all posts. and you cannot pass authorId either because that’s not a unique field

It seems you would need to use

findMany

to get all the posts, you can use this query

const event = await prisma.post.findMany({
    where: {
      id: 1,
      authorId: 1,
      author: {
        uuid: 'cef9f8f8-f8f8-f8f8-f8f8-f8f8f8f8f8f',
      },
    },
  });

Yeah, sorry about that.