Linking last comment to a confluence page

Chris Watson_crc0ah

Morning, I am trying to find out if there is a way for me to link my initiatives or epics to a confluence page and display the last comment posted to them. Just a quick state of the union page for leaders to see project updates and status without having to drill down into each initiative or epic.  Something like this

EI-1111

Project is delayed due to supply chain issues

EL-2222

Audits have been completed. Design phase has begun

 

I have tried linking a Jira issue to my confluence page and displaying it as a table. I tried adding latest comment, last comment and resolution comments to the fields, but none show any data. 

Chris Watson_crc0ah

I was able to get this working using an automation rule that triggers when an issue is commented on. Apparently the comment variables that confluence lists, like last comment and latest comment in their Jira Macro maps to an empty field that you have to populate.

So I created a rule that updates the latest comment field, which then updates the confluence page. I would have preferred it be a little more dynamic, but this is all I could figure out to get this working. Going forward it should work fine, but any issues that I have linked that have not had a comment entered after the rule was created still show blank.

This is the value I entered for the last comment field update.

{{issue.comments.last.body}}

This is where I found out how to do this as well.

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/How-to-display-Last-comment-in-Filter-JQL-and-any-Add-on/ba-p/1489153