Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


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

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 

2 answers

1 accepted

1 vote
Answer accepted

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)
  >(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

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

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Sep 21, 2023

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.



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.  

Suggest an answer

Log in or Sign up to answer