How to get findMany with count?
I have following query
and have following relation
how to get serviceOrders with serviceOrderItems count?
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)],
}); 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),
}),
);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?