It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Display Epics and Stories with JQL

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!

 

2 answers

2 accepted

0 votes
Answer accepted

Hi,

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

 

References:

 

Best Regards

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.

0 votes
Answer accepted

Hi Thomas Hardin,

Try below query...

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

 

Regads

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.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you