2 replies

With Query mode, is possible filter by a related table?

Is possible using db.query to filter (where) using a related table?

Example:

const users = await db.query.posts.findMany({
    where: (users, { eq }) => eq(posts.user.id, 1), // related user with post
})

const users = await db.query.posts.findMany({
    where: (users, { eq }) => eq(posts.user.id, 1), // related user with post
})

I know we can use with, but with will return the result and we can filter the with, I wanna filter the actual query using the related table.
We can do using the select

await db.select().from(posts).rightJoin(users, eq(users.id, posts.userId)).where(eq(posts.userId, users.id)

await db.select().from(posts).rightJoin(users, eq(users.id, posts.userId)).where(eq(posts.userId, users.id)

Drizzle Team•16mo ago•

2 replies

gwilliamnn

With Query mode, is possible filter by a related table?

Is possible using db.query to filter (where) using a related table?

Example:

const users = await db.query.posts.findMany({
    where: (users, { eq }) => eq(posts.user.id, 1), // related user with post
})

const users = await db.query.posts.findMany({
    where: (users, { eq }) => eq(posts.user.id, 1), // related user with post
})

I know we can use with, but with will return the result and we can filter the with, I wanna filter the actual query using the related table.
We can do using the select

await db.select().from(posts).rightJoin(users, eq(users.id, posts.userId)).where(eq(posts.userId, users.id)

await db.select().from(posts).rightJoin(users, eq(users.id, posts.userId)).where(eq(posts.userId, users.id)

With Query mode, is possible filter by a related table?

Similar Threads

With Query mode, is possible filter by a related table?

Similar Threads

Similar Threads

Similar Threads