8 replies

How to get where relation has no rows

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

The

masterProducts

masterProducts

table has a one to many relationship with

unitCosts

unitCosts

(one master product has many unit costs). How do I modify

whereFilter

whereFilter

if I want to only fetch

masterProducts

masterProducts

rows that have no associated

unitCosts

unitCosts