Sorted JQL Filter for epics and member issues

I'd like to create a filter for showing a list of all open Epics with it's issues listed immediately below it. How can I do that?

Creating a JQL filter which displays the epics and its member issues is fairly easy:

"project = SP AND (issuetype = Epic OR "Epic Link" is not EMPTY)"

However, I want to order the search result where the issues belonging to the same epic is grouped together. The problem is that the epic uses the field "Epic name", while the issues use "Epic link" so ordering is difficult. Can I join these two fields into one and put an order on the joined column like you can in SQL?

7 answers

0 votes

Within JQL itself it is not possible to sort in the fashion as you have written in your question.
Depending on the requirements for wanting such a sorting method, there might be different approaches to displaying the data in the way you are looking for.

We also would like to visualize the set of epics and their corresponding stories in a particular release. Any suggestions would be welcome

Us to.

Me too!  I have been hunting for ways to do this.  It seems very basic I can't believe it is not supported.

Have anybody a solution for this problem? I have the same topic.




Looking for a way to do this too. In SQL this would be possible with something like:

ORDER BY COALESCE("Epic Name", "Epic Link")

Hey folks, for my needs I found a solution for this in the "Single Level Group By Report", a standard JIRA report. I defined a filter, picked it in the report and set the "Statistic" to be "Epic Link". It works well and I use an iFrame to display it in a Confluence page.

Single Level Group By Report documentation.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Wednesday in Jira

Make your Atlassian Cloud products more secure: our NEW admin security guide

Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...

258 views 0 6
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you