Can I use a Jira macro to organize a table with epics, rather than issues, as the primary operator?

Question

I have set up a Jira Issues table using the macro described here: https://confluence.atlassian.com/doc/jira-issues-macro-139380.html

This macro includes the display options I'm looking for: key, assignee, reporter, link to Confluence page.

However, I'm not looking to organize a table with all of my team's issues (there are too many to make this useful), but instead to organize based on our open epics.

Is this possible while also including in the table the other display options mentioned above?

Thank you!

Vishwas · Answer

Hey @Kelsey Ihinger

What is the exact JQL you are using in confluence to pull the data from Jira, maybe we have to narrow the search to streamline to show those epics. Like just pull the status that you are seeing in backlog.

And the ORDER BY operator works too, give a try

Kelsey Ihinger · Answer

Hi @Vishwas

Thank you for your response! The search worked, but it didn't bring back exactly what I was hoping for. Here's what I'm running into now:

* I have 23 open epics in my current project (when viewed via my Backlog > Epics), but my table with the JQL filter you recommended returns 129 issues.
* I'd also prefer to organize alphabetically. Is this possible using the ORDER BY operator?
* I have attempted, without success, to change the operator and value to = Open to return the 23 epics I'm hoping to see in my Confluence table. Is there a reason this is not an option?

Any further advice or resources would be appreciated!

Best,

Kelsey

Vishwas · Answer

Hey @Kelsey Ihinger

Welcome to Atlassian Community !!

It's possible, you can write a JQL filter in same macro like

project = ABC and issuetype = Epic and status != Closed

This query will fetch Epic Issues only which are not closed

Regards,

Vishwas