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. If a provider or operation does not support filters, it will not be listed here.

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
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
tags	eq, neq, in, not in	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

Azure DevOps Boards filters for `query_tickets`

Field	Operators	Supported Values
assignee	eq, ne, in, not in	string
completion_date	eq, ne, gt, gte, lt, lte	datetime
created_at	eq, ne, gt, gte, lt, lte	datetime
creator	eq, ne, in	string
description	like, not like	string
due_date	eq, ne, gt, gte, lt, lte	datetime
id	eq, ne, in, not in	string
issue_type	eq, ne, in	string
name	eq, ne, like, not like	string
priority	eq, ne, in, not in	HIGH, MEDIUM, LOW, CRITICAL
project	eq, in	string
raw_data.*	eq, ne, gt, gte, lt, lte, like, not like, in, not in	string
status	eq, ne, in	string
summary	eq, ne, like, not like	string
tags	eq, ne, in, not in	string
updated_at	eq, ne, gt, gte, lt, lte	datetime

BMC Helix ITSM filters for `query_tickets`

Field	Operators	Supported Values
assignee	eq, ne, in, not_in, like	string
contact	eq, ne, in, not_in	string
created_at	eq, ne, gt, gte, lt, lte	datetime
description	eq, ne, in, not_in, like	string
id	eq, ne, in, not_in	string
name	eq, ne, in, not_in, like	string
priority	eq, ne, in, not_in	CRITICAL, HIGH, MEDIUM, LOW
status	eq, in, not_in	CLOSED, OPEN, RESOLVED
summary	eq, ne, in, not_in, like	string
updated_at	eq, ne, gt, lt	datetime

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

GitHub Issues filters for `query_tickets`

Field	Operators	Supported Values
assignee	eq	string
creator	eq	string
raw_data.*	eq	string
status	eq, ne	OPEN, CLOSED
tags	eq	string
updated_at	gte	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

Linear filters for `query_tickets`

Field	Operators	Supported Values
assignee	eq, ne, in, not_in	string
completion_date	eq, ne, gt, gte, lt, lte	datetime
created_at	eq, ne, gt, gte, lt, lte	datetime
creator	eq, ne, in, not_in	string
description	like, not_like	string
due_date	eq, ne, gt, gte, lt, lte	datetime
id	eq, ne, in, not_in	string
name	eq, ne, like, not_like, in, not_in	string
priority	eq, ne, in, not_in, gt, gte, lt, lte	URGENT, HIGH, MEDIUM, LOW
project	eq, ne, in, not_in	string
status	eq, ne, in, not_in	string
summary	eq, ne, like, not_like, in, not_in	string
tags	eq, ne, in, not_in	string
text	like, not_like	string
updated_at	eq, ne, gt, gte, lt, lte	datetime

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

Xurrent filters for `query_tickets`

Field	Operators	Supported Values
assignee	eq, ne	string
completion_date	eq, ne, gt, gte, lt, lte	datetime
created_at	eq, ne, gt, gte, lt, lte	datetime
creator	eq, ne	string
due_date	eq, ne, gt, gte, lt, lte	datetime
id	eq, ne, in, not_in	string
issue_type	eq, ne, in, not_in	rfc, incident, service_request
name	eq, ne, like, not_like	string
priority	eq, ne, in, not_in	HIGH, MEDIUM, LOW, URGENT, CRITICAL
project	eq, ne	string
status	eq, ne, in, not_in	IN_PROGRESS, OPEN, ON_HOLD
summary	eq, ne, like, not_like	string
tags	eq, ne, in, not_in	string
updated_at	eq, ne, gt, gte, lt, lte	datetime

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

Ticketing Query Filters

Atlassian Jira filters for query_tickets

Autotask Operations Cloud filters for query_tickets

Azure DevOps Boards filters for query_tickets

BMC Helix ITSM filters for query_tickets

Freshdesk filters for query_tickets

GitHub Issues filters for query_tickets

Jira Service Management Configuration filters for query_tickets

Linear filters for query_tickets

ServiceNow ITSM filters for query_tickets

ServiceNow SIR filters for query_tickets

Test Provider filters for query_tickets

Torq filters for query_tickets

Xurrent filters for query_tickets

Zendesk filters for query_tickets

Was this helpful?