findUnique is not working with variables different from "id"

[ranran2121]

Hi,
I am very new to this so bear with me, please.
I am implementing a search in a MySQL db where I have users with some fields, including the email. I tried this for searching a single user based on his ID and it works

(schema.graphql)  getUser(id: ID!): user!
(resolver) getUser: async (parent, args, context) => {
      let ID = parseInt(args.id);
      return context.prisma.user.findUnique({
        where: { id: ID },
      });
    },

however, when I try to write a search based on the email I get an error

(schema.graphql)  findUser(email: String!): user
(resolver) findUser: async (parent, args, context) => {
      let EMAIL = args.email;
      return context.prisma.user.findUnique({
        where: { email: EMAIL },
      });
    },

this is the error I get in the graphql playground

{
  "errors": [
    {
      "message": "\nInvalid `context.prisma.user.findUnique()` invocation in\n/Users/francescagiammichele/Documents/GraphQL/myproj/src/index.js:46:34\n\n  43 findUser: async (parent, args, context) => {\n  44   let EMAIL = args.email;\n  45   //console.log(email);\n→ 46   return context.prisma.user.findUnique({\n         where: {\n           email: 'user@email.com'\n           ~~~~~\n         }\n       })\n\nUnknown arg `email` in where.email for type userWhereUniqueInput. Did you mean `id`? Available args:\ntype userWhereUniqueInput {\n  id?: Int\n}\n\n",
      "locations": [
        {
          "line": 2,
          "column": 3
        }
      ],
      "path": [
        "findUser"
      ],
      "extensions": {
        "code": "INTERNAL_SERVER_ERROR",
        "exception": {
          "clientVersion": "3.5.0",
          "stacktrace": [
            "Error: ",
            "Invalid `context.prisma.user.findUnique()` invocation in",
            "/Users/francescagiammichele/Documents/GraphQL/myproj/src/index.js:46:34",
            "",
            "  43 findUser: async (parent, args, context) => {",
            "  44   let EMAIL = args.email;",
            "  45   //console.log(email);",
            "→ 46   return context.prisma.user.findUnique({",
            "         where: {",
            "           email: 'user@email.com'",
            "           ~~~~~",
            "         }",
            "       })",
            "",
            "Unknown arg `email` in where.email for type userWhereUniqueInput. Did you mean `id`? Available args:",
            "type userWhereUniqueInput {",
            "  id?: Int",
            "}",
            "",
            "",
            "    at Object.validate (/Users/francescagiammichele/Documents/GraphQL/myproj/node_modules/@prisma/client/runtime/index.js:34745:20)",
            "    at PrismaClient._executeRequest (/Users/francescagiammichele/Documents/GraphQL/myproj/node_modules/@prisma/client/runtime/index.js:39720:17)",
            "    at consumer (/Users/francescagiammichele/Documents/GraphQL/myproj/node_modules/@prisma/client/runtime/index.js:39661:23)",
            "    at /Users/francescagiammichele/Documents/GraphQL/myproj/node_modules/@prisma/client/runtime/index.js:39665:49",
            "    at AsyncResource.runInAsyncScope (async_hooks.js:197:9)",
            "    at PrismaClient._request (/Users/francescagiammichele/Documents/GraphQL/myproj/node_modules/@prisma/client/runtime/index.js:39665:27)",
            "    at request (/Users/francescagiammichele/Documents/GraphQL/myproj/node_modules/@prisma/client/runtime/index.js:39770:77)",
            "    at _callback (/Users/francescagiammichele/Documents/GraphQL/myproj/node_modules/@prisma/client/runtime/index.js:39978:14)",
            "    at PrismaPromise.then (/Users/francescagiammichele/Documents/GraphQL/myproj/node_modules/@prisma/client/runtime/index.js:39985:23)",
            "    at processTicksAndRejections (internal/process/task_queues.js:95:5)"
          ]
        }
      }
    }
  ],
  "data": {
    "findUser": null
  }
}

[chemicalkosek]

You would need to mark the email field in your schema as @unique, because findUnique queries only by unique fields.
If you don't want to mark email as @unique, you can try using findFirst

[ranran2121]

oh, that makes a lot of sense. Honestly, I thought that findUnique was a synonym for findOne.
Do I get any side effects if I mark two fields as unique (the ID and email, in this case)?

