Tables and fields available for Export in 'BI Exporter for Jira | PRO'
- theCode4
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.
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
Component IdINT
NameVARCHAR
DescriptionVARCHAR
Assignee TypeVARCHAR
Is Assignee Type ValidBOOLEAN
ProjectIdINT
ProjectKeyVARCHAR
ProjectIs ArchivedBOOLEAN
ProjectNameVARCHAR
ProjectDescriptionVARCHAR
ProjectType KeyVARCHAR
LeadAccount IdVARCHAR
LeadNameVARCHAR
LeadIs ActiveBOOLEAN
AssigneeAccount IdVARCHAR
AssigneeNameVARCHAR
AssigneeIs ActiveBOOLEAN
IdINT
NameVARCHAR
DescriptionVARCHAR
Icon URLVARCHAR
Status Category IdINT
Status Category NameVARCHAR
Link Type IdINT
NameVARCHAR
InwardVARCHAR
OutwardVARCHAR
CategoryVARCHAR
DesignVARCHAR
Checklist ProgressVARCHAR
Checklist Progress %INT
Checklist Text (view-only)VARCHAR
Checklist CompletedVARCHAR
Checklist Content YAMLVARCHAR
Checklist TextVARCHAR
Test planVARCHAR
SourceVARCHAR
Investigation reasonVARCHAR
Root causeVARCHAR
WorkaroundVARCHAR
Backout planVARCHAR
Pending reasonVARCHAR
Major incidentVARCHAR
SeverityVARCHAR
Affected hardwareVARCHAR
Planned startDATE
Planned endDATE
Implementation planVARCHAR
UrgencyVARCHAR
Total formsINT
Story PointsINT
Work categoryVARCHAR
Locked formsINT
Open formsINT
Submitted formsINT
[CHART] Date of First ResponseDATE
[CHART] Time in StatusVARCHAR
Start dateDATE
Change typeVARCHAR
Change riskVARCHAR
Change reasonVARCHAR
Actual startDATE
Actual endDATE
DevelopmentVARCHAR
ImpactVARCHAR
OperationalCategorization_customfield_10060Parent -> ChildVARCHAR
OperationalCategorization_customfield_10060ParentVARCHAR
OperationalCategorization_customfield_10060ChildVARCHAR
ProductCategorization_customfield_10059Parent -> ChildVARCHAR
ProductCategorization_customfield_10059ParentVARCHAR
ProductCategorization_customfield_10059ChildVARCHAR
History IdINT
Issue IdINT
Issue KeyVARCHAR
CreatedDATE
Field IdVARCHAR
FieldVARCHAR
Field TypeVARCHAR
FromVARCHAR
From StringVARCHAR
ToVARCHAR
To StringVARCHAR
AuthorAccount IdVARCHAR
AuthorNameVARCHAR
AuthorIs ActiveBOOLEAN
AuthorAccount TypeVARCHAR
AuthorTime ZoneVARCHAR
Worklog IdINT
Issue IdINT
CommentVARCHAR
CreatedDATE
UpdatedDATE
StartedDATE
Time Spent SecondsINT
Time SpentVARCHAR
AuthorAccount IdVARCHAR
AuthorNameVARCHAR
AuthorIs ActiveBOOLEAN
AuthorAccount TypeVARCHAR
AuthorTime ZoneVARCHAR
UpdateAuthorAccount IdVARCHAR
UpdateAuthorNameVARCHAR
UpdateAuthorIs ActiveBOOLEAN
UpdateAuthorAccount TypeVARCHAR
UpdateAuthorTime ZoneVARCHAR
Issue IdINT
Issue KeyVARCHAR
LabelVARCHAR
Issue IdINT
Issue KeyVARCHAR
Component IdINT
Component NameVARCHAR
Project Category IdINT
NameVARCHAR
DescriptionVARCHAR
Account IdVARCHAR
Account TypeVARCHAR
NameVARCHAR
Email AddressVARCHAR
Is ActiveBOOLEAN
LocaleVARCHAR
Time ZoneVARCHAR
IdINT
KeyVARCHAR
NameVARCHAR
Color NameVARCHAR
IdINT
NameVARCHAR
DescriptionVARCHAR
Is DefaultBOOLEAN
ApproverGroups_customfield_10040Issue IdINT
ApproverGroups_customfield_10040Issue KeyVARCHAR
ApproverGroups_customfield_10040IdVARCHAR
ApproverGroups_customfield_10040NameVARCHAR
Responders_customfield_10043Issue IdINT
Responders_customfield_10043Issue KeyVARCHAR
Responders_customfield_10043ValueVARCHAR
Flagged_customfield_10021Issue IdINT
Flagged_customfield_10021Issue KeyVARCHAR
Flagged_customfield_10021ValueVARCHAR
Approvers_customfield_10003Issue IdINT
Approvers_customfield_10003Issue KeyVARCHAR
Approvers_customfield_10003Account IdVARCHAR
Approvers_customfield_10003NameVARCHAR
Approvers_customfield_10003IsActiveBOOLEAN
Approvers_customfield_10003Time ZoneVARCHAR
Approvers_customfield_10003AccountTypeVARCHAR
Issue IdINT
Issue KeyVARCHAR
Changed AtDATE
Field IdVARCHAR
FieldVARCHAR
Old ValueVARCHAR
Old Value StringVARCHAR
New ValueVARCHAR
New Value StringVARCHAR
TimeIn Old Value (sec.)INT
TimeIn Old Value (min.)DOUBLE
TimeIn Old Value (hr.)DOUBLE
TimeIn New Value (sec.)INT
TimeIn New Value (min.)DOUBLE
TimeIn New Value (hr.)DOUBLE
EditorAccount IdVARCHAR
EditorNameVARCHAR
EditorIs ActiveBOOLEAN
EditorAccount TypeVARCHAR
EditorTime ZoneVARCHAR
Comment IdINT
Issue IdINT
issue keyVARCHAR
BodyVARCHAR
CreatedDATE
UpdatedDATE
AuthorAccount IdVARCHAR
AuthorNameVARCHAR
AuthorIs ActiveBOOLEAN
AuthorAccount TypeVARCHAR
AuthorTime ZoneVARCHAR
UpdateAuthorAccount IdVARCHAR
UpdateAuthorNameVARCHAR
UpdateAuthorIs ActiveBOOLEAN
UpdateAuthorAccount TypeVARCHAR
UpdateAuthorTime ZoneVARCHAR
Version IdINT
Issue IdINT
Issue KeyVARCHAR
ArchivedBOOLEAN
NameVARCHAR
DescriptionVARCHAR
Release DateDATE
ReleasedBOOLEAN
Issue IdINT
Issue KeyVARCHAR
Issue Link IdINT
Issue Link KeyVARCHAR
Link Type IdINT
Link Type NameVARCHAR
Link RelationshipVARCHAR
Version IdINT
ArchivedBOOLEAN
NameVARCHAR
DescriptionVARCHAR
Release DateDATE
Start DateDATE
ReleasedBOOLEAN
OverdueBOOLEAN
ProjectIdINT
ProjectKeyVARCHAR
ProjectIs ArchivedBOOLEAN
ProjectNameVARCHAR
ProjectDescriptionVARCHAR
ProjectType KeyVARCHAR
Group IdVARCHAR
Group NameVARCHAR
MemberAccount IdVARCHAR
MemberNameVARCHAR
MemberIs ActiveBOOLEAN
MemberAccount TypeVARCHAR
MemberTime ZoneVARCHAR
IdINT
NameVARCHAR
Untranslated NameVARCHAR
DescriptionVARCHAR
Hierarchy LevelINT
Is SubtaskBOOLEAN
Icon UrlVARCHAR
Avatar IdINT
Scope TypeVARCHAR
Scope Project IdINT
Priority IdINT
NameVARCHAR
DescriptionVARCHAR
Icon UrlVARCHAR
Status ColorVARCHAR
Is DefaultBOOLEAN
Jira Software
Board IdINT
NameVARCHAR
TypeVARCHAR
Location IdVARCHAR
Location NameVARCHAR
Estimation TypeVARCHAR
Estimation Field IdVARCHAR
Estimation Field NameVARCHAR
Board IdINT
Board NameVARCHAR
Project IdINT
Project KeyVARCHAR
NameVARCHAR
Type KeyVARCHAR
Is SimplifiedBOOLEAN
Sprint IdINT
NameVARCHAR
GoalVARCHAR
StateVARCHAR
Start DateDATE
End DateDATE
Complete DateDATE
Board IdINT
Board NameVARCHAR
Issue IdINT
Issue KeyVARCHAR
Board IdINT
Board NameVARCHAR
EpicEpic IdINT
EpicKeyVARCHAR
EpicNameVARCHAR
EpicSummaryVARCHAR
EpicColorVARCHAR
EpicIssue ColorVARCHAR
EpicIs DoneBOOLEAN
SprintSprint IdINT
SprintNameVARCHAR
SprintGoalVARCHAR
SprintStateVARCHAR
SprintStart DateDATE
SprintEnd DateDATE
SprintComplete DateDATE
Board IdINT
Board NameVARCHAR
Version IdINT
Project IdINT
ArchivedBOOLEAN
NameVARCHAR
DescriptionVARCHAR
ReleasedBOOLEAN
Issue IdINT
Issue KeyVARCHAR
Board IdINT
Board NameVARCHAR
EpicEpic IdINT
EpicKeyVARCHAR
EpicNameVARCHAR
EpicSummaryVARCHAR
EpicColorVARCHAR
EpicIssue ColorVARCHAR
EpicIs DoneBOOLEAN
SprintSprint IdINT
SprintNameVARCHAR
SprintGoalVARCHAR
SprintStateVARCHAR
SprintStart DateDATE
SprintEnd DateDATE
SprintComplete DateDATE
Issue IdINT
Issue KeyVARCHAR
Board IdINT
Board NameVARCHAR
EpicEpic IdINT
EpicKeyVARCHAR
EpicNameVARCHAR
EpicSummaryVARCHAR
EpicColorVARCHAR
EpicIssue ColorVARCHAR
EpicIs DoneBOOLEAN
Epic IdINT
KeyVARCHAR
NameVARCHAR
SummaryVARCHAR
ColorVARCHAR
Issue ColorVARCHAR
Is DoneBOOLEAN
Board IdINT
Board NameVARCHAR
Jira Service Management
Service Desk IdINT
Project IdINT
Project KeyVARCHAR
Project NameVARCHAR
Service Desk IdINT
Account IdVARCHAR
DisplayNameVARCHAR
Is ActiveBOOLEAN
Time ZoneVARCHAR
Service Desk IdINT
IdINT
NameVARCHAR
IssueIdINT
IssueKeyVARCHAR
Organization IdINT
Organization NameVARCHAR
Service Desk IdINT
Organization IdINT
Organization NameVARCHAR
Account IdVARCHAR
DisplayNameVARCHAR
Is ActiveBOOLEAN
Time ZoneVARCHAR
Request Type IdINT
NameVARCHAR
DescriptionVARCHAR
Help TextVARCHAR
Issue Type IdINT
Service Desk IdINT
Portal IdINT
Request Type IdINT
Request Type NameVARCHAR
Group IdINT
Group NameVARCHAR
IssueIdINT
IssueKeyVARCHAR
Approval IdINT
Approval NameVARCHAR
Final DecisionVARCHAR
Can Answer ApprovalBOOLEAN
Created DateDATE
Completed DateDATE
IssueIdINT
IssueKeyVARCHAR
Approval IdINT
Approval NameVARCHAR
Approver DecisionVARCHAR
Account IdVARCHAR
Display NameVARCHAR
EmailVARCHAR
Is ActiveBOOLEAN
Time ZoneVARCHAR
IssueIdINT
IssueKeyVARCHAR
Account IdVARCHAR
Display NameVARCHAR
EmailVARCHAR
Is ActiveBOOLEAN
Time ZoneVARCHAR
IssueIdINT
IssueKeyVARCHAR
SLA IdINT
SLA NameVARCHAR
SLA StatusVARCHAR
SLA Start TimeDATE
SLA Stop TimeDATE
SLA Breach TimeDATE
SLA Goal (ms.)INT
SLA Remaining (ms.)INT
SLA Elapsed (ms.)INT
SLA BreachedBOOLEAN
SatisfactionINT
Satisfaction dateDATE
RequestLanguage_customfield_10037Language codeVARCHAR
RequestLanguage_customfield_10037Display NameVARCHAR
RequestType_customfield_10010IdINT
RequestType_customfield_10010NameVARCHAR
Advanced Roadmaps (coming soon)
Assets
Workspace IdVARCHAR
Global IdVARCHAR
IdINT
NameVARCHAR
Object Schema KeyVARCHAR
StatusVARCHAR
DescriptionVARCHAR
Atlassian Template IdVARCHAR
CreatedDATE
UpdatedDATE
Object CountINT
Object Type CountINT
Can ManageBOOLEAN
Workspace IdVARCHAR
Global IdVARCHAR
IdINT
NameVARCHAR
DescriptionVARCHAR
TypeVARCHAR
Type Value MultiVARCHAR
Is LabelBOOLEAN
Default TypeVARCHAR
Is EditableBOOLEAN
Is SystemBOOLEAN
Is SortableBOOLEAN
Is SummableBOOLEAN
Is IndexedBOOLEAN
Is RemovableBOOLEAN
Is HiddenBOOLEAN
Is UniqueBOOLEAN
Is Include Child Object TypesBOOLEAN
Minimum CardinalityINT
Maximum CardinalityINT
PositionINT
SuffixVARCHAR
Aql QueryVARCHAR
Regex ValidationVARCHAR
OptionsVARCHAR
ObjectTypeIdINT
ObjectTypeObject Schema IdINT
ObjectTypeNameVARCHAR
ObjectTypeDescriptionVARCHAR
ObjectTypePositionINT
ObjectTypeCreatedDATE
ObjectTypeUpdatedDATE
ObjectTypeObject CountINT
ObjectTypeInheritedBOOLEAN
ObjectTypeAbstract Object TypeBOOLEAN
ObjectTypeParent Object Type InheritedBOOLEAN
ObjectTypeParent Object Type IdINT
ReferenceObjectTypeIdINT
ReferenceObjectTypeObject Schema IdINT
ReferenceObjectTypeNameVARCHAR
ReferenceObjectTypeDescriptionVARCHAR
ReferenceObjectTypePositionINT
ReferenceObjectTypeCreatedDATE
ReferenceObjectTypeUpdatedDATE
ReferenceObjectTypeObject CountINT
ReferenceObjectTypeInheritedBOOLEAN
ReferenceObjectTypeAbstract Object TypeBOOLEAN
ReferenceObjectTypeParent Object Type InheritedBOOLEAN
ReferenceObjectTypeParent Object Type IdINT
ReferenceTypeIdINT
ReferenceTypeNameVARCHAR
ReferenceTypeColorVARCHAR
ReferenceTypeIs RemovableBOOLEAN
Workspace IdVARCHAR
Global IdVARCHAR
IdINT
Affected AttributeVARCHAR
Old valueVARCHAR
New valueVARCHAR
CreatedDATE
ObjectObject Schema IdINT
ObjectIdINT
ObjectKeyVARCHAR
ObjectNameVARCHAR
ObjectLabelVARCHAR
ObjectCreatedDATE
ObjectUpdatedDATE
ObjectHas AvatarBOOLEAN
EditorAccount IdVARCHAR
EditorDisplay NameVARCHAR
EditorEmail AddressVARCHAR
EditorIs DeletedBOOLEAN
Workspace IdVARCHAR
IdINT
NameVARCHAR
DescriptionVARCHAR
CategoryVARCHAR
Workspace IdVARCHAR
Global IdVARCHAR
Object Schema IdINT
IdINT
KeyVARCHAR
NameVARCHAR
LabelVARCHAR
CreatedDATE
UpdatedDATE
Has AvatarBOOLEAN
ObjectTypeIdINT
ObjectTypeObject Schema IdINT
ObjectTypeNameVARCHAR
ObjectTypeDescriptionVARCHAR
ObjectTypePositionINT
ObjectTypeCreatedDATE
ObjectTypeUpdatedDATE
ObjectTypeObject CountINT
ObjectTypeInheritedBOOLEAN
ObjectTypeAbstract Object TypeBOOLEAN
ObjectTypeParent Object Type InheritedBOOLEAN
ObjectTypeParent Object Type IdINT
Workspace IdVARCHAR
Global IdVARCHAR
ValueVARCHAR
Display ValueVARCHAR
Search ValueVARCHAR
Is Referenced TypeBOOLEAN
Reference Object IdINT
AttributeIdINT
AttributeNameVARCHAR
AttributeTypesVARCHAR
AttributeDefault TypeVARCHAR
ObjectObject Schema IdINT
ObjectIdINT
ObjectKeyVARCHAR
ObjectNameVARCHAR
ObjectLabelVARCHAR
ObjectCreatedDATE
ObjectUpdatedDATE
ObjectHas AvatarBOOLEAN
Workspace IdVARCHAR
Global IdVARCHAR
Object Schema IdINT
IdINT
NameVARCHAR
DescriptionVARCHAR
PositionINT
CreatedDATE
UpdatedDATE
Object CountINT
InheritedBOOLEAN
Abstract Object TypeBOOLEAN
Parent Object Type InheritedBOOLEAN
Parent Object Type IdINT
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.
Still have questions? Feel free to reach out to us for any additional information or to request new features!