How to view a list of Epics grouped by the Sprint of their children

[JTL105]

I'm trying to create a view that is a list of Epics grouped by the sprint ID of any 1 or more of their children (sorry I don't know how to correctly describe it).   

The view I want is as follows 

v Sprint 4 (Active)
    >Epic A (Epic A has 5 stories in sprint 4)  
    v Epic B (Epic B has 1 bug in sprint 4)
          Bug B.B1
    >Epic C (Epic C has 1 story and 1 bug in sprint 4)

v Sprint 3 (Closed)
    v Epic B (Epic B (also) has 1 story in sprint 3, in addition to the bug in sprint 4)
          Story B.S1
    >Epic D (Epic D has 4 bugs in sprint 3)

> Sprint 2 (Closed)
> Sprint 1 (Closed)  

Note that the Epics are not themselves part of the sprint, only the children stories and bugs are part of the sprint.  

How can I create this view?  Should I be looking in Structure (which one?)? Plans?  (I've tried both) Or other?  

Thanks, James 

[JTL105 · Accepted solution]

With some (internal) expert advice I found a solution with Plans.

Content (Issue Sources): 
1. I created a filter and added that as an Issue Source
  >everything in my project with the desired fixVersion(s) (for my case these are only stories+bugs)
  AND
  >(type=EPIC AND issueFunction in epicsOf(the query above))  
Note that apparently issueFunction and epicsOf are features of the ScriptRunner add in.

2. I included the board that "owns" the Sprints as a 2nd Issue Source

View:
Then I adjusted the Hierarchy to Epic-to-Subtask and View Settings to Group by Sprint  

[Hannes Obweger - JXL for Jira]

Hi James @JTL105,

if you're open to solutions from the Atlassian Marketplace, I think you could get pretty close using the app that my team and I are working on, JXL for Jira:

(Note how "Belt stopover 1" is listed in "Fine Sprint 1" and "Fine Sprint 3", with the respective stories listed below.)

For context, JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. With these, building a view like the above is really just a matter of a couple of clicks.

Since you've tagged your question for Jira Server: As you may have heard, apps sales via the Atlassian Marketplace have ended for Jira Server. Are you planning to migrate to Data Center or Cloud? I'd strongly recommend that. If you need some more time, JXL is perfectly compatible with Jira Server; it's just that we need to generate a license for you. If the above looks interesting, just let me know, and I'll happily start a free trial for you.

Best,

Hannes

[JTL105]

Thanks for the reply.  That seems to be the view I'm trying to create.  Unfortunately, I'm limited to out-of-the-box jira functionality at this time, plus whatever extras my company has already purchased.  I'm only a jira user in my company. I don't have any input to or influence over whether we choose to use server or cloud (I assume it's server based on the URL).  The process to introduce any new Commercial Off The Shelf products to my company (even if they are free or a "demo") is very difficult and time consuming, so a different product will not work in my case.