ORM relation `where` does not exist in type

Can someone help me understand if I'm doing something wrong? The following code (adapted from Query/Select filters gives a 'does not exist' error on

where

where

export async function getItem(id: string, userId: string) {
    const result = await db.query.item.findFirst({
        where: eq(t.item.id, id),
        with: {
            collection: {
                where: eq(t.collection.userId, userId)
            }
        }
    });
    return result;
}

export async function getItem(id: string, userId: string) {
    const result = await db.query.item.findFirst({
        where: eq(t.item.id, id),
        with: {
            collection: {
                where: eq(t.collection.userId, userId)
            }
        }
    });
    return result;
}

export async function getItem(id: string, userId: string) {
    const result = await db.query.item.findFirst({
        where: eq(t.item.id, id),
        with: {
            collection: {
                where: eq(t.collection.userId, userId)
            }
        }
    });
    return result;
}

export async function getItem(id: string, userId: string) {
    const result = await db.query.item.findFirst({
        where: eq(t.item.id, id),
        with: {
            collection: {
                where: eq(t.collection.userId, userId)
            }
        }
    });
    return result;
}

Object literal may only specify known properties, and 'where' does not exist in type..

If schema matters, I have a

user

user

user

user table, a

collection

collection

collection

collection table with fk (userId) and a

item

item

item

item table with fk (collectionId).

I should note that the query works, so maybe it's lacking proper types?

ORM relation `where` does not exist in type

Similar Threads

Similar Threads

Similar Threads