# 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.

### Atlassian 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 |
| creator | eq, neq, in, not in, like, not like | string |
| 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 |


### Autotask Operations Cloud 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 |


### Freshdesk filters for `query_tickets`

| Field | Operators | Supported Values |
|  --- | --- | --- |
| agent_id | eq, gte, lte | number |
| created_at | eq, gte, lte | datetime |
| due_by | eq, gte, lte | datetime |
| fr_due_by | eq, gte, lte | datetime |
| group_id | eq, gte, lte | number |
| priority | eq, gte, lte | number |
| status | eq, gte, lte | number |
| tag | eq | string |
| type | eq | string |
| updated_at | eq, gte, lte | datetime |


### Jira Service Management Configuration 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 Operations Cloud 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 |


### Test Provider 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 |


### Zendesk filters for `query_tickets`

| Field | Operators | Supported Values |
|  --- | --- | --- |
| description | eq, ne, like | string |
| id | eq, ne, like | string |
| name | eq, ne, like | string |
| priority | eq, ne | string |
| status | eq, ne | string |