Display Epics and Stories with JQL

[Thomas Hardin]

I know this question has been asked hundreds of times, but I cannot seem to find an answer that aligns with my needs, so I'm going to ask one more time.

My need is to display the results of a filter in a way that shows the Epic, then the linked Stories to that Epic. So, if my filter were to be: Project = XXXXXX and issuetype in (Epic, Story), I would want the results to be displayed like:

1. Epic 1
   1. Story 1.1
   2. Story 1.2
2. Epic 2
   1. Story 2.1
   2. Story 2.1

Nothing fancy other than how the results are grouped and displayed.

Thoughts? And, Thanks!

[Manikanth P · Accepted solution]

Hi Thomas Hardin,

Try below query...

Project = XXXXXX and Epiclink in (Epic1,Epic2) order by Epiclink

Regads

[Thomas Hardin]

It seems like this would require me to add all Epics that would need to be returned. Is this correct? If so, I am not sure it would be beneficial as the results will be quite large. 

At the end of the day, my goal is to simply display the result in a manner that provides users with the ability to view the data in an organized way. 

I may need to resort to a BI report or something, which we have several options to employee.

Thank you for you help. It is greatly appreciated.

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

Hi,

Have you tried to configure a Kanban Board using the JQL Filter you already provided using Epics as Swimlanes?

References:

• Modifying your query-based swimlanes

Best Regards

[Thomas Hardin]

In the particular use-case, a board would not work as the information is needed for more of a report where the order of the results needs to be displayed in a certain way.

Thank you for the response.

[Swati Chaudhari]

Hi Thomas, Were you able to figure out how to display Epics and User stories in the filter I am trying the same.