Tables and fields available for Export in 'BI Exporter for Jira | Free'
The FREE version of the BI Exporter for Jira app is designed to support only the standard fields available in Jira Work Management.
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
Attachments
Attachment Id INT
Issue Id INT
Issue Key VARCHAR
File Name VARCHAR
Size INT
Mime Type VARCHAR
Created DATE
AuthorAccount Id VARCHAR
AuthorName VARCHAR
AuthorIs Active BOOLEAN
AuthorAccount Type VARCHAR
AuthorTime Zone 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 Statuses
Id INT
Name VARCHAR
Description VARCHAR
Icon URL VARCHAR
Status Category Id INT
Status Category Name VARCHAR
Issue Link Types
Link Type Id INT
Name VARCHAR
Inward VARCHAR
Outward VARCHAR
Resolutions
Id INT
Name VARCHAR
Description VARCHAR
Is Default BOOLEAN
Changelogs (Histories)
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
AuthorAccount Id VARCHAR
AuthorName VARCHAR
AuthorIs Active BOOLEAN
AuthorAccount Type VARCHAR
AuthorTime Zone VARCHAR
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
Issue Links
Issue Id INT
Issue Key VARCHAR
Issue Link Id INT
Issue Link Key VARCHAR
Link Type Id INT
Link Type Name VARCHAR
Link Relationship VARCHAR
Project Versions
Version Id INT
Archived BOOLEAN
Name VARCHAR
Description VARCHAR
Release Date DATE
Start Date DATE
Released BOOLEAN
Overdue BOOLEAN
ProjectId INT
ProjectKey VARCHAR
ProjectIs Archived BOOLEAN
ProjectName VARCHAR
ProjectDescription VARCHAR
ProjectType Key VARCHAR
Group Members
Group Id VARCHAR
Group Name VARCHAR
MemberAccount Id VARCHAR
MemberName VARCHAR
MemberIs Active BOOLEAN
MemberAccount Type VARCHAR
MemberTime Zone VARCHAR
Issue Types
Id INT
Name VARCHAR
Untranslated Name VARCHAR
Description VARCHAR
Hierarchy Level INT
Is Subtask BOOLEAN
Icon Url VARCHAR
Avatar Id INT
Scope Type VARCHAR
Scope Project Id INT
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 BI Exporter for Jira app, we'd love to hear your thoughts. Help us improve by sharing your honest review of the Free, PRO, Xray or Projectrak 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!
Last updated