Can we display within Confluence, using JIRA macro, the column values of Issue Links?

Question

I am trying to use JIRA macro within confluence to display the status of all epics, and any defects and test cases associated with them along with the assignee

For example:

Table columns for display should look like:

1. Epic number with status

2. Assignee

3. ISsue Links (Only ASSOCIATED defects and Test cases) need to be displayed but not stories.  (Not sure how to display this)

4. UAT date

This is high-level table/page which I want to be sharing each day as the report.

Thanks.

Alex_dddmmh · Accepted Answer

Hi @Anupama kapoor

You won't be able to generate this report using Jira OOTB, but I believe you can develop something similar to your description using this filter:

project = "XXXX" and type in ("defects","Test cases") and "Epic Link" is not EMPTY ORDER BY "Epic Link"

From this JQL, you can configure the filter to display:

* Issue key
* Assignee
* Epic Link

Note that it will be a more granular list, and there is the limitation of the UAT date field in case it is only available at the Epic level. Otherwise, you can list it as a column.

If your project does not have too many Epics, you also consider creating one filter for each Epic and display them in different Jira gadgets in Confluence.

I hope it helps. If this answer helps solve the problem, please come back and mark this answer as solved to help other community members with the same challenge. If not, you are welcome to share your solution as well.

Cheers,

Alex