List records
list_recordsFetch paginated records from a PocketBase collection with filtering, sorting, and relation expansion. Skip total count to speed up queries.
Instructions
List records of a collection with pagination, filtering, sorting and relation expansion. Filter supports operators like =, !=, >, <, ~ (contains), and functions. Example filter: 'status = "active" && created > "2024-01-01"'. Use expand to inline related records (e.g. 'author,comments_via_post'). Set skipTotal to true for faster queries when you don't need the total count.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | Page number (default 1). | |
| sort | No | Sort expression, e.g. '-created,title'. | |
| expand | No | Comma-separated relations to expand. | |
| fields | No | Comma-separated fields to return (supports :excerpt modifiers). | |
| filter | No | PocketBase filter expression. | |
| perPage | No | Items per page (default 30). | |
| skipTotal | No | Skip counting total items for performance. | |
| collection | Yes | Collection id or name. |