Ticketing Query Filters
This document provides details on the filters supported by each provider for each API operation. Filters can be used to restrict the results of an API operation, such as filtering by a specific field or value.
They are used in conjunction with the filter query parameter in the API request.
Autotask filters for query_tickets
| Field | Operators | Supported Values |
|---|---|---|
| companyid | eq, neq, in, not in, like, not like | string |
| createdate | eq, neq, gt, gte, lt, lte | datetime |
| description | eq, like | string |
| due_date | eq, neq, gt, gte, lt, lte | datetime |
| id | eq, neq, in | string |
| name | eq, like | string |
| priority | eq, neq, in, not in | URGENT, CRITICAL, HIGH, MEDIUM, LOW, PLANNING |
| queueid | eq, in | string |
| status | eq, neq, in, not in | string |
Jira filters for query_tickets
| Field | Operators | Supported Values |
|---|---|---|
| assignee | eq, neq, in, not in, like, not like | string |
| completion_date | eq, neq, gt, gte, lt, lte, in, not in | datetime |
| contact | eq, neq, in, not in, like, not like | string |
| created_at | eq, neq, gt, gte, lt, lte, in, not in | datetime |
| description | eq, neq, in, not in, like, not like | string |
| due_date | eq, neq, gt, gte, lt, lte, in, not in | datetime |
| id | eq, neq, in, not in | string |
| issue_type | eq, neq, in, not in, like, not like | string |
| labels | eq, neq, in, not in | string |
| name | eq, neq, in, not in | string |
| priority | eq, neq, in, not in | highest, high, medium, low |
| project | eq, neq, in, not in, like, not like | string |
| reporter | eq, neq, in, not in, like, not like | string |
| status | eq, neq, in, not in, like, not like | string |
| summary | eq, neq, in, not in, like, not like | string |
| text | eq, neq, in, not in, like, not like | string |
| updated_at | eq, neq, gt, gte, lt, lte, in, not in | datetime |
PagerDuty filters for query_tickets
| Field | Operators | Supported Values |
|---|
ServiceNow ITSM filters for query_tickets
| Field | Operators | Supported Values |
|---|---|---|
| assignee | eq, neq, in, not in, like, not like | string |
| completion_date | eq, neq, gt, gte, lt, lte, in, not in | datetime |
| contact | eq, neq, in, not in, like, not like | string |
| created_at | eq, neq, gt, gte, lt, lte, in, not in | datetime |
| description | eq, neq, in, not in, like, not like | string |
| due_date | eq, neq, gt, gte, lt, lte, in, not in | datetime |
| id | eq, neq, in, not in | string |
| issue_type | eq, neq, in, not in, like, not like | string |
| labels | eq, neq, in, not in | string |
| name | eq, neq, in, not in | string |
| priority | eq, neq, in, not in | highest, high, medium, low |
| project | eq, neq, in, not in, like, not like | string |
| reporter | eq, neq, in, not in, like, not like | string |
| status | eq, neq, in, not in, like, not like | string |
| summary | eq, neq, in, not in, like, not like | string |
| text | eq, neq, in, not in, like, not like | string |
| updated_at | eq, neq, gt, gte, lt, lte, in, not in | datetime |
ServiceNow SIR filters for query_tickets
| Field | Operators | Supported Values |
|---|---|---|
| assignee | eq, neq, in, not in, like, not like | string |
| completion_date | eq, neq, gt, gte, lt, lte, in, not in | datetime |
| contact | eq, neq, in, not in, like, not like | string |
| created_at | eq, neq, gt, gte, lt, lte, in, not in | datetime |
| description | eq, neq, in, not in, like, not like | string |
| due_date | eq, neq, gt, gte, lt, lte, in, not in | datetime |
| id | eq, neq, in, not in | string |
| issue_type | eq, neq, in, not in, like, not like | string |
| labels | eq, neq, in, not in | string |
| name | eq, neq, in, not in | string |
| priority | eq, neq, in, not in | highest, high, medium, low |
| project | eq, neq, in, not in, like, not like | string |
| reporter | eq, neq, in, not in, like, not like | string |
| status | eq, neq, in, not in, like, not like | string |
| summary | eq, neq, in, not in, like, not like | string |
| text | eq, neq, in, not in, like, not like | string |
| updated_at | eq, neq, gt, gte, lt, lte, in, not in | datetime |
Ticketing Test filters for query_tickets
| Field | Operators | Supported Values |
|---|---|---|
| id | eq, neq, in, not in, like, not like | string |
| text | eq, neq, in, not in, like, not like | string |
Torq filters for query_tickets
| Field | Operators | Supported Values |
|---|---|---|
| assignee | eq, in | string |
| created_at | gte, lte, gt, lt | datetime |
| issue_type | eq, in | string |
| priority | eq, in | string |
| status | eq, in | string |
| tags | eq, in | string |
| text | like | string |