6 replies

Best way to get count in extras

await db.query.productSets
  .findMany({
    extras: {
      productsCount:
        sql`(SELECT count(*) from ${products} WHERE "Product"."productSetId" = ${productSets.id})`.as(
          'productsCount'
        )
    },
    with: { products: true }
  })

await db.query.productSets
  .findMany({
    extras: {
      productsCount:
        sql`(SELECT count(*) from ${products} WHERE "Product"."productSetId" = ${productSets.id})`.as(
          'productsCount'
        )
    },
    with: { products: true }
  })

is there a better way to do this without the

sql

sql

operator? I want to just use drizzle code (to make more complex queries). if i try to, i get weird issues. similarly, if i replace

"Product"."productSetId"

"Product"."productSetId"

with

${products.productSetId}

${products.productSetId}

, it tells me

productSetId

productSetId

does not exist on the ProductSet table (it uses the wrong table)

Drizzle Team•2y ago•

6 replies

jakeleventhal

Best way to get count in extras

await db.query.productSets
  .findMany({
    extras: {
      productsCount:
        sql`(SELECT count(*) from ${products} WHERE "Product"."productSetId" = ${productSets.id})`.as(
          'productsCount'
        )
    },
    with: { products: true }
  })

await db.query.productSets
  .findMany({
    extras: {
      productsCount:
        sql`(SELECT count(*) from ${products} WHERE "Product"."productSetId" = ${productSets.id})`.as(
          'productsCount'
        )
    },
    with: { products: true }
  })

is there a better way to do this without the

sql

sql

operator? I want to just use drizzle code (to make more complex queries). if i try to, i get weird issues. similarly, if i replace

"Product"."productSetId"

"Product"."productSetId"

with

${products.productSetId}

${products.productSetId}

, it tells me

productSetId

productSetId

does not exist on the ProductSet table (it uses the wrong table)

Best way to get count in extras

Similar Threads

Best way to get count in extras

Similar Threads

Similar Threads

Similar Threads