Reporting: Using Epic for end-to-end testing with child issues (test cases) in sequential order

[Anna Comer]

My client is using Epics as a parent to end-to-end (sequential testing) with test cases as the child issues. We need to find an appropriate way to report the status of each epic (with sequence in mind) - are there any gadgets / boards that you can recommend to use? Or in confluence using JQL

[mauricio.groth]

Hi @Anna Comer 

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to find all the parent epics that have a test case as a child ordering by the createdDate of the epic. You can change the sequential order just altering after “order by”.

issue in parentsOfIssuesInQuery("type = 'test cases'") and type = epic order by createdDate

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

[Mark Segall]

Hi @Anna Comer 

If you have the specific Epic, and depending upon whether the project is company managed or team managed, you could do JQL like this:

Company Managed Project

"Epic Link" = ABC-123

Team Managed Project

Parent = ABC-123

[Madhu_RVS]

Hi @Anna Comer 

If you would be interested in a mktplace app for a ready made solution, you can try out

Issue Hierarchy Reports 

With the help of the app, you can view

- View the full Jira Issue Type hierarchy of Linked issues,
Portfolio/Advanced Roadmaps, Epics, and Subtasks up to 10 levels.

- % complete based on time spent and story points at each hierarchy level

Disclaimer : I work for the vendor who created this app

[Eduardo Oliveira - Mindpro Apps]

Hello @Anna Comer 

If you are open to using an add-on, take a look at this one - Mindpro Insights: Dynamic Dashboards & Reports for Jira.

With this app, you can build interactive dashboards using data from different sources (Jira Software, Work Management, or Service Management) and track multiple projects and initiatives (including sprints, epics, and releases and measure progress using time estimation, story points, or issues count) with an integrated view of your metrics and issues list on the same screen.

Additionally, you can enable a hierarchy view to track this parent and child relationship between your epics and child issues.

If you want to explore more, take a look here: https://mindpro.solutions/insights-learn-more

Give it a spin, maybe it can help in your scenario.

All the best, Eduardo from Mindpro Team.