36 replies

How to get the count of relations?

const products = await db.query.masterProducts.findMany({
  limit: pageSize,
  offset: page * pageSize,
  where: whereFilter
});

const products = await db.query.masterProducts.findMany({
  limit: pageSize,
  offset: page * pageSize,
  where: whereFilter
});

I have another table

inventoryItems

inventoryItems

and there is a one-to-many relationship where one

masterProduct

masterProduct

can have many

inventoryItems

inventoryItems

and one

inventoryItem

inventoryItem

is linked to one and only one

masterProduct

masterProduct

on the

masterProductId

masterProductId

field.

How can I include a count of

inventoryItems

inventoryItems

in this query? I just want a

number

number

of how many

inventoryItems

inventoryItems

have the

masterProductId

masterProductId

field matching the

id

id

field for each row in the

masterProducts

masterProducts

query