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

Owned by theCode4
Last updated: Sept 25, 2024
4 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

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.