7 replies

Trouble using findMany with joined relation and where clause on relation

Hello,

I'm trying to construct a query using the findMany function of drizzle, and perform a simple join to a second table with a foreign key relation and include a 'where' clause that keys on one of the columns of the joined table. My current query is constructed as follows:

  const response = await db.query.tableOne.findMany({
    where: and(gt(tableOne.createdAt, createdAfter), eq(tableOne.createdBy, userId)),
    with: {
      tableTwoEntity: {
        where: and(eq(tableTwo.organizationId, organizationId)),
      }
    },
    orderBy: [desc(tableOne.createdAt)],
    limit,
  })

  const response = await db.query.tableOne.findMany({
    where: and(gt(tableOne.createdAt, createdAfter), eq(tableOne.createdBy, userId)),
    with: {
      tableTwoEntity: {
        where: and(eq(tableTwo.organizationId, organizationId)),
      }
    },
    orderBy: [desc(tableOne.createdAt)],
    limit,
  })

I am querying against tableOne, which I have a relation to tableTwo defined for in my schema definition, with tableTwoEntity being the named entity of the relation. I would like to include a number of filters on tableOne, but additionally filter by tableTwo on one of the columns. For some reason Drizzle gives me a typescript error stating that the

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

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

. I believe this is the best practice way to do things, but would appreciate any guidance if I'm not following the correct best practice for doing this type of combined where clause in a findMany query. Thank you

Trouble using findMany with joined relation and where clause on relation

  const response = await db.query.tableOne.findMany({
    where: and(gt(tableOne.createdAt, createdAfter), eq(tableOne.createdBy, userId)),
    with: {
      tableTwoEntity: {
        where: and(eq(tableTwo.organizationId, organizationId)),
      }
    },
    orderBy: [desc(tableOne.createdAt)],
    limit,
  })

  const response = await db.query.tableOne.findMany({
    where: and(gt(tableOne.createdAt, createdAfter), eq(tableOne.createdBy, userId)),
    with: {
      tableTwoEntity: {
        where: and(eq(tableTwo.organizationId, organizationId)),
      }
    },
    orderBy: [desc(tableOne.createdAt)],
    limit,
  })

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

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

Trouble using findMany with joined relation and where clause on relation

Similar Threads

Trouble using findMany with joined relation and where clause on relation

Similar Threads

Similar Threads

Similar Threads