Aggregations & HAVING

Group By

TypeScript

const stats = await pulsabase.from(Order)
  .select(['status', { count: '*', as: 'total' }])
  .groupBy(['status'])
  .find();
// [{ status: 'active', total: 42 }, { status: 'pending', total: 8 }]

Dart

final stats = await pulsabase.from('orders')
    .select(['status', {'count': '*', 'as': 'total'}])
    .groupBy(['status'])
    .find();

HAVING

Filter aggregated results:

const popular = await pulsabase.from(Product)
  .select(['category', { count: '*', as: 'total' }])
  .groupBy(['category'])
  .having({ total: { $gt: 10 } })
  .find();

Distinct

final uniqueCities = await pulsabase.from('users')
    .select(['city'])
    .distinct()
    .find();