list_jobs
Filter job postings by status, department, office, or date range, and sort results for easy browsing.
Instructions
List jobs with SQL-based filters and sorting. Use this for browsing jobs or filtering by status, department, office, or date ranges. For title search (partial match supported), use search_jobs instead.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | Page number (default: 1) | |
| limit | No | Items per page (default: 20, max: 100) | |
| department_ids | No | Comma-separated department IDs to filter by (includes descendants) | |
| office_ids | No | Comma-separated office IDs to filter by | |
| status | No | Comma-separated statuses to filter by: draft, pending_approval, rejected, scheduled, published, closed, archived | |
| sort_by | No | Field to sort by (default: created_at) | |
| sort_order | No | Sort direction (default: desc) | |
| created_after | No | Return jobs created on or after this ISO 8601 datetime | |
| created_before | No | Return jobs created on or before this ISO 8601 datetime | |
| updated_after | No | Return jobs updated on or after this ISO 8601 datetime | |
| updated_before | No | Return jobs updated on or before this ISO 8601 datetime |