2 replies

count() within query.findMany.with

I wonder if the new

count()

count()

function can be used within

query.model.findMany()

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'),
      },
    });

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

Drizzle Team•14mo ago•

2 replies

Mick

count() within query.findMany.with

I wonder if the new

count()

count()

function can be used within

query.model.findMany()

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'),
      },
    });

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'),
      },
    });

count() within query.findMany.with

Similar Threads

count() within query.findMany.with

Similar Threads

Similar Threads

Similar Threads