[chemicalkosek]

No side effects. I think you would even want to have user email as @unique because you don't want to have two users with the same email. The unique field will be also indexed.

[ranran2121]

thank you so much for your explanations :)

[isckosta]

I have the same problem, in my case I have this method:

async findByUuid(uuid: string) {
    const shoppingList = await this.prisma.shoppingList.findUnique({
      where: {
        uuid,
      },
    });

    if (!shoppingList) {
      throw new Error('Shopping list not found');
    }

    return shoppingList;
  }

And I get this error in the console:

[Nest] 33920  - 21/05/2024, 22:56:42   ERROR [ExceptionsHandler]
Invalid `this.prisma.shoppingList.findUnique()` invocation in
D:\Personal\market-sync\market-sync-backend\src\shopping-lists\shopping-lists.service.ts:22:43

 19 }
 20
 21 async findOne(id: number) {
→ 22   return await this.prisma.shoppingList.findUnique({
        where: {
      +   id: Int
        }
      })

Argument `id` is missing.
PrismaClientValidationError:
Invalid `this.prisma.shoppingList.findUnique()` invocation in
D:\Personal\market-sync\market-sync-backend\src\shopping-lists\shopping-lists.service.ts:22:43

 19 }
 20
 21 async findOne(id: number) {
→ 22   return await this.prisma.shoppingList.findUnique({
        where: {
      +   id: Int
        }
      })

Argument `id` is missing.
   at Tn (D:\Personal\market-sync\market-sync-backend\node_modules\.pnpm\@prisma+client@5.13.0_prisma@5.13.0\node_modules\@prisma\client\runtime\library.js:115:6855)
   at In.handleRequestError (D:\Personal\market-sync\market-sync-backend\node_modules\.pnpm\@prisma+client@5.13.0_prisma@5.13.0\node_modules\@prisma\client\runtime\library.js:122:6510)
   at In.handleAndLogRequestError (D:\Personal\market-sync\market-sync-backend\node_modules\.pnpm\@prisma+client@5.13.0_prisma@5.13.0\node_modules\@prisma\client\runtime\library.js:122:6188)
   at In.request (D:\Personal\market-sync\market-sync-backend\node_modules\.pnpm\@prisma+client@5.13.0_prisma@5.13.0\node_modules\@prisma\client\runtime\library.js:122:5896)
   at l (D:\Personal\market-sync\market-sync-backend\node_modules\.pnpm\@prisma+client@5.13.0_prisma@5.13.0\node_modules\@prisma\client\runtime\library.js:127:11167)
   at ShoppingListsService.findOne (D:\Personal\market-sync\market-sync-backend\src\shopping-lists\shopping-lists.service.ts:22:12)
   at D:\Personal\market-sync\market-sync-backend\node_modules\.pnpm\@nestjs+core@10.3.8_@nestjs+common@10.3.8_@nestjs+platform-express@10.3.8_reflect-metadata@0.2.2_rxjs@7.8.1\node_modules\@nestjs\core\router\router-execution-context.js:46:28
   at D:\Personal\market-sync\market-sync-backend\node_modules\.pnpm\@nestjs+core@10.3.8_@nestjs+common@10.3.8_@nestjs+platform-express@10.3.8_reflect-metadata@0.2.2_rxjs@7.8.1\node_modules\@nestjs\core\router\router-proxy.js:9:17

[robertiagar]

Instead of

const shoppingList = await this.prisma.shoppingList.findUnique({
      where: {
        uuid,
      },
    });

try

const shoppingList = await this.prisma.shoppingList.findUnique({
      where: {
        id:uuid,
      },
    });

[ludralph]

Hi there,

To keep our discussions organized and focused on the most relevant topics, we’re reviewing and tidying up our backlog. As part of this process, we’re closing discussions that have already been marked as answered but remain open.

If this discussion still requires further input or clarification, feel free to reopen it or start a new one with updated details. Your contributions are invaluable to the community, and we’re here to help!

For more details about our priorities and vision for the future of Prisma ORM, check out our latest blog post: https://www.prisma.io/blog/prisma-orm-manifesto.

Thank you for your understanding and ongoing support of the Prisma community!