3 replies

How do I use `where` inside `with`?

There's this example on the

query()

query()

page (https://orm.drizzle.team/docs/rqb)

await db.query.posts.findMany({
  where: (posts, { eq }) => (eq(posts.id, 1)),
  with: {
    comments: {
      where: (comments, { lt }) => lt(comments.createdAt, new Date()),
    },
  },
});

await db.query.posts.findMany({
  where: (posts, { eq }) => (eq(posts.id, 1)),
  with: {
    comments: {
      where: (comments, { lt }) => lt(comments.createdAt, new Date()),
    },
  },
});

But I'm getting a TypeScript error saying there could be no

where

where

inside

with

with

. I'm on

drizzle-orm

drizzle-orm

0.29

0.29

Drizzle ORM - Query

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

Drizzle Team•2y ago•

3 replies

Mike Borozdin

How do I use `where` inside `with`?

There's this example on the

query()

query()

page (https://orm.drizzle.team/docs/rqb)

await db.query.posts.findMany({
  where: (posts, { eq }) => (eq(posts.id, 1)),
  with: {
    comments: {
      where: (comments, { lt }) => lt(comments.createdAt, new Date()),
    },
  },
});

await db.query.posts.findMany({
  where: (posts, { eq }) => (eq(posts.id, 1)),
  with: {
    comments: {
      where: (comments, { lt }) => lt(comments.createdAt, new Date()),
    },
  },
});

But I'm getting a TypeScript error saying there could be no

where

where

inside

with

with

. I'm on

drizzle-orm

drizzle-orm

0.29

0.29

Drizzle ORM - Query

Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.

How do I use `where` inside `with`?

Similar Threads

How do I use `where` inside `with`?

Similar Threads

Similar Threads

Similar Threads