Info

Data Processor BI Exporter for Xray expands your exporting capabilities within the Data Processor 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.

Image Modified Xray

Expand

title	Issue Link Types

Id INT
Name VARCHAR

Expand

title	Statuses

Name VARCHAR
Description VARCHAR
Is Final BOOLEAN
Color VARCHAR
Coverage Status VARCHAR

Expand

title	Step Statuses

Name VARCHAR
Description VARCHAR
Color VARCHAR
XrayTestStatusName VARCHAR
XrayTestStatusDescription VARCHAR
XrayTestStatusIs Final BOOLEAN
XrayTestStatusColor VARCHAR
XrayTestStatusCoverage Status VARCHAR

Expand

title	Tests

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

Expand

title	Preconditions

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

Expand

title	Plans

Issue Id INT
Project Id INT
LastModified DATE
Tests Count INT
Test Executions Count INT

Expand

title	Executions

Issue IdINT
Project IdINT
Test EnvironmentsVARCHAR
LastModifiedDATE
Tests CountINT
Test Plans CountINT
Test Runs CountINT

Expand

title	Sets

Issue Id INT
Project Id INT
LastModified DATE
Tests CountI NT

Expand

title	Test Plans

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

Expand

title	Test Plan Executions

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

Expand

title	Test Executions

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

Expand

title	Test Preconditions

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

Expand

title	Test Sets

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

Expand

title	Test Steps

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

Expand

title	Test Step Attachments

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

Expand

title	Test Step Custom Fields

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

Expand

title	Test Runs

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

Expand

title	Test Run Evidences

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

Expand

title	Test Run Customfields

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

Panel

panelIconId	1f937-200d-2642-fe0f
panelIcon	:man_shrugging:
panelIconText	🤷‍♂️
bgColor	#EAE6FF

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

Panel

panelIconId	2b50
panelIcon	:star:
panelIconText	⭐
bgColor	#FFEBE6

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. 🤝

Aura inline button

summary

back to top

params

JTdCJTIybGFiZWwlMjIlM0ElMjJiYWNrJTIwdG8lMjB0b3AlMjIlMkMlMjJzaXplJTIyJTNBJTIybWVkaXVtJTIyJTJDJTIyc2hhcGUlMjIlM0ElMjJjaXJjdWxhciUyMiUyQyUyMnN0YXRlcyUyMiUzQSU3QiUyMmlkbGUlMjIlM0ElN0IlMjJjb2xvcnMlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kJTIyJTNBJTIyJTIzMjY4NGZmJTIyJTJDJTIybGFiZWwlMjIlM0ElMjIlMjNmZmZmZmYlMjIlN0QlN0QlMkMlMjJob3ZlciUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiU3RCU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIyYXJyb3dzLXVwLXRvLWxpbmUlMjIlN0QlMkMlMjJsaW5rJTIyJTNBJTdCJTIydHlwZSUyMiUzQSUyMmxpbmslMjIlMkMlMjJ2YWx1ZSUyMiUzQSUyMmh0dHBzJTNBJTJGJTJGdGhlY29kZTQuYXRsYXNzaWFuLm5ldCUyRndpa2klMkZzcGFjZXMlMkZEUEZKJTJGcGFnZXMlMkY0MTI1NDkxMyUyRlRhYmxlcyUyQmFuZCUyQmZpZWxkcyUyQmF2YWlsYWJsZSUyQmZvciUyQkV4cG9ydCUyQmluJTJCRGF0YSUyQlByb2Nlc3NvciUyQmZvciUyQlhyYXklMjMlMjU1Qm1lZGlhSW5saW5lJTI1NUQtWHJheSUyMiU3RCU3RA==

Aura inline button

summary

Free App

params

