Playground
10,000 orders in an in-browser SQLite database, queried by the real engine.
Newest orders first, with status and category facets. Click a facet, a header or a row and watch the request and the SQL change. Docs →
What your users see signed in to acme
/
Click a row for its order lines. ⇧ click a header to sort by a second key. Products is locked: the resource disables sorting on it.
What the client sends, inside the server call. Lines that changed with your last action are marked.
await orders.query({ context: { orgId: "acme" }, // from your session, never the body summary: true, request: { pagination: { mode: "offset", pageIndex: 1, pageSize: 10, count: "exact" }, sorting: [ { key: "createdAt", dir: "desc" } ], search: { value: "", fields: [] }, filters: [], facets: [ { key: "status", mode: "exclude-self", limit: 10 }, { key: "orderLines.product.category", mode: "exclude-self", limit: 10 } ] }});