How to see all active projects and their respective epics in a Confluence page?

[Arlene.Amaya]

My org uses Jira Software for task mgmt and Confluence as well. Projects and epics are not organized very well so I'm helping reorganize. I'd like to create a Confluence page where I can see, all at once, each active project and all of their respective epics. That way, my team can decide which ones to merge/remove/add.

Right now, I have only found a way to see a list of all active projects. I have to click on a little filter button in order to go to that individual project and see all issues, then filter by 'epic' issue type. It's hard to compare projects and epics. Thanks!

[Trudy Claspill · Accepted solution]

Hello @Arlene.Amaya 

You can use the Jira Macro in Confluence to display a list of issues based on an issue filter like you would construct in Jira.

What method are you using to get your list of active projects?

[Arlene.Amaya]

Right, I'm looking for a way to see each project and its epics in one single view that can display hierarchy (project A and its epics B, C, and D; project E and its epics F and G; etc.)  rather than a list of issues. Is there no way to do this in Confluence?

[Trudy Claspill]

I'm not sure I understand what you want.

Epics are just another type of issue that you can list out.

Does something like this not match your need?

I manually typed in text for headers for each project then inserted a Jira macro below that the retrieve the Epic issues for that project.

[Arlene.Amaya]

Yes, that's pretty much it except that I was hoping projects would automatically be populated so they can be updated along with epics. I'll likely be deleting/renaming some of them and it would be helpful if those changes could be reflected automatically. But I'm assuming that might not be possible?

[Trudy Claspill]

What is your definition of an "active" project?

For instance, is any and all projects on the Jira system with Epics that are not "done" considered "active"?

And for such projects do you want to see all the Epics regardless of the status of the Epics?

If you definition of "active" projects is any project with a not "done" then you can use a filter like 

issueType=Epic and statusCategory!=Done order by Project asc

That will retrieve all Epics that are not "done".

Then in configuring the Jira macro add the Project field to the output. Your list will then show the Project name next to each Epic.

There are two macros available in Confluence for displaying Jira issues currently - one named Jira Issues and one named Legacy Jira. In my system when I add the Project field to the display of the Jira Issues macro not data is actually displayed in that field. But if I use the Legacy Jira macro and add the Project field to its display options, then the Project name does display.

The first table in the image below is the Jira Issues macro. Displayed below it is the first part of the Legacy Jira macro.

[Arlene.Amaya]

This should work, thank you!