Prisma ORM · Prisma Client queries

Find many with filters

Filter, sort and paginate.

const users = await prisma.user.findMany({
  where: { email: { endsWith: "@example.com" }, role: "ADMIN" },
  orderBy: { createdAt: "desc" },
  take: 20,
  skip: 0,
});

Official Prisma ORM documentation

More prisma client queries commands

All prisma client queries commands · Prisma ORM cheatsheet

Was this page helpful?