Hey everyone, I’m stuck and need some help. I want to make a table in Confluence that shows Epics from Jira based on a specific fix version. The tricky part is I want to add extra columns for comments and checkboxes that I can edit in Confluence. Here’s what I’m hoping to do:
- Pull Jira data (issue number, epic name, fix version)
- Display it in a Confluence table
- Add custom columns for comments
- Keep Jira data up-to-date if fix versions change
- Make sure comments stay with the right issues
Is this even possible? I’ve looked through the macros but can’t find anything that does all this. Has anyone done something similar or know if it can be done?
I’m imagining a table like this:
| Jira Issue |
Epic |
Version |
My Comments |
| PROJ-101 |
Feature A |
2.0 |
In progress |
| PROJ-102 |
Feature B |
2.0 |
Needs review |
But I want the Jira columns to update automatically. Any ideas?
I’ve actually tackled a similar challenge in my previous role. While there’s no perfect out-of-the-box solution, I found a workaround that might help you, Harry47.
We used a combination of the Jira Issues macro and some custom JavaScript. The Jira Issues macro pulls in the basic data, then we wrote a script to add custom columns and maintain them separately. It wasn’t perfect, but it allowed us to have both dynamic Jira data and custom fields.
The tricky part was keeping everything in sync. We ended up scheduling a daily refresh of the Jira data, which then triggered our custom script to update the table while preserving the manual entries.
It requires some coding knowledge and might be a bit complex to set up initially, but once it’s running, it’s quite effective. If you’re interested, I could share some more specifics about our implementation.
I’ve encountered a similar challenge in my organization. We found that using the Jira Issues macro as a base and then enhancing it with the Table Plus add-on from the Atlassian Marketplace offered a viable solution. This combination allows you to pull Jira data dynamically and add custom columns that persist even when the Jira data updates.
The process involves setting up the Jira Issues macro to fetch your desired fields, then using Table Plus to add and manage custom columns. It’s not perfect – you’ll need to manually refresh the Jira data periodically – but it strikes a balance between dynamic Jira information and customizable Confluence content.
One caveat: ensure your Confluence admin is on board, as this approach requires installing a third-party add-on. If you need further details on the setup, I’d be happy to elaborate.
have u tried using the Jira issues macro? it can pull some of that data for u. for the custom columns, maybe try adding them manually after the macro generates the table. not sure if it’ll stay synced tho. might need to refresh it periodically. good luck!
Hi DancingFox, could you please elaborate? I’m trying to exactly what you described. Thanks in advance!