whereHas / whereDoesntHave

whereHas

Find records that have at least one related record matching a condition:

TypeScript

// Users who have at least one published post
const authors = await pulsabase.from(User)
  .whereHas('posts', (q) => q.where('status', 'published'))
  .find();

Dart

final authors = await pulsabase.from('users')
    .whereHas('posts', (q) => q.where('status', 'published'))
    .find();

whereDoesntHave

Find records with no matching related records:

TypeScript

// Users who never placed an order
const inactive = await pulsabase.from(User)
  .whereDoesntHave('orders')
  .find();

Dart

final inactive = await pulsabase.from('users')
    .whereDoesntHave('orders')
    .find();