9 replies

Filtering Entire Objects by Related Records in Drizzle ORM Query API

Hi,

Is there currently functionality with Drizzle's query API to filter entire objects based on the contents of their relationships, rather than just filtering the related objects themselves. Specifically, I want to filter the main object (sourceTable) based on a condition in its related object (userToSource).

Here is an example of what I'm currently doing:

const sources = await db.query.sourceTable.findMany({
    with: {
        signups: true, 
        userToSource: {
            where: (userToSource, {eq}) => eq(userToSource.userId, user.id),
        }
    },
});

const sources = await db.query.sourceTable.findMany({
    with: {
        signups: true, 
        userToSource: {
            where: (userToSource, {eq}) => eq(userToSource.userId, user.id),
        }
    },
});

In this example, I want the entire sourceTable object to be returned only if the userToSource relationship meets the specified condition (userToSource.userId === user.id). However, it seems that the current functionality only filters the userToSource relationship itself, not the main sourceTable object.

Thank in advance!

Drizzle Team•14mo ago•

9 replies

Evanston

Filtering Entire Objects by Related Records in Drizzle ORM Query API

const sources = await db.query.sourceTable.findMany({
    with: {
        signups: true, 
        userToSource: {
            where: (userToSource, {eq}) => eq(userToSource.userId, user.id),
        }
    },
});

const sources = await db.query.sourceTable.findMany({
    with: {
        signups: true, 
        userToSource: {
            where: (userToSource, {eq}) => eq(userToSource.userId, user.id),
        }
    },
});

Filtering Entire Objects by Related Records in Drizzle ORM Query API

Similar Threads

Filtering Entire Objects by Related Records in Drizzle ORM Query API

Similar Threads

Similar Threads

Similar Threads