search_tickets
Search Request Tracker tickets using TicketSQL to filter by owner, date, queue, or status. Get matching ticket summaries with sorting and pagination.
Instructions
Search for tickets using RT's TicketSQL query language. Returns summary information for matching tickets, with optional sorting and pagination.
The query is TicketSQL (NOT free-text keyword search). Examples:
My last 10 tickets: query="Owner = 'CurrentUser'", orderby="Created", order="DESC", per_page=10
Last 10 tickets created: query="id > 0", orderby="id", order="DESC", per_page=10
Created after a date: query="Created > '2026-06-01'"
By requestor: query="Requestor = 'jsmith'" (also Cc, AdminCc, Watcher, Owner)
ID range: query="id > 261000 AND id < 261700"
Combined: query="Queue = 'Support' AND Status = 'open' AND LastUpdated > '7 days ago'"
Call the get_ticketsql_grammar tool for the full TicketSQL field/operator reference.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page | No | Page number to fetch (default 1). | |
| order | No | Sort direction. Defaults to DESC when orderby is set (newest/highest first). | |
| query | Yes | TicketSQL query string (e.g., "Created > '2026-06-01' AND Owner = 'jsmith'"). Use "id > 0" to match all tickets. | |
| fields | No | Comma-separated list of extra ticket fields to include (e.g., "Priority,Requestor"). | |
| orderby | No | Field to sort results by. | |
| per_page | No | Results per page (default 20, max 100). | |
| subfields | No | Expand nested object fields inline, e.g. {"Owner":"Name,EmailAddress","Queue":"Name"}. |