JQL to return epics and all their associated initiatives

[Tom Smith]

Hi,

We have the following structure:
features -> initiatives > epics > stories.

I am trying to write a search query that displays all the epics associated to a project, as well as their respective initiatives.

I am looking to display all columns associates to Epics, as well as Initiatives in this particular query.

For example, 1 query to return the following:
Epic number, epic summary, epic description, epic size, initiative number, initiative name, Initiative description, initiative size.

I understand that the initiative details might be the same for many queries but it's okay.

Any help is greatly appreciated.

Note: I only have the default JQL editor.

Thanks!

[Hannes Obweger - JXL for Jira]

Hi @Tom Smith

just to clarify, when you say jQuery, do you mean JQL? And where does the features / initiatives / epics / stories hierarchy come from - is this configured in Jira as described here?

[Tom Smith]

Hi @Hannes Obweger - JXL for Jira , thanks for getting back to me

It's a Yes to both of your questions.

[Hannes Obweger - JXL for Jira]

Hey @Tom Smith,

all clear!

To see these fields exactly as you described - i.e., with these fields being shown in the same "row" in your list of issues - I believe you'd have to 

• do an Excel or CSV export of your issues and perform some kind of post processing, based on the respective parent fields, or
• use Jira Automation to copy/sync the initiative values down to custom fields on the epic, and then view these custom fields.

Neither option is particularly great, I'm afraid.

If you would be okay with a hierarchical view of your data - i.e., to see epics "below" their initiatives - there's a view more things I can think of:

• If you are on Jira Premium, you can view your issues in their hierarchy in Advanced Roadmaps. AR will already respect your issue hierarchy configuration, so it should only be a matter of setting up a plan that includes the relevant issues. I'm not sure if AR would be able to show all the fields that you're interested in, but it's worth a try.
• There's a number of hierarchy-focused apps in the Atlassian Marketplace that could help with this. I myself happen to work on such an app, in which your use case should be quite easy to solve; I'll provide more information below. 

[Hannes Obweger - JXL for Jira]

... to expand on the last point: If a solution from the Atlassian Marketplace is an option for you, I believe you might like the app that my team and I are working on, JXL for Jira.

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. JXL also comes with a number of advanced features, including support (configurable) issue hierarchies; with this, you could build a view like this in just a couple of clicks:

You can view any number of issue levels, any issue fields. There's also a number of other great features, ranging from "smart columns" that aren't natively available (like "time in status"), to (nested) issue grouping, or conditional formatting.

Any questions just let me know,

Best,

Hannes