Drizzle TeamDT
Drizzle Team•12mo ago
Mick

count() within query.findMany.with

I wonder if the new count() function can be used within query.model.findMany()? I didnt find a solution yet. Something like:

const items = await useDb().query.orders.findMany({
      columns: {
        id: true,
        status: true,
      },
      with: {
        products: {
          columns: {
            id: true,
          },
        },
      },
      extras: {
        productsCount: count(products.id).as('products_count'),
      },
    });


I saw this question came up a lot of times here on Discord but was never answered. I know an sql statement can be used but I would love to use count() without writing custom sql statements. Stackoverflow: https://stackoverflow.com/questions/79336230/how-to-use-count-within-query-findmany-in-drizzle-orm/79336237
Was this page helpful?