JQL to find all open issues grouped by epic

[Ramesh M]

Hi, 

I am using corporate version. I am looking for a jira report with all the open issues  grouped by epic, like

EPIC-1

      ISSUE-11

      ISSUE-12

EPIC-2

     ISSUE-21

     ISSUE-22

any way to get this ?

[Ramesh M]

any documentation as how to create such reports ?

[Valeriia_Havrylenko_SaaSJet]

Hello  @Ramesh M  👋  

Unfortunately, It is not possible to achieve this by JQL.

As an alternative , if you are switching to cloud version, I guess you can try Time in Status for Jira Cloud (developed by my SaaSJet team) with 7 types of status time reports which you can sort by Epic. 

Also you can get this report by Pivot Table view.
Here is a use case - How to get time in status data by Epics?

Add-on has a 30-day free trial version and free up to 10 users. 
Please, let me know if you have any questions

Hope it helps 😌
Valeriia

[RVS_Support]

Hi @Ramesh M 

Welcome to the community !!!

We have built an app which can help meet your use case. If you are fine to try out take a look at 

Agile Tools

The add-on provides the hierarchy view of your Epics and you can also track the progress of the same based on the roll up of your child issues.

Do try it out.

Disclaimer : I work for RVS, the vendor for this app

[Ingo W_]

Hi @Ramesh M , @Sebastian Krzewiński ,

while I've searched for a solution to select stories groupby(Epic), I've found this request and the lack of a simple solution.

Just thought about it and we've implemented following solution which works fine for us:

1. create a new customfield, simple text, and name it "outline"

This new field will store the rank of the overall outline

2. create a new automation rule with following steps:

- Step 1: find all Epics and copy the {{issue.key}} into customfield "outline"

- Step 2: find all Stories and set the field outline to "{{issue.parent.key}}.{{issue.key}}"

We trigger this automation manually to update the outline for the current project.

While adding an order by outline to your JQL, you will get a groupby(Epic) like result.

You can go forward to improve the automation to be triggered on issue create oder sth. like parent changed.

[Hannes Obweger - JXL for Jira]

Hi @Ramesh M

there's a couple of ways forward here:

In Jira build-in issue search, you could use a JQL query a la 

<your query> ORDER BY "Epic Link"

to get your issues ordered by - and therefore "grouped" by - their epic. If you then also add the Epic Link as a column, you're pretty close to what you are looking for.

Alternatively, if you have Advanced Roadmaps, it will show you your issues in their hierarchy, with issues listed "below" their epics.

Finally, as already suggested, there's a number of apps on the Atlassian Marketplace that can help with this, too. I myself also happen to work on such an app; I'll provide more details below.

Hope this helps,

Best,

Hannes

[Hannes Obweger - JXL for Jira]

Just to expand on the last point, this is how this would look in the app that my team and I are working on, JXL for Jira:

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. As you can see above, viewing your issues in their standard epic/story/sub-task hierarchy - what we call the default hierarchy - is just a matter of two clicks.

Since you've tagged your question for Jira Server: As you may have heard, apps sales 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.

[Sebastian Krzewiński]

Hi @Ramesh M 

It is not possible to achieve this by one JQL. Similar order I achieved by Structure app (paid app).

Regards,

Seba