search_tickets
Query Request Tracker using TicketSQL to find tickets by owner, queue, subject, or status. Retrieve relevant fields for each ticket to manage and resolve issues.
Instructions
Search for tickets using RT's TicketSQL query language. TicketSQL has non-obvious syntax — consult get_ticketsql_grammar before writing any query involving Status, date conditions, custom fields, or special values. Key syntax notes: Status has meta-values Active and Inactive that match all active/inactive statuses across lifecycles (e.g. Status = 'Active' rather than Status = 'open'). Basic examples: "Queue = 'General' AND Owner = 'Nobody'", "Subject LIKE 'login'". Always include fields=Subject,Status,Queue,Owner,Requestor,Priority,LastUpdated,Due unless context calls for a different set.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | Page number (default 1) | |
| order | No | Sort direction | |
| query | Yes | TicketSQL query string | |
| fields | No | Comma-separated list of extra fields to include | |
| orderby | No | Field to sort by (e.g. Created, Priority, id) | |
| per_page | No | Results per page (max 100, default 20) | |
| subfields | No | Expand object fields inline, e.g. {"Queue": "Name", "Owner": "Name,EmailAddress"} |