query_items
Retrieve items from a collection with filters, sorting, pagination, and search. Use Directus filter operators to precisely find data.
Instructions
Query items from a collection with advanced filtering, sorting, pagination, and search. Supports Directus filter operators like _eq, _neq, _lt, _lte, _gt, _gte, _in, _nin, _null, _nnull, _contains, _ncontains, _starts_with, _nstarts_with, _ends_with, _nends_with, _between, _nbetween. Example: {collection: "articles", filter: {"status": {"_eq": "published"}, "date_created": {"_gte": "2024-01-01"}}, sort: ["-date_created"], limit: 10}
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| collection | Yes | Collection name to query | |
| fields | No | Fields to return | |
| filter | No | Filter object using Directus filter syntax | |
| search | No | Search query string | |
| sort | No | Sort fields (prefix with - for descending) | |
| limit | No | Maximum number of items to return | |
| offset | No | Number of items to skip | |
| page | No | Page number (alternative to offset) | |
| aggregate | No | Aggregation functions | |
| groupBy | No | Fields to group by | |
| deep | No | Deep query for relational data |