Prisma•5d ago

Why is omit not available for this query?

I am using prisma 5.21.1. If I try this call omit is not available why?

client.profile.findFirst({
      omit: {
        password: true,
      },
      where: {
        id: profileId,
      },
    });

client.profile.findFirst({
      omit: {
        password: true,
      },
      where: {
        id: profileId,
      },
    });

7 Replies

Yetzederixx•5d ago

That's a good question, do you have a specific error message you can share?

jsoneadayOP•5d ago

When I set a local Omit it tells me the type is never

Nurul•4d ago

Have you enabled omitApi preview feature?

Nurul•4d ago

https://www.prisma.io/docs/orm/prisma-client/queries/excluding-fields#excluding-a-field-globally-using-omit

Excluding fields | Prisma Documentation

This page explains how to exclude sensitive fields from Prisma Client

Nurul•4d ago

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["omitApi"]
}

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["omitApi"]
}

jsoneadayOP•4d ago

I was surprised that it's still in beta. I've enabled it but cannot get it to work for this query where my author has a password that I want to omit.

const authors = await this.#client.work.findMany({
      select: {
        author: {
          include: {
            works: {
              include: {
                workLikes: true,
              },
            },
          },
        },
      },
      orderBy: {
        workLikes: {
          _count: SortOrder.Desc,
        },
      },
      take: size,
    });

const authors = await this.#client.work.findMany({
      select: {
        author: {
          include: {
            works: {
              include: {
                workLikes: true,
              },
            },
          },
        },
      },
      orderBy: {
        workLikes: {
          _count: SortOrder.Desc,
        },
      },
      take: size,
    });

Nurul•9h ago

How have you configured global omit? https://www.prisma.io/docs/orm/prisma-client/queries/excluding-fields#excluding-the-password-field-without-using-omit Have you done something like this?

Gaming

Programming

Why is omit not available for this query?