SELECT & Filters

Find All Records

const users = await pb.from(User).find();

final users = await pb.from('users').find();

{
  "action": "find",
  "table": "users"
}

Find One Record

const user = await pb.from(User)
  .where('email', 'jane@example.com')
  .findOne();

final user = await pb.from('users')
    .where('email', 'jane@example.com')
    .findOne();

{
  "action": "findOne",
  "table": "users",
  "query": { "email": "jane@example.com" }
}

Count Records

TypeScript
Dart

const count = await pb.from(User).where('status', 'active').count();
// Returns: number

final count = await pb.from('users').where('status', 'active').count();

Pagination

Pulsabase uses cursor-style pagination via limit and offset:

// Page 1: records 1–20
const page1 = await pb.from(User)
  .orderBy('created_at', 'desc')
  .limit(20)
  .offset(0)
  .find();

// Page 2: records 21–40
const page2 = await pb.from(User)
  .orderBy('created_at', 'desc')
  .limit(20)
  .offset(20)
  .find();

final page1 = await pb.from('users')
    .orderBy('created_at', ascending: false)
    .limit(20)
    .offset(0)
    .find();

{
  "action": "find",
  "table": "users",
  "sort": [{ "field": "created_at", "order": "desc" }],
  "limit": 20,
  "offset": 0
}

To get the total count alongside your paginated results, run a separate .count() query with the same filters — this keeps the query engine efficient.

const [items, total] = await Promise.all([
  pb.from(Post).where('status', 'published').limit(20).offset(0).find(),
  pb.from(Post).where('status', 'published').count(),
]);

Select Specific Columns

const names = await pb.from(User).select('id', 'name', 'email').find();

final names = await pb.from('users').select(['id', 'name', 'email']).find();

{
  "action": "find",
  "table": "users",
  "select": ["id", "name", "email"]
}

Sort Records

// Single sort
const users = await pb.from(User).orderBy('created_at', 'desc').find();

// Multi-column sort
const users = await pb.from(User)
  .orderBy('last_name', 'asc')
  .orderBy('first_name', 'asc')
  .find();

final users = await pb.from('users')
    .orderBy('created_at', ascending: false)
    .find();

{
  "action": "find",
  "table": "users",
  "sort": [
    { "field": "last_name", "order": "asc" },
    { "field": "first_name", "order": "asc" }
  ]
}

const cities = await pb.from(User).select('city').distinct().find();

// DISTINCT ON a specific column
const uniqueByCity = await pb.from(User).distinctOn('city').find();

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