Issues
Columns
Name
Type
ReadOnly
References
SupportedOperators
Platform
Description
Id [KEY]
Int
True
=,!=,>,>=,<,<=,IN,NOT IN
Common
The Id of the issue.
Key
String
True
=,!=,>,>=,<,<=,IN,NOT IN
Common
The key of the issue.
IssueTypeId
String
False
=,!=,IS,IS NOT,IN,NOT IN
Common
The issue type Id.
IssueTypeName
String
True
=,!=,IS,IS NOT,IN,NOT IN
Common
The issue type name.
ProjectId
String
False
=,!=,IS,IS NOT,IN,NOT IN
Common
The project Id of the issue.
ProjectName
String
True
=,!=,IS,IS NOT,IN,NOT IN
Common
The project name of the issue.
ProjectKey
String
False
=,!=,IS,IS NOT,IN,NOT IN
Common
The project key of the issue.
ParentId
Int
False
=,!=,IN,NOT IN
Common
The Id of the issue's parent if the issue is a subtask.
ParentKey
String
True
=,!=,IN,NOT IN
Common
The key of the issue's parent if the issue is a subtask.
ResolutionId
String
True
=,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN
Common
The resolution Id of the issue.
ResolutionName
String
True
=,!=,IS,IS NOT,IN,NOT IN
Common
The resolution name of the issue.
ResolutionDescription
String
True
Common
The resolution description of the issue.
ResolutionDate
Datetime
True
=,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN
Common
The resolution date of the issue.
Workratio
Long
True
=,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN
Common
The work ratio of the issue.
LastViewed
Datetime
True
=,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN
Common
The last time that the issue was viewed.
WatchCount
Int
True
=,!=,>,>=,<,<=,IN,NOT IN
Common
The number of watches of the issue.
IsWatching
Bool
True
Common
Whether the currently authenticated user is watching the issue.
Created
Datetime
True
=,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN
Common
The creation date of the issue.
PriorityId
String
False
=,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN
Common
The priority Id of the issue.
PriorityName
String
True
=,!=,IS,IS NOT,IN,NOT IN
Common
The priority name of the issue.
TimeSpentSeconds
Long
True
Common
The time spent in seconds on the issue.
TimeSpent
String
True
=,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN
Common
The time spent on the issue.
RemainingEstimateSeconds
Long
True
Common
The time estimate in seconds of the issue.
RemainingEstimate
String
False
=,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN
Common
The time estimate of the issue.
OriginalEstimateSeconds
Long
True
Common
The original time estimate in seconds of the issue.
OriginalEstimate
String
False
=,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN
Common
The original time estimate of the issue.
AggregateTimeSpent
Long
True
Common
The aggregate time spent of the issue.
AggregateTimeOriginalEstimate
Long
True
Common
The original aggregate time estimate of the issue.
AggregateTimeEstimate
Long
True
Common
The aggregate time estimate of the issue.
AssigneeDisplayName
String
True
Common
Assignee display name.
AssigneeKey
String
True
=,!=,IS,IS NOT,IN,NOT IN
Common
[DEPRECATED] The assignee key of the issue.
AssigneeAccountId
String
False
=,!=,IS,IS NOT,IN,NOT IN
Common
The assignee account id.
AssigneeName
String
False
=,!=,IS,IS NOT,IN,NOT IN
Common
The assignee name of the issue.
AssigneeEmail
String
True
=,!=,IS,IS NOT,IN,NOT IN
Common
The assignee email of the issue.
Updated
Datetime
True
=,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN
Common
The updated date of the issue.
StatusId
String
True
=,!=,IS,IS NOT,IN,NOT IN
Common
The status Id of the issue.
StatusName
String
True
=,!=,IS,IS NOT,IN,NOT IN
Common
The status name of the issue.
Description
String
False
IS,IS NOT
Common
The description of the issue.
Summary
String
False
IS,IS NOT
Common
The summary of the issue.
CreatorDisplayName
String
True
Common
Issue creator display name.
CreatorName
String
True
=,!=,IS,IS NOT,IN,NOT IN
Common
The creator name of the issue.
CreatorAccountId
String
True
=,!=,IS,IS NOT,IN,NOT IN
Common
The creator account id.
CreatorKey
String
True
=,!=,IS,IS NOT,IN,NOT IN
Common
[DEPRECATED] The creator key of the issue.
CreatorEmail
String
True
=,!=,IS,IS NOT,IN,NOT IN
Common
The creator email of the issue.
ReporterDisplayName
String
True
Common
Issue reporter display name.
ReporterName
String
False
=,!=,IS,IS NOT,IN,NOT IN
Common
The reporter name of the issue.
ReporterKey
String
True
=,!=,IS,IS NOT,IN,NOT IN
Common
[DEPRECATED]The reporter key of the issue.
ReporterAccountId
String
True
=,!=,IS,IS NOT,IN,NOT IN
Common
The reporter account id.
ReporterEmail
String
True
=,!=,IS,IS NOT,IN,NOT IN
Common
The reporter email of the issue.
AggregateProgress
Long
True
Common
The aggregate progress of the issue.
TotalProgress
Long
True
Common
The aggregate total progress of the issue.
Votes
Int
True
=,!=,>,>=,<,<=,IN,NOT IN
Common
Votes of the issue.
HasVotes
Bool
True
Common
The vote status of the issue.
DueDate
Date
False
=,!=,>,>=,<,<=,IS,IS NOT,IN,NOT IN
Common
The due date of the issue.
Labels
String
False
=,!=,IS,IS NOT,IN,NOT IN
Common
The labels of an issue.
Environment
String
False
LIKE,NOT LIKE,IS,IS NOT
Common
The environment of an issue.
SecurityLevel
String
False
=,!=,IS,IS NOT,IN, NOT IN
Common
The security level of an issue.
FixVersionsAggregate
String
False
Common
The fix versions of the issue
ComponentsAggregate
String
False
Common
Aggregate list of components included in the issue.
IssueLinksAggregate
String
False
Common
The issue links of the issue.
AffectedVersionsAggregate
String
False
Common
The affected versions of the issue.
SubtasksAggregate
String
True
Common
The subtasks of the issue.
CustomField1
Any
False
Common
A custom field created for the Issues. The custom fields will be listed if the 'IncludeCustomFields' connection property is set to true.
CustomField2
Any
False
Common
A custom field created for the Issues. The custom fields will be listed if the 'IncludeCustomFields' connection property is set to true.
Pseudo-Columns
Name
Type
Description
JQL
String
JQL (JIRA Query Language) allows you to build structured queries.
Attachments
String
Search for issues that have or do not have attachments. This column can be queried with IS EMPTY or IS NOT EMPTY.
Comment
String
Search for issues that have a comment that contains particular text.
Category
String
Search for issues that belong to projects in a particular category.
SprintId
Integer
Search for issues that belongs to a specific sprint, by specifying the Id of the Sprint.
SprintName
String
Search for issues that belongs to a specific sprint, by specifying the name of the Sprint.
Filter
String
Search for issues of saved filters. This column can be queried with filter name or filter id.
Last updated