Having issue with our Importer utility for Zephyr for Jira Cloud.Please click here for the steps to resolve the issue. If you are not able to access Capture Cloud and seeing a message, it means your Capture cloud instance is not migrated as part of our GDPR and Atlassian privacy policy. Please click here for the steps to Migrate your Capture Cloud instance to use Capture.
Support | Zephyr

Fetching Test step details along with its steps status from the JIRA Database.

Created on


Problem : Presently in Zephyr for JIRA versions, we do not have an option to search for all of test details with tests steps within an execution from GUI (based on the status of the step in the execution details).


Cause : When we want to find how many test steps have passed and how many test steps have failed (based on the status of the step in the execution details).


Fix : We can achieve this with the help of the SQL queries, using below tables of the JIRA DB.

Table names:

  • ao_7deabf_teststep : which has test steps  description, test step id ..etc
  • ao_7deabf_schedule : which shows the executions details like exec id exec status
  • ao_7deabf_step_result : which has test step results associated with test steps
  • jiraissue : this table has Jira issue details


Please note: You need to create a query with the help of joins to get desired details.

Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request
Powered by Zendesk