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