Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

JIRA Cloud API Data Model

Navigation: Schema: Views > Views

Issues: JIRA Cloud Issues

Contents Previous Home Next More

Catalog: JIRA

Schema: Views

Label: Issues

This is a read-only view. The JIRA Cloud API may not support changing the data or the Invantive SQL driver for JIRA Cloud does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the JIRA Cloud API.

View Columns

The columns of the view Issues are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

aggregatetimeestimate

decimal

 

Aggregate time estimate.

aggregatetimeoriginalestimate

decimal

 

Aggregate time original estimate.

aggregatetimespent

decimal

 

Aggregate time spent.

assignee_accountId

string

 

The account ID of the user, which uniquely identifies the user across all Atlassian products. For example, 5b10ac8d82e05b22cc7d4ef5. Required in requests. An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users. We recommend you treat this value as an error case if you need to access more information about the user.

assignee_accountType

string

 

The user account type. Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk

assignee_active

boolean

 

Indicates whether the user is active.

assignee_displayName

string

 

The display name of the user. Depending on the user’s privacy setting, this may return an alternative value.

assignee_emailAddress

string

 

The email address of the user. Depending on the user’s privacy setting, this may be returned as null.

assignee_key

string

 

This property is no longer available and will be removed from the documentation soon

assignee_locale

string

 

The locale of the user. Depending on the user’s privacy setting, this may be returned as null.

assignee_name

string

 

This property is no longer available and will be removed from the documentation soon.

assignee_timeZone

string

 

The time zone specified in the user's profile. Depending on the user’s privacy setting, this may be returned as null.

created

datetime

 

Creation date.

creator_accountId

string

 

The account ID of the user, which uniquely identifies the user across all Atlassian products. For example, 5b10ac8d82e05b22cc7d4ef5. Required in requests. An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users. We recommend you treat this value as an error case if you need to access more information about the user.

creator_accountType

string

 

The user account type. Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk

creator_active

boolean

 

Indicates whether the user is active.

creator_displayName

string

 

The display name of the user. Depending on the user’s privacy setting, this may return an alternative value.

creator_emailAddress

string

 

The email address of the user. Depending on the user’s privacy setting, this may be returned as null.

creator_key

string

 

This property is no longer available and will be removed from the documentation soon

creator_locale

string

 

The locale of the user. Depending on the user’s privacy setting, this may be returned as null.

creator_name

string

 

This property is no longer available and will be removed from the documentation soon.

creator_timeZone

string

 

The time zone specified in the user's profile. Depending on the user’s privacy setting, this may be returned as null.

description

string

 

Description.

descriptiontype

string

 

Description type.

descriptionversion

string

 

Description version.

duedate

datetime

 

Due date.

environment

string

 

Environment.

hasvoted

boolean

 

Whether the user has voted.

id

int64

 

ID.

issuetypehierarchylevel

int16

 

Issue type hierarchy level.

issuetypeid

string

 

Issue type ID.

issuetypename

string

 

Issue type name.

issuetypesubtask

boolean

 

Issue type sub-task.

key

string

 

Key.

labels

string

 

Labels.

lastViewed

datetime

 

Last viewed.

organizationname0

string

 

First organization name.

pjt_description

string

 

A brief description of the project.

pjt_email

string

 

An email address associated with the project.

pjt_favourite

boolean

 

Whether the project is selected as a favorite.

pjt_id

int64

 

The ID of the project.

pjt_isPrivate

boolean

 

Whether the project is private.

pjt_key

string

 

The key of the project.

pjt_lead_accountId

string

 

The account ID of the user, which uniquely identifies the user across all Atlassian products. For example, 5b10ac8d82e05b22cc7d4ef5. Required in requests. An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users. We recommend you treat this value as an error case if you need to access more information about the user.

pjt_lead_accountType

string

 

The user account type. Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk

pjt_lead_active

boolean

 

Indicates whether the user is active.

pjt_lead_displayName

string

 

The display name of the user. Depending on the user’s privacy setting, this may return an alternative value.

pjt_lead_emailAddress

string

 

The email address of the user. Depending on the user’s privacy setting, this may be returned as null.

pjt_lead_key

string

 

This property is no longer available and will be removed from the documentation soon

pjt_lead_locale

string

 

The locale of the user. Depending on the user’s privacy setting, this may be returned as null.

pjt_lead_name

string

 

This property is no longer available and will be removed from the documentation soon.

pjt_lead_timeZone

string

 

The time zone specified in the user's profile. Depending on the user’s privacy setting, this may be returned as null.

pjt_name

string

 

The name of the project.

pjt_permissions_canEdit

boolean

 

Indicates whether the logged user can edit the project.

pjt_projectTypeKey

string

 

The project type of the project.

pjt_self

string

 

The URL of the project details.

pjt_simplified

boolean

 

Whether the project is simplified.

pjt_style

string

 

The type of the project.

pjt_url

string

 

A link to information about this project, such as project documentation.

pjt_uuid

string

 

Unique ID for next-gen projects.

priorityname

string

 

Priority name.

progresscurrent

decimal

 

Progress.

progresstotal

decimal

 

Total progress.

projectid

int64

 

Project ID.

projectkey

string

 

Project key.

projectname

string

 

Project name.

projectsimplified

boolean

 

Project is simplified.

projecttypekey

string

 

Project type key.

reporter_accountId

string

 

The account ID of the user, which uniquely identifies the user across all Atlassian products. For example, 5b10ac8d82e05b22cc7d4ef5. Required in requests. An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users. We recommend you treat this value as an error case if you need to access more information about the user.

reporter_accountType

string

 

The user account type. Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk

reporter_active

boolean

 

Indicates whether the user is active.

reporter_displayName

string

 

The display name of the user. Depending on the user’s privacy setting, this may return an alternative value.

reporter_emailAddress

string

 

The email address of the user. Depending on the user’s privacy setting, this may be returned as null.

reporter_key

string

 

This property is no longer available and will be removed from the documentation soon

reporter_locale

string

 

The locale of the user. Depending on the user’s privacy setting, this may be returned as null.

reporter_name

string

 

This property is no longer available and will be removed from the documentation soon.

reporter_timeZone

string

 

The time zone specified in the user's profile. Depending on the user’s privacy setting, this may be returned as null.

requesttypedescription

string

 

Request type description.

requesttypename

string

 

Request type name.

resolutiondate

datetime

 

Resolution date.

resolutionname

string

 

Resolution name.

status_description

string

 

Description.

status_iconUrl

string

 

Icon URL.

status_id

string

 

ID.

status_name

string

 

Name.

status_statusCategory_colorName

string

 

Name of color.

status_statusCategory_id

string

 

ID.

status_statusCategory_key

string

 

Key.

status_statusCategory_name

string

 

Name.

statuscategorychangedate

datetime

 

Status category change date.

summary

string

 

Summary.

timeestimate

decimal

 

Time estimate.

timeoriginalestimate

decimal

 

Time original estimate.

timespent

decimal

 

Time spent.

updated

datetime

 

Updated.

votes

int32

 

Number of votes.

workratio

decimal

 

Work ratio.

 

29-09-2021 12:42 Version 20.2.43-PROD+3437