Introduction
Using Zephyr for testing?
SQL+JQL Driver supports Zephyr for reporting your cycles, executions, test, steps, defects, etc. and relate them with Git and Subversion commits and the rest of the Jira Core, Software and Service Desk entities like projects, versions, components, epics, sprints, etc ! to make end-to-end ALM reports.
The new Zephyr schema t is a very straightforward representation of the Zephyr’s Active Objects relational data model:
Security
As the SQL+JQL schema is mainly straightforward virtualization of the underlying schema in the Jira database, the Zephyr permissions are ignored by default.
You have to check manually in your queries by those permissions when the query is written.
Please read the Users documentation to learn how to check if the user belongs to a group and the user’s permissions (global, project, and issue levels).
Ignoring Zephyr permissions allows making Zephyr reports for the rest of the organization without requiring extra Jira configuration. But the responsibility of avoiding data leaks remains now on the trusted user writing the query.
Download ZEPHYR Database Schema
Please download and open the SVG file zipped to see all the new tables, columns and their relationships:
Next step: > Zephyr Examples