Xray Test Management for Jira

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 SQL, it is important to have this data to bring consistency to business analytics.

SQL Connector for Jira allows to export of Xray app data easily from Jira to SQL.

Xray fields are located in a separate tab.

The following fields are available for export

Field Name	Field ID

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

Field Name	Field ID

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

Field Name	Field ID

Field Name	Field ID
Test Set Issue ID	XRAY_TEST_SET_ISSUE_ID
Test Set Issue Key	XRAY_TEST_SET_ISSUE_KEY

Field Name	Field ID

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

Field Name	Field ID

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