Tutorial

import PocketBase from 'pocketbase';

const pb = new PocketBase("https://example.com");

export interface User {
  id: string;
  name: string;
  email: string;
  created: Date;
  updated: Date;
}

export interface Post {
  id: string;
  title: string;
  content: string;
  author: User;
  status: 'draft' | 'published';
  created: Date;
  updated: Date;
}

import { pbQuery } from '@sergio9929/pb-query';
import type { Post } from './types';

const query = pbQuery<Post>() // posts collection
  .fields([
    'title',
    'content:excerpt(100,true)',
    'status',
    'author',
    'expand.author.name', // Automatically expanded
  ])
  .search(['title', 'content', 'author.name'], 'footba')
  .and()
  .group((q) =>
    q.equal('status', 'published')
      .or()
      .equal('author.name', 'Sergio')
  )
  .sort(['-created'])
  .build(pb.filter);

const records = await pb.collection("posts").getList(1, 20, query);

/// <reference path="../pb_data/types.d.ts" />

routerAdd("GET", "/example", (e) => {
  const { pbQuery } = require('@sergio9929/pb-query');

  const { filter, sort } = pbQuery()
    .fields([
      'title',
      'content:excerpt(100,true)',
      'status',
      'author',
      'expand.author.name', // Automatically expanded
    ])
    .search(['title', 'content', 'author.name'], 'footba')
    .and()
    .group((q) =>
      q.equal('status', 'published')
        .or()
        .equal('author.name', 'Sergio')
    )
    .sort(['-created'])
    .build(pb.filter);

    // ...
});

routerAdd("GET", "/example", (e) => {
  // ...

  const records = $app.findRecordsByFilter(
    'posts',
    filter.raw,
    sort,
    20,
    0,
    filter.values,
  );

  return e.json(200, records);
});