Confluence update with Jira issues

[Dhanya Sundararaju]

I have a set of issues for a sprint in JIRA which have moved to client's environments and is ready for my final signoff. I have a Confluence page where I need to enter my signoff. So, in confluence, I am looking for below columns:

JIRA issue link. for example TRAN-123

Summary

Client_1

Client_2

..

Client_25

Incase a new issue is entered in JIRA for that sprint, I want that issue to be added automatically as a row in the table. So far I have been able to get a link to JIRA but it shows the status which i do not want. All I want is,

Link to Tran without status, ts summary in another column along with my custom columns and auto create new row.

[Ross McCoy · Accepted solution]

Unfortunately, there's no one plugin I'm aware of that meets all of your needs.

Including Jira Sprint Reports or some variation thereof is possible, but it won't give you the extra columns where you can perform the sign-off. If you can deal with having the sign-off section separate from the issue data, this might work for you - I can provide more information if you'd like to go down this route. One advantage is that this (depending on how you implement it) will sync with Jira issues added to the sprint.

Another option would be to run a scripted postfunction in your workflow at the relevant transition(s) that creates/updates a confluence page via a REST API call with a table you have complete control over. This could be built completely inside a workflow, or (the route I would take) would be a combination of scripted postfunctions and script listeners. If you're a whiz a writing Groovy scripts, this may be the easiest and cheapest route to take - or you could look at enlisting the help of an Atlassian Partner to customize a solution to meet your specific use case if you're not quite proficient at scripting.

You've explained that you've already tried the Jira Issue Macro and that it doesn't meet your needs because it displays the status. Unfortunately, since the use case you've outlined here is pretty specialized (and dynamic, as we need to be able to have N many clients to sign off or N many issues), I'm just not aware of a one-size-fits-all plugin that would fit all of the pieces of the puzzle.