Tables and fields available for Export in 'BI Exporter for Jira | Free'

Owned by theCode4
Last updated: Sept 25, 2024
3 min read

The FREE version of the BI Exporter for Jira app is designed to support only the standard fields available in Jira Work Management.

mark-gradient-blue-jira-work-management.png Jira Work Management

  • 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

  • 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

  • Version Id INT

  • Issue Id INT

  • Issue Key VARCHAR

  • Archived BOOLEAN

  • Name VARCHAR

  • Description VARCHAR

  • Release Date DATE

  • Released BOOLEAN

  • 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

  • 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

  • Id INT

  • Name VARCHAR

  • Description VARCHAR

  • Icon URL VARCHAR

  • Status Category Id INT

  • Status Category Name VARCHAR

  • Link Type Id INT

  • Name VARCHAR

  • Inward VARCHAR

  • Outward VARCHAR

  • Id INT

  • Name VARCHAR

  • Description VARCHAR

  • Is Default BOOLEAN

  • 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

  • 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

  • Issue Id INT

  • Issue Key VARCHAR

  • Label VARCHAR

  • Issue Id INT

  • Issue Key VARCHAR

  • Component Id INT

  • Component Name VARCHAR

  • Project Category Id INT

  • Name VARCHAR

  • Description VARCHAR

  • Account Id VARCHAR

  • Account Type VARCHAR

  • Name VARCHAR

  • Email Address VARCHAR

  • Is Active BOOLEAN

  • Locale VARCHAR

  • Time Zone VARCHAR

  • Id INT

  • Key VARCHAR

  • Name VARCHAR

  • Color Name VARCHAR

  • 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

  • Version Id INT

  • Issue Id INT

  • Issue Key VARCHAR

  • Archived BOOLEAN

  • Name VARCHAR

  • Description VARCHAR

  • Release Date DATE

  • Released BOOLEAN

  • 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

  • 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 Id VARCHAR

  • Group Name VARCHAR

  • MemberAccount Id VARCHAR

  • MemberName VARCHAR

  • MemberIs Active BOOLEAN

  • MemberAccount Type VARCHAR

  • MemberTime Zone VARCHAR

  • 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

  • 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, PRO or Xray 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!