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.