Xray app allows users to manage all tests as Jira issues, monitor test coverage and analyze test statuses. When building Jira reporting in BI software such as Microsoft Power BI, it is important to have this data to bring consistency to business analytics.
Power BI Connector for Jira allows to export Xray app data easily from Jira to Power BI.
Xray fields are located in a separate tab.
-
The following fields are available for export:
Tests
|
Field Name |
Field ID |
|---|---|
|
Test Issue ID |
XRAY_TEST_ISSUE_ID |
|
Status Name |
XRAY_TEST_STATUS_NAME |
|
Test Issue Key |
XRAY_TEST_ISSUE_KEY |
|
Test Type |
XRAY_TEST_TYPE |
|
Status ID |
XRAY_TEST_STATUS_ID |
|
Creator |
XRAY_TEST_CREATOR |
Test Steps
|
Field Name |
Field ID |
|---|---|
|
Test Step Test Issue ID |
XRAY_TEST_STEP_TEST_ISSUE_ID |
|
Test Step Test Issue Key |
XRAY_TEST_STEP_TEST_ISSUE_KEY |
|
Test Step Action |
XRAY_TEST_STEP_ACTION |
|
Test Step Data |
XRAY_TEST_STEP_DATA |
|
Test Step Expected Result |
XRAY_TEST_STEP_EXPECTED_RESULT |
|
Test Step Index |
XRAY_TEST_STEP_INDEX |
Test Sets
|
Field Name |
Field ID |
|---|---|
|
Test Set Issue ID |
XRAY_TEST_SET_ISSUE_ID |
|
Test Set Issue Key |
XRAY_TEST_SET_ISSUE_KEY |
Test Set Tests
|
Field Name |
Field ID |
|---|---|
|
Test Set Issue ID |
XRAY_TEST_SET_TEST_SET_ISSUE_ID |
|
Test Set Issue Key |
XRAY_TEST_SET_TEST_SET_ISSUE_KEY |
|
Test Issue ID |
XRAY_TEST_SET_TEST_ISSUE_ID |
|
Test Issue Key |
XRAY_TEST_SET_TEST_ISSUE_KEY |
|
Test Set Test Rank |
XRAY_TEST_SET_TEST_RANK |
Test Plans
|
Field Name |
Field ID |
|---|---|
|
Test Plan Issue ID |
XRAY_TEST_PLAN_ISSUE_ID |
|
Test Plan Issue Key |
XRAY_TEST_PLAN_ISSUE_KEY |
|
Test Plan Begin Date |
XRAY_TEST_PLAN_BEGIN_DATE |
|
Test Plan End Date |
XRAY_TEST_PLAN_END_DATE |
Test Plan Tests
|
Field Name |
Field ID |
|---|---|
|
Test Plan Issue ID |
XRAY_TEST_PLAN_TEST_PLAN_ISSUE_ID |
|
Test Plan Issue Key |
XRAY_TEST_PLAN_TEST_PLAN_ISSUE_KEY |
|
Test Issue ID |
XRAY_TEST_PLAN_TEST_ISSUE_ID |
|
Test Issue Key |
XRAY_TEST_PLAN_TEST_ISSUE_KEY |
|
Test Plan Test Rank |
XRAY_TEST_PLAN_TEST_RANK |
Test Runs
|
Field Name |
Field ID |
|---|---|
|
Assignee |
TEST_RUN_ASSIGNEE |
|
Comment |
TEST_RUN_COMMENT |
|
Test Execution Issue ID |
TEST_RUN_EXEC_ISSUE_ID |
|
Test Issue ID |
TEST_RUN_ISSUE_ID |
|
Rank |
TEST_RUN_RANK |
|
Status |
TEST_RUN_STATUS |
|
Started |
TEST_RUN_START_DATE |
|
Finished |
TEST_RUN_FINISH_DATE |
|
Duration |
TEST_RUN_DURATION |
|
Created |
TEST_RUN_CREATED_DATE |
|
Test Evidences Count |
TEST_RUN_EVIDENCE_COUNT |
|
Test Steps Evidences Count |
TEST_RUN_STEPS_EVIDENCE_COUNT |
|
Total Evidences Count |
TEST_RUN_TOTAL_EVIDENCE_COUNT |
|
Executed By |
TEST_RUN_EXECUTED_BY |
Test Run Defects
|
Field Name |
Field ID |
|---|---|
|
Test Run ID |
TEST_RUN_ID |
|
Defect Issue ID |
DEFECT_ISSUE_ID |