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 20
Next »
Jira Work Management
Issues
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
IssueEffortTime Spent DOUBLE
IssueEffortTime Spent With Sub-Tasks DOUBLE
IssueEffortOriginal Estimate DOUBLE
IssueEffortOriginal Estimate With Sub-Tasks DOUBLE
IssueEffortRemaining Estimate DOUBLE
IssueEffortRemaining Estimate With Sub-Tasks DOUBLE
AssigneeAccount Id VARCHAR
AssigneeName VARCHAR
AssigneeIs Active BOOLEAN
AssigneeAccount Type VARCHAR
AssigneeTime Zone VARCHAR
CreatorAccount Id VARCHAR
CreatorName VARCHAR
CreatorIs Active BOOLEAN
CreatorAccount Type VARCHAR
CreatorTime Zone VARCHAR
ReporterAccount Id VARCHAR
ReporterName VARCHAR
ReporterIs Active BOOLEAN
ReporterAccount Type VARCHAR
ReporterTime Zone VARCHAR
ProjectId INT
ProjectKey VARCHAR
ProjectName VARCHAR
ProjectType Key VARCHAR
ProjectIs Simplified BOOLEAN
IssueTypeId INT
IssueTypeName VARCHAR
IssueTypeDescription VARCHAR
IssueTypeHierarchy Level INT
IssueStatusId INT
IssueStatusName VARCHAR
IssueStatusDescription VARCHAR
ResolutionId INT
ResolutionName VARCHAR
ResolutionDescription VARCHAR
ParentIssueIssue Id INT
ParentIssueIssue Key VARCHAR
ParentIssueSummary VARCHAR
ParentIssuePriority Id INT
ParentIssuePriority Name VARCHAR
ParentIssueStatus Id INT
ParentIssueStatus Name VARCHAR
ParentIssueStatus Category Name VARCHAR
ParentIssueIssue Type Id INT
ParentIssueIssue Type Name VARCHAR
Affects Versions
Version Id INT
Issue Id INT
Issue Key VARCHAR
Archived BOOLEAN
Name VARCHAR
Description VARCHAR
Release Date DATE
Released BOOLEAN
Projects
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
ProjectCategoryId INT
ProjectCategoryName VARCHAR
ProjectCategoryDescription VARCHAR
LeadAccount Id VARCHAR
LeadName VARCHAR
LeadIs Active BOOLEAN
Project Components
Component Id INT
Name VARCHAR
Description VARCHAR
Assignee Type VARCHAR
Is Assignee Type Valid BOOLEAN
ProjectId INT
ProjectKey VARCHAR
ProjectIs Archived BOOLEAN
ProjectName VARCHAR
ProjectDescription VARCHAR
ProjectType Key VARCHAR
LeadAccount Id VARCHAR
LeadName VARCHAR
LeadIs Active BOOLEAN
AssigneeAccount Id VARCHAR
AssigneeName VARCHAR
AssigneeIs Active BOOLEAN
Issue Link Types
Link Type Id INT
Name VARCHAR
Inward VARCHAR
Outward VARCHAR
Resolutions
Id INT
Name VARCHAR
Description VARCHAR
Is Default BOOLEAN
Worklogs
Worklog Id INT
Issue Id INT
Comment VARCHAR
Created DATE
Updated DATE
Started DATE
Time Spent Seconds INT
Time Spent VARCHAR
AuthorAccount Id VARCHAR
AuthorName VARCHAR
AuthorIs Active BOOLEAN
AuthorAccount Type VARCHAR
AuthorTime Zone VARCHAR
UpdateAuthorAccount Id VARCHAR
UpdateAuthorName VARCHAR
UpdateAuthorIs Active BOOLEAN
UpdateAuthorAccount Type VARCHAR
UpdateAuthorTime Zone VARCHAR
Labels
Issue Id INT
Issue Key VARCHAR
Label VARCHAR
Issue Components
Issue Id INT
Issue Key VARCHAR
Component Id INT
Component Name VARCHAR
Project Categories
Project Category Id INT
Name VARCHAR
Description VARCHAR
Users
Account Id VARCHAR
Account Type VARCHAR
Name VARCHAR
Email Address VARCHAR
Is Active BOOLEAN
Locale VARCHAR
Time Zone VARCHAR
Status Categories
Id INT
Key VARCHAR
Name VARCHAR
Color Name VARCHAR
Comments
Comment Id INT
Issue Id INT
issue key VARCHAR
Body VARCHAR
Created DATE
Updated DATE
AuthorAccount Id VARCHAR
AuthorName VARCHAR
AuthorIs Active BOOLEAN
AuthorAccount Type VARCHAR
AuthorTime Zone VARCHAR
UpdateAuthorAccount Id VARCHAR
UpdateAuthorName VARCHAR
UpdateAuthorIs Active BOOLEAN
UpdateAuthorAccount Type VARCHAR
UpdateAuthorTime Zone VARCHAR
Fix Versions
Version Id INT
Issue Id INT
Issue Key VARCHAR
Archived BOOLEAN
Name VARCHAR
Description VARCHAR
Release Date DATE
Released BOOLEAN
Priorities
Priority Id INT
Name VARCHAR
Description VARCHAR
Icon Url VARCHAR
Status Color VARCHAR
Is Default BOOLEAN
Struggling to locate the field you're looking for? It might be included in the PRO version. Take a look!
If you've had the chance to use the Data Processor for Jira - Multi BI Connector and Advanced Exporter app, we'd love to hear your thoughts. Help us improve by sharing your honest review of the Free and PRO versions. Your feedback is crucial as we strive to improve and tailor our services to better meet your needs. 🤝
Still have questions? Feel free to reach out to us for any additional information or to request new features!