Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 13 Next »

The FREE version of the Data Processor for Jira app is designed to support only the standard fields available in Jira Work Management. Stay tuned for the PRO version with the advanced selection of Jira data.

Tables

Fields

Issues

Issues_available.png

  • Issue Id INT

  • Key VARCHAR

  • Summary VARCHAR

  • Description VARCHAR

  • Created DATE

  • Updated DATE

  • Due Date DATE

  • Last Viewed DATE

  • Resolution Date DATE

  • Priority Id INT

  • Priority Name VARCHAR

  • Is Watching BOOLEAN

  • Watch Count INT

  • Environment VARCHAR

  • Work Ratio DOUBLE

  • Votes INT

  • Status Changed Date DATE

  • Is Subtask BOOLEAN

  • Number Of Subtasks INT

Changelogs (Histories)

changelogs_available.png

  • History Id INT

  • Issue Id INT

  • Issue Key VARCHAR

  • Created DATE

  • Field Id VARCHAR

  • Field VARCHAR

  • Field Type VARCHAR

  • From VARCHAR

  • From String VARCHAR

  • To VARCHAR

  • To String VARCHAR

Worklogs

worklogs_available.png

  • Worklog Id INT

  • Issue Id INT

  • Comment VARCHAR

  • Created DATE

  • Updated DATE

  • Started DATE

  • Time Spent Seconds INT

  • Time Spent VARCHAR

Comments

comments_available.png

  • Comment Id INT

  • Issue Id INT

  • issue key VARCHAR

  • Body VARCHAR

  • Created DATE

  • Updated DATE

Attachments

attachments_available.png

  • Attachment Id INT

  • Issue Id INT

  • Issue Key VARCHAR

  • File Name VARCHAR

  • Size INT

  • Mime Type VARCHAR

  • Created DATE

Labels

labels_available.png

  • Issue Id INT

  • Issue Key VARCHAR

  • Label VARCHAR

Fix Versions

fix versions_available.png

  • Version Id INT

  • Issue Id INT

  • Issue Key VARCHAR

  • Archived BOOLEAN

  • Name VARCHAR

  • Description VARCHAR

  • Release Date DATE

  • Released BOOLEAN

Affects Versions

affects versions_available.png

  • Version Id INT

  • Issue Id INT

  • Issue Key VARCHAR

  • Archived BOOLEAN

  • Name VARCHAR

  • Description VARCHAR

  • Release Date DATE

  • Released BOOLEAN

Issue Components

Issue components_available.png

  • Issue Id INT

  • Issue Key VARCHAR

  • Component Id INT

  • Component Name VARCHAR

Issue links_available.png

  • Issue Id INT

  • Issue Key VARCHAR

  • Issue Link Id INT

  • Issue Link Key VARCHAR

  • Link Type Id INT

  • Link Type Name VARCHAR

  • Link Inward VARCHAR

  • Link Outward VARCHAR

Projects

projects_available.png

  • Project Id INT

  • Key VARCHAR

  • Name VARCHAR

  • Description VARCHAR

  • Type Key VARCHAR

  • Style VARCHAR

  • Is Simplified BOOLEAN

  • Is Archived BOOLEAN

  • Archived Date DATE

  • Is Deleted BOOLEAN

  • Deleted Date DATE

  • Is Private BOOLEAN

  • Total Issue Count INT

  • Last Issue Update Time DATE

Project Categories

project categories_available.png

  • Project Category Id INT

  • Name VARCHAR

  • Description VARCHAR

Project Versions

projects versions_available.png

  • Version Id INT

  • Archived BOOLEAN

  • Name VARCHAR

  • Description VARCHAR

  • Release Date DATE

  • Start Date DATE

  • Released BOOLEAN

  • Overdue BOOLEAN

Project Components

project components_available.png

  • Component Id INT

  • Name VARCHAR

  • Description VARCHAR

  • Assignee Type VARCHAR

  • Is Assignee Type Valid BOOLEAN

Users

users_available.png

  • Account Id VARCHAR

  • Account Type VARCHAR

  • Name VARCHAR

  • Email Address VARCHAR

  • Is Active BOOLEAN

  • Locale VARCHAR

  • Time Zone VARCHAR

Group Members

group members_available.png

  • Group Id VARCHAR

  • Group Name VARCHAR

Issue Statuses

Issue statuses_available.png

  • Id INT

  • Name VARCHAR

  • Description VARCHAR

  • Icon URL VARCHAR

  • Status Category Id INT

  • Status Category Name VARCHAR

Status Categories

status categories_available.png

  • Id INT

  • Key VARCHAR

  • Name VARCHAR

  • Color Name VARCHAR

Issue Types

Issue types_available.png

  • Id INT

  • Name VARCHAR

  • Untranslated Name VARCHAR

  • Description VARCHAR

  • Is Subtask BOOLEAN

  • Icon URL VARCHAR

  • Avatar Id INT

  • Scope Type VARCHAR

  • Scope Project Id INT

  • Hierarchy Level INT

Issue Link Types

issue link types_available.png

  • Link Type Id INT

  • Name VARCHAR

  • Inward VARCHAR

  • Outward VARCHAR

Resolutions

resolutions_available.png

  • d INT

  • Name VARCHAR

  • Description VARCHAR

  • Is Default BOOLEAN

Priorities

priorities_available.png

  • Priority Id INT

  • Name VARCHAR

  • Description VARCHAR

  • Icon Url VARCHAR

  • Status Color VARCHAR

  • Is Default BOOLEAN


  • No labels