I am new to pothos and graphql. i have some problems related to query.

[MinhNguyen5199]

builder.queryField("find_order_items", (t) =>
  t.prismaField({
    type: ["order_items"],
    resolve: (query, __parent, __args, _ctx, _info) =>
      prisma.order_items.findMany({
        ...query,
        where: {
          user_id: "55bedbd6-d5db-4af8-9502-b505c8063734",
         `what go in user_id, so I can query order_items based on the user_id `
        }
      }),
  })
);

const listOrderItems = gql`
query ListOrderItems($user_id: String){
  find_order_items(user_id: $user_id ){
    id
    quantity
  }
}

is the code above correct to query order_items based on user_id ?

const {data, loading, error} = useQuery(listOrderItems, {variables: {user_id: minh}  })

[MinhNguyen5199]

i finally find and answer for my problem.

builder.queryField("order_items", (t) =>
  t.prismaField({
    type: ["order_items"], // Assuming "Product" is the name of your product model
    args: { user_id: t.arg.string() },
    resolve: async (query, _parent, args, _ctx, _info) => {
      const { user_id } = args;
      return await prisma.order_items.findMany({
        ...query,
        where: {
          user_id: {
            contains: user_id? user_id : "",
            mode: "insensitive", // This makes the search case-insensitive
          },
        },
      });
    },
  })
);

[hayes]

I might change this slightly to make the query more efficient when you don't have a user_id:

builder.queryField("order_items", (t) =>
  t.prismaField({
    type: ["order_items"], // Assuming "Product" is the name of your product model
    args: { user_id: t.arg.string() },
    resolve: async (query, _parent, args, _ctx, _info) => {
      const { user_id } = args;
      return await prisma.order_items.findMany({
        ...query,
        where: {
          user_id:  user_id ? {
            contains: user_id,
            mode: "insensitive", // This makes the search case-insensitive
          } : undefined,
        },
      });
    },
  })
);

[MinhNguyen5199]

This is the first time I am using Pothos and no one in my company has used GraphQL before. It sometimes gives me a headache. I start considering whether I am choosing a right job or not. LOL