TTC
Theo's Typesafe Cult•15mo ago
EQ

Difference between where in Prisma

Hello, is there a difference between this beside how you write it? 
await prisma.user.count({
  where: {
    post: { // between this
      id: postId
    }
    post_id: postId // and this
  }
})
await prisma.user.count({
  where: {
    post: { // between this
      id: postId
    }
    post_id: postId // and this
  }
})
2 Replies
Neto
Neto•15mo ago
direct difference, no just allow you to do more queries against the relationship
Neto
Neto•15mo ago
https://www.prisma.io/docs/concepts/components/prisma-client/filtering-and-sorting#filter-on-relations
Prisma
Filtering and sorting (Concepts)
Use the Prisma Client API to filter records by any combination of fields or related record fields, and sort the results.
Want results from more Discord servers?
Add your server
More Posts
is there any way to redirect to the default 404 page after your search query on the server component```typescript export async function generateMetadata( pageProps: PageProps ): Promise<Metadata> {i18n in T3 stack/headless CMSWill start today a new project with t3-stack. The client is an language school and we will offer the[Prisma DB] How to import from ssh tunnelI made a request ticket on their site, but how would I import from a platform (kinsta) that requiresHow should you approach invalidating queries in trpc?Is is possible to create a onSuccess handler inside procedures? I don't want to write the same invalBrowser suggestionAnyone here suggest me a good browser in whick I can separate my tabs. I use firefox and gosh yesterdeploying to vercel - typeerrorsLocally - everything works great, no type errors and its all fine. Trying to deploy to vercel and I'custom handleChangeWhy after checking if it's not undefined it goes into never?System architecture for processing data from multiple 3rd party APIsHello, I need some advice on the best practices and general direction I should consider for handling