In Confluence I have a Jira Macro returning Epics of Stories in the Sprint. I would like on of the columns to be the "Issues in Epic".

I am using this query:

issueFunction in linkedIssuesOf("sprint in openSprints()", "has epic")

This returns the information I want. Now in the Macro, I am looking at the "display options" area. In "columns to display" I would like to display the "issues in Epic" but it isn't an option. When I go to my epic, there is an section with that name, so I assume it is one of the options. Am I overlooking an option or is that just not possible?

1 answer

It seems to me that you are trying to show what's in currently open sprints, along with their Epics? And the problem is that Epics are not returned by "sprint in openSprints()", because they can span multiple sprints.

>  In "columns to display" I would like to display the "issues in Epic" but it isn't an option

Because it's not a field, it's a rendering of certain of the issue links.

As an alternative how about:

issueFunction in linkedIssuesOf("sprint in openSprints()", "has epic") or sprint in openSprints()

The first part gives you epics to active stuff, the second part gives you the active stuff. 

An alternative, if you only want to show issues that have an epic link, could be:

issueFunction in linkedIssuesOf('issueFunction in linkedIssuesOf("sprint in openSprints()", "has epic")', 'is Epic of')

I guess I didn't explain what I'm trying to accomplish very well. The customer likes seeing progress on Epics. And they like seeing how many stories left until the Epic is complete. So I want to have a list of the Epics that were worked on this sprint. Then I want to give all of the ID numbers of the stories in that epic (worked or not). Then, there should be a slash through the completed stories. That you should how many stories in worked epics have been completed and how many stories in worked epics haven't been completed all ordered by epic.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Monday in Confluence

Organizing your space just got easier - Page Tree Drag & Drop is here

Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...

62 views 3 2
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you