Tables and fields available for Export in 'BI Exporter for Xray'
theCode4
BI Exporter for Xray expands your exporting capabilities within the BI Exporter for Jira, whether you have the Free or PRO version. It adds a wide range of specific Xray fields to your export list, including Tests, Test Runs, Test Preconditions, Test Customfields, Test Steps, Test Plans and more, making it straightforward to bring your testing data into Power BI, Tableau, or Looker Studio. This add-on is designed to simplify your data handling, allowing users of all levels to enhance their testing analysis and workflows with ease.
Xray
Id INT
Name VARCHAR
Name VARCHAR
Description VARCHAR
Is Final BOOLEAN
Color VARCHAR
Coverage Status VARCHAR
Name VARCHAR
Description VARCHAR
Color VARCHAR
XrayTestStatusName VARCHAR
XrayTestStatusDescription VARCHAR
XrayTestStatusIs Final BOOLEAN
XrayTestStatusColor VARCHAR
XrayTestStatusCoverage Status VARCHAR
Issue Id INT
Project Id INT
Unstructured VARCHAR
Gherkin VARCHAR
Scenario Type VARCHAR
Last Modified DATE
Test Runs count INT
Test Executions count INT
Test Plans Count INT
Test Sets Count INT
Test Preconditions Count INT
Test Versions Count INT
XrayTestTypeId VARCHAR
XrayTestTypeName VARCHAR
XrayTestTypeKind VARCHAR
XrayTestFolderName VARCHAR
XrayTestFolderKind VARCHAR
XrayTestStatusName VARCHAR
XrayTestStatusDescription VARCHAR
XrayTestStatusIs Final BOOLEAN
XrayTestStatusColor VARCHAR
Issue Id INT
Project Id INT
Definition VARCHAR
LastModified DATE
Tests Count INT
Test Versions Count INT
XrayPreconditionTypeId VARCHAR
XrayPreconditionTypeName VARCHAR
XrayPreconditionTypeKind VARCHAR
XrayPreconditionFolderName VARCHAR
XrayPreconditionFolderKind VARCHAR
Issue Id INT
Project Id INT
LastModified DATE
Tests Count INT
Test Executions Count INT
Issue IdINT
Project IdINT
Test EnvironmentsVARCHAR
LastModifiedDATE
Tests CountINT
Test Plans CountINT
Test Runs CountINT
Issue Id INT
Project Id INT
LastModified DATE
Tests CountI NT
Issue Id INT
Project Id INT
LastModified DATE
XrayTestIssue Id INT
XrayTestProject Id INT
XrayTestUnstructured VARCHAR
XrayTestGherkin VARCHAR
XrayTestScenario Type VARCHAR
XrayTestLast Modified DATE
XrayTestType Id VARCHAR
XrayTestType Name VARCHAR
XrayTestType Kind VARCHAR
XrayTestStatus Name VARCHAR
XrayTestStatus Description VARCHAR
XrayTestStatus Is Final BOOLEAN
XrayTestStatus Color VARCHAR
XrayTestRuns count INT
XrayTestExecutions count INT
XrayTestPlans Count INT
XrayTestSets Count INT
XrayTestPreconditions Count INT
XrayTestVersions Count INT
Issue Id INT
Project Id INT
LastModified DATE
XrayExecutionIssue Id INT
XrayExecutionProject Id INT
XrayExecutionTest Environments VARCHAR
XrayExecutionLast Modified DATE
XrayExecutionTests Count INT
XrayExecutionTests Plans Count INT
XrayExecutionTests Runs Count INT
Issue Id INT
Project Id INT
Test Environments VARCHAR
LastModified DATE
XrayTestIssue Id INT
XrayTestProject Id INT
XrayTestUnstructured VARCHAR
XrayTestGherkin VARCHAR
XrayTestScenario Type VARCHAR
XrayTestLast Modified DATE
XrayTestType Id VARCHAR
XrayTestType Name VARCHAR
XrayTestType Kind VARCHAR
XrayTestStatus Name VARCHAR
XrayTestStatus Description VARCHAR
XrayTestStatus Is Final BOOLEAN
XrayTestStatus Color VARCHAR
XrayTestRuns count INT
XrayTestExecutions count INT
XrayTestPlans Count INT
XrayTestSets Count INT
XrayTestPreconditions Count INT
XrayTestVersions Count INT
Issue Id INT
Project Id INT
Definition VARCHAR
LastModified DATE
TypeId VARCHAR
TypeName VARCHAR
TypeKind VARCHAR
TestIssue Id INT
TestProject Id INT
TestUnstructured VARCHAR
TestGherkin VARCHAR
TestScenario Type VARCHAR
TestLast Modified DATE
TestType Id VARCHAR
TestType Name VARCHAR
TestType Kind VARCHAR
TestStatus Name VARCHAR
TestStatus Description VARCHAR
TestStatus Is Final BOOLEAN
TestStatus Color VARCHAR
TestRuns count INT
TestExecutions count INT
TestPlans Count INT
TestSets Count INT
TestPreconditions Count INT
TestVersions Count INT
Issue Id INT
Project Id INT
LastModified DATE
TestIssue Id INT
TestProject Id INT
TestUnstructured VARCHAR
TestGherkin VARCHAR
TestScenario Type VARCHAR
TestLast Modified DATE
TestType Id VARCHAR
TestType Name VARCHAR
TestType Kind VARCHAR
TestStatus Name VARCHAR
TestStatus Description VARCHAR
TestStatus Is Final BOOLEAN
TestStatus Color VARCHAR
TestRuns count INT
TestExecutions count INT
TestPlans Count INT
TestSets Count INT
TestPreconditions Count INT
TestVersions Count INT
Id VARCHAR
Action VARCHAR
Data VARCHAR
Result VARCHAR
Call Test Issue Id INT
TestIssue Id INT
TestProject Id INT
TestUnstructured VARCHAR
TestGherkin VARCHAR
TestScenario Type VARCHAR
TestLast Modified DATE
TestType Id VARCHAR
TestType Name VARCHAR
TestType Kind VARCHAR
TestStatus Name VARCHAR
TestStatus Description VARCHAR
TestStatus Is Final BOOLEAN
TestStatus Color VARCHAR
TestRuns count INT
TestExecutions count INT
TestPlans Count INT
TestSets Count INT
TestPreconditions Count INT
TestVersions Count INT
Id VARCHAR
Filename VARCHAR
Is Stored In Jira BOOLEAN
Download Link VARCHAR
StepId VARCHAR
StepAction VARCHAR
StepData VARCHAR
StepResult VARCHAR
StepCall Test Issue Id INT
TestIssue Id INT
TestProject Id INT
TestUnstructured VARCHAR
TestGherkin VARCHAR
TestScenario Type VARCHAR
TestLast Modified DATE
TestType Id VARCHAR
TestType Name VARCHAR
TestType Kind VARCHAR
TestStatus Name VARCHAR
TestStatus Description VARCHAR
TestStatus Is Final BOOLEAN
TestStatus Color VARCHAR
TestRuns count INT
TestExecutions count INT
TestPlans Count INT
TestSets Count INT
TestPreconditions Count INT
TestVersions Count INT
Id VARCHAR
Name VARCHAR
Value VARCHAR
StepId VARCHAR
StepAction VARCHAR
StepData VARCHAR
StepResult VARCHAR
StepCall Test Issue Id INT
TestIssue Id INT
TestProject Id INT
TestUnstructured VARCHAR
TestGherkin VARCHAR
TestScenario Type VARCHAR
TestLast Modified DATE
TestType Id VARCHAR
TestType Name VARCHAR
TestType Kind VARCHAR
TestStatus Name VARCHAR
TestStatus Description VARCHAR
TestStatus Is Final BOOLEAN
TestStatus Color VARCHAR
TestRuns count INT
TestExecutions count INT
TestPlans Count INT
TestSets Count INT
TestPreconditions Count INT
TestVersions Count INT
Id VARCHAR
Unstructured VARCHAR
Gherkin VARCHAR
Scenario Type VARCHAR
Comment VARCHAR
Started On DATE
Executed By Id VARCHAR
Assignee Id VARCHAR
Finished On DATE
Last Modified DATE
Parameters VARCHAR
TestRunTypeId VARCHAR
TestRunTypeName VARCHAR
TestRunTypeKind VARCHAR
TestRunExecutionIssue Id INT
TestRunExecutionProject Id INT
TestRunExecutionTest Environments VARCHAR
TestRunExecutionLastModified DATE
TestIssue Id INT
TestProject Id INT
TestUnstructured VARCHAR
TestGherkin VARCHAR
TestScenario Type VARCHAR
TestLast Modified DATE
TestType Id VARCHAR
TestType Name VARCHAR
TestType Kind VARCHAR
TestStatus Name VARCHAR
TestStatus Description VARCHAR
TestStatus Is Final BOOLEAN
TestStatus Color VARCHAR
TestRuns count INT
TestExecutions count INT
TestPlans Count INT
TestSets Count INT
TestPreconditions Count INT
TestVersions Count INT
Id VARCHAR
Filename VARCHAR
Is Stored In Jira BOOLEAN
Download Link VARCHAR
Size INT
Created On DATE
RunId VARCHAR
RunUnstructured VARCHAR
RunGherkin VARCHAR
RunScenario Type VARCHAR
RunComment VARCHAR
RunStarted On DATE
RunExecuted By Id VARCHAR
RunAssignee Id VARCHAR
RunFinished On DATE
RunLast Modified DATE
RunParameters VARCHAR
RunTest Type Id VARCHAR
RunTest Name VARCHAR
RunTest Kind VARCHAR
RunTest Issue Id INT
RunTest Execution Project Id INT
RunTest Execution Test Environments VARCHAR
RunTest Execution LastModified DATE
TestIssue Id INT
TestProject Id INT
TestUnstructured VARCHAR
TestGherkin VARCHAR
TestScenario Type VARCHAR
TestLast Modified DATE
TestType Id VARCHAR
TestType Name VARCHAR
TestType Kind VARCHAR
TestStatus Name VARCHAR
TestStatus Description VARCHAR
TestStatus Is Final BOOLEAN
TestStatus Color VARCHAR
TestRuns count INT
TestExecutions count INT
TestPlans Count INT
TestSets Count INT
TestPreconditions Count INT
TestVersions Count INT
Id VARCHAR
Filename VARCHAR
Value VARCHAR
RunId VARCHAR
RunUnstructured VARCHAR
RunGherkin VARCHAR
RunScenario Type VARCHAR
RunComment VARCHAR
RunStarted On DATE
RunExecuted By Id VARCHAR
RunAssignee Id VARCHAR
RunFinished On DATE
RunLast Modified DATE
RunParameters VARCHAR
RunTest Type Id VARCHAR
RunTest Name VARCHAR
RunTest Kind VARCHAR
RunTest Issue Id INT
RunTest Execution Project Id INT
RunTest Execution Test Environments VARCHAR
RunTest Execution LastModified DATE
TestIssue Id INT
TestProject Id INT
TestUnstructured VARCHAR
TestGherkin VARCHAR
TestScenario Type VARCHAR
TestLast Modified DATE
TestType Id VARCHAR
TestType Name VARCHAR
TestType Kind VARCHAR
TestStatus Name VARCHAR
TestStatus Description VARCHAR
TestStatus Is Final BOOLEAN
TestStatus Color VARCHAR
TestRuns count INT
TestExecutions count INT
TestPlans Count INT
TestSets Count INT
TestPreconditions Count INT
TestVersions Count INT
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!