How to get findMany with count?

I have following query
    const result = await this.db.query.serviceOrders.findMany({
      where: and(...wheres),
      with: {
        vehicle: {
          with: {
            make: true,
            model: true,
          },
        },
        customer: true,
        branch: {
          columns: {
            name: true,
          },
        },
      },
      orderBy: [desc(serviceOrders.startedDate)],
    });


and have following relation
export const serviceOrdersRelation = relations(
  serviceOrders,
  ({ one, many }) => ({
    vehicle: one(vehicles, {
      fields: [serviceOrders.vehicleId],
      references: [vehicles.id],
    }),
    customer: one(customers, {
      fields: [serviceOrders.customerId],
      references: [customers.id],
    }),
    branch: one(branches, {
      fields: [serviceOrders.branchId],
      references: [branches.id],
    }),
    serviceOrderItems: many(serviceOrderItems),
    payments: many(serviceOrderPayments),
  }),
);


how to get serviceOrders with serviceOrderItems count?
Was this page helpful?