We are performing a phasewise scheduled maintenance of our Zephyr for Jira Cloud and Capure for Jira Cloud instances to be compliant with GDPR- Atlassian privacy policy (https://www.atlassian.com/trust/privacy) .Please expect a downtime during this phase of maintenance from Saturday, 01/12/2019, 9:30 PM PST up until Sunday 01/13/2019, 9:30 AM PST.This will be for our phasewise deployment of infrastructure changes, migration utility verification and customer data migration, as part of our GDPR and Atlassian privacy policy compliance efforts.For any further queries regarding this please rasie a ticket by using the option 'Submit a Ticket' below
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