Read Documents

const user = await client.queryBuilder()
  .collection('users')
  .whereField('email').equals('alice@example.com')
  .executeUnique<User>();

if (user) {
  console.log('Found user:', user.name);
} else {
  console.log('User not found');
}

const result = await client.queryBuilder()
  .collection('users')
  .whereField('active').isTrue()
  .orderBy('createdAt', 'DESC')
  .limit(10)
  .offset(0)
  .execute<User>();

console.log(`Found ${result.records.length} active users`);

const count = await client.queryBuilder()
  .collection('users')
  .whereField('active').isTrue()
  .count();
console.log(`Active users: ${count}`);

const user = await client.queryBuilder()
  .collection('users')
  .whereField('id').equals('user_123')
  .executeUnique<User>();

// Page 1
const page1 = await client.queryBuilder()
  .collection('posts')
  .orderBy('createdAt', 'DESC')
  .limit(10)
  .offset(0)
  .execute();

// Page 2
const page2 = await client.queryBuilder()
  .collection('posts')
  .orderBy('createdAt', 'DESC')
  .limit(10)
  .offset(10)
  .execute();

const users = await client.queryBuilder()
  .collection('users')
  .whereField('active').isTrue()
  .selectFields(['id', 'name', 'email'])
  .orderBy('createdAt', 'DESC')
  .limit(50)
  .execute();