JTdCJTIybGFiZWwlMjIlM0ElMjJGcmVlJTIwQXBwJTIyJTJDJTIyc2l6ZSUyMiUzQSUyMmxhcmdlJTIyJTJDJTIyc2hhcGUlMjIlM0ElMjJyb3VuZGVkJTIyJTJDJTIyc3RhdGVzJTIyJTNBJTdCJTIyaWRsZSUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjMyNjg0ZmYlMjIlMkMlMjJsYWJlbCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiU3RCUyQyUyMnNoYWRvdyUyMiUzQSUyMmUyMDAlMjIlN0QlMkMlMjJob3ZlciUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjMwMDY1ZmYlMjIlN0QlN0QlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIycG9zaXRpb24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyaWNvbiUyMiUzQSUyMmNsb3VkJTIyJTdEJTJDJTIybWluV2lkdGglMjIlM0EwJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRm1hcmtldHBsYWNlLmF0bGFzc2lhbi5jb20lMkZhcHBzJTJGMTIzMzAzNCUyRmRhdGEtcHJvY2Vzc29yLWZvci1qaXJhLW11bHRpLWJpLWNvbm5lY3Rvci1mcmVlJTNGaG9zdGluZyUzRGNsb3VkJTI2dGFiJTNEb3ZlcnZpZXclMjIlMkMlMjJ0YXJnZXQlMjIlM0ElMjJfYmxhbmslMjIlN0QlN0Q=

Aura inline button

summary

Book a Demo

params

JTdCJTIybGFiZWwlMjIlM0ElMjJCb29rJTIwYSUyMERlbW8lMjIlMkMlMjJzaXplJTIyJTNBJTIybGFyZ2UlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMnJvdW5kZWQlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzAwNjVmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIybGFwdG9wJTIyJTdEJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRm1lZXRpbmdzLWV1MS5odWJzcG90LmNvbSUyRnRoZWNvZGU0JTIyJTJDJTIydGFyZ2V0JTIyJTNBJTIyX2JsYW5rJTIyJTdEJTdEJTdCJTIybGFiZWwlMjIlM0ElMjJCb29rJTIwYSUyMERlbW8lMjIlMkMlMjJzaXplJTIyJTNBJTIybGFyZ2UlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMnJvdW5kZWQlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzAwNjVmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIybGFwdG9wJTIyJTdEJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRmNhbGVuZGx5LmNvbSUyRnN1cHBvcnQtcXlpJTJGMzBtaW4lMjIlMkMlMjJ0YXJnZXQlMjIlM0ElMjJfYmxhbmslMjIlN0QlN0Q=

Aura inline button

summary

PRO App

params

JTdCJTIybGFiZWwlMjIlM0ElMjJQUk8lMjBBcHAlMjIlMkMlMjJzaXplJTIyJTNBJTIybGFyZ2UlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMnJvdW5kZWQlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzI2ODRmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzAwNjVmZiUyMiU3RCU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIyZGF0YWJhc2UlMjIlN0QlMkMlMjJtaW5XaWR0aCUyMiUzQTAlMkMlMjJsaW5rJTIyJTNBJTdCJTIydHlwZSUyMiUzQSUyMmxpbmslMjIlMkMlMjJ2YWx1ZSUyMiUzQSUyMmh0dHBzJTNBJTJGJTJGbWFya2V0cGxhY2UuYXRsYXNzaWFuLmNvbSUyRmFwcHMlMkYxMjMzNTA0JTJGZGF0YS1wcm9jZXNzb3ItZm9yLWppcmEtbGluay1wb3dlci1iaS1sb29rZXItdGFibGVhdS1wcm8lM0Zob3N0aW5nJTNEY2xvdWQlMjZ0YWIlM0RvdmVydmlldyUyMiUyQyUyMnRhcmdldCUyMiUzQSUyMl9ibGFuayUyMiU3RCU3RA==

Panel

panelIconId	1f917
panelIcon	:hugging:
panelIconText	🤗
bgColor	#E6FCFF

Still have questions? Feel free to reach out to us for any additional information or to request new features!

Versions Compared

Old Version 5

New Version Current

Key

Image Modified Xray

Page Comparison

Versions Compared

Old Version 5

New Version Current

Key

Image Modified Xray