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

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

The PRO version of the BI Exporter for Jira app is designed to support any Jira field, including custom fields, Jira Software, Jira Service Management, Assets, and Advanced Roadmaps.

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

  • Issue IdINT

  • KeyVARCHAR

  • SummaryVARCHAR

  • DescriptionVARCHAR

  • CreatedDATE

  • UpdatedDATE

  • Due DateDATE

  • Last ViewedDATE

  • Resolution DateDATE

  • Priority IdINT

  • Priority NameVARCHAR

  • Is WatchingBOOLEAN

  • Watch CountINT

  • EnvironmentVARCHAR

  • Work RatioDOUBLE

  • VotesINT

  • Status Changed DateDATE

  • Is SubtaskBOOLEAN

  • Number Of SubtasksINT

  • IssueEffortTime SpentDOUBLE

  • IssueEffortTime Spent With Sub-TasksDOUBLE

  • IssueEffortOriginal EstimateDOUBLE

  • IssueEffortOriginal Estimate With Sub-TasksDOUBLE

  • IssueEffortRemaining EstimateDOUBLE

  • IssueEffortRemaining Estimate With Sub-TasksDOUBLE

  • AssigneeAccount IdVARCHAR

  • AssigneeNameVARCHAR

  • AssigneeIs ActiveBOOLEAN

  • AssigneeAccount TypeVARCHAR

  • AssigneeTime ZoneVARCHAR

  • CreatorAccount IdVARCHAR

  • CreatorNameVARCHAR

  • CreatorIs ActiveBOOLEAN

  • CreatorAccount TypeVARCHAR

  • CreatorTime ZoneVARCHAR

  • ReporterAccount IdVARCHAR

  • ReporterNameVARCHAR

  • ReporterIs ActiveBOOLEAN

  • ReporterAccount TypeVARCHAR

  • ReporterTime ZoneVARCHAR

  • ProjectIdINT

  • ProjectKeyVARCHAR

  • ProjectNameVARCHAR

  • ProjectType KeyVARCHAR

  • ProjectIs SimplifiedBOOLEAN

  • IssueTypeIdINT

  • IssueTypeNameVARCHAR

  • IssueTypeDescriptionVARCHAR

  • IssueTypeHierarchy LevelINT

  • IssueStatusIdINT

  • IssueStatusNameVARCHAR

  • IssueStatusDescriptionVARCHAR

  • ResolutionIdINT

  • ResolutionNameVARCHAR

  • ResolutionDescriptionVARCHAR

  • ParentIssueIssue IdINT

  • ParentIssueIssue KeyVARCHAR

  • ParentIssueSummaryVARCHAR

  • ParentIssuePriority IdINT

  • ParentIssuePriority NameVARCHAR

  • ParentIssueStatus IdINT

  • ParentIssueStatus NameVARCHAR

  • ParentIssueStatus Category NameVARCHAR

  • ParentIssueIssue Type IdINT

  • ParentIssueIssue Type NameVARCHAR

  • Issue IdINT

  • Issue KeyVARCHAR

  • Field IdVARCHAR

  • FieldVARCHAR

  • Field ValueVARCHAR

  • Field Value StringVARCHAR

  • Number Of Times In Field ValueINT

  • PercentageDOUBLE

  • Total time in Field Value (sec.)INT

  • Total time in Field Value (min.)DOUBLE

  • Total time in Field Value (hr.)DOUBLE

  • Attachment IdINT

  • Issue IdINT

  • Issue KeyVARCHAR

  • File NameVARCHAR

  • SizeINT

  • Mime TypeVARCHAR

  • CreatedDATE

  • AuthorAccount IdVARCHAR

  • AuthorNameVARCHAR

  • AuthorIs ActiveBOOLEAN

  • AuthorAccount TypeVARCHAR

  • AuthorTime ZoneVARCHAR

  • Version IdINT

  • Issue IdINT

  • Issue KeyVARCHAR

  • ArchivedBOOLEAN

  • NameVARCHAR

  • DescriptionVARCHAR

  • Release DateDATE

  • ReleasedBOOLEAN

  • Project IdINT

  • KeyVARCHAR

  • NameVARCHAR

  • DescriptionVARCHAR

  • Type KeyVARCHAR

  • StyleVARCHAR

  • Is SimplifiedBOOLEAN

  • Is ArchivedBOOLEAN

  • Archived DateDATE

  • Is DeletedBOOLEAN

  • Deleted DateDATE

  • Is PrivateBOOLEAN

  • Total Issue CountINT

  • Last Issue Update TimeDATE

  • ProjectCategoryIdINT

  • ProjectCategoryNameVARCHAR

  • ProjectCategoryDescriptionVARCHAR

  • LeadAccount IdVARCHAR

  • LeadNameVARCHAR

  • LeadIs ActiveBOOLEAN

mark-gradient-blue-jira-software.png Jira Software

 

jira-service-management-mark-gradient-blue.png Jira Service Management

mark-gradient-blue-jira-software.png Advanced Roadmaps (coming soon)

 

jira-service-management-mark-gradient-blue.png Assets

 

 

Can't locate the table or column you require? Suggest a new feature in our Help Center!

 

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.