Confluence snapshot of list of JIRA Issues

[David Chou]

Given a Confluence page, is there a way to show/save a snapshot of a list of JIRA Issues? So for a given meeting page, it will show the JIRA issues and their statuses at that point time.

I was playing around with JQL, and this query shows the issues that were open in the date range, but some are closed now.

project = TEST and status was Open DURING ("2012/6/25","2012/6/25")

[Deleted user]

The add-on R4J allows you to do this. Look at Baselines. R4J does not support Atlassian Cloud at this time though. 

[Angelica Salazar]

Hello @[deleted] and @David Chou

It's been a while for this post but...

Good news! R4J Cloud has been released last month, November.

Baselines is currently in our roadmap and is expected to be released within 2022.

If you have questions and are interested in a demo of the Cloud version, please reach out to us through our support portal. We'd be happy to hear any feedback on the application.

Best regards,
Angelica

[Midori]

You export the snapshot of the issues to a PDF document, and attach that to the Confluence page.

The PDF Automation Plugin should be a handy tool to achieve this.

[Natalie Hobson]

Bring up the results you want to view on the page in JIRA, on the search page click on "Views" and then right click on "XML" and select "Copy Link Location". Then go to Confluence, and embed the link:

{jiraissues:url=puturlhere}

You can modify the height and width of the field, as well as choose which columns you want displayed, like:

{jiraissues:url=puturlhere|height=300|columns=key;summary;status}

[Natalie Hobson]

Ah, shoot - just realized you asked for a display of what they *were* and not what they currently are. If you use a macro or embed a JIRA url, it is always going to display what the current status is, so if you want a time "snapshot" I would say just use the export to pdf function (or excel) for the search and add that to the page. Of course that's not backwards compatible, but that's probably your best bet for currrent and future needs.

[David Chou]

thanks for your comment

i was hoping to utilize the awesome embeded a JQL :/

[Natalie Hobson]

As far as I know, even if you use a JQL search to get the same tickets in your results, it's only possible to display what their current values are. I don't think there's a way using a JQL search to get results to display as they were at a former time, unfortunately.