Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,300,669
Community Members
 
Community Events
165
Community Groups

Can I add a static Information from a set of JIRA tickets and add a confluence column to add text?

At the moment I'm trying to create reports on the status of tickets out of multiple projects in JIRA.  I can use the JIRA Macro in confluence and get the correct columns to be displayed using JQL filters.  

However, I want to have a weekly static snapshot with all this information in the table, but I would also like to add a column to the table that can be completed from within Confluence so no one needs to go to each JIRA ticket to add some commentary to the report.  Is this possible with vanilla?  Or is there another way to do it?

Field I have from JIRA:

- Key

- Summary

- Priority

- Status

- Type

- Story Points 

- Labels

- Supporting Information (custom field)

- And I would like to add a Notes field in the confluence table for the teams to complete with summaries.

1 answer

1 accepted

1 vote
Answer accepted
Fabian Lim Community Leader Nov 03, 2021

Hi @Brian Walker

Unfortunately, you won't be able to do this with the jira issues macro.  You can request this as a new feature here: System Dashboard - Create and track feature requests for Atlassian products.

Or check the marketplace for plugins.

Regards

I suspected that would be the case.

 

Thank you for confirming

@Brian Walker You can query the history of a JIRA-Ticket. See https://community.atlassian.com/t5/Jira-articles/Becoming-a-JIRA-Search-Ninja-History-searches-in-JIRA/ba-p/461943.

 

E.g. 

project = PPLUS AND status WAS "In Progress" ON "2017-01-01"
project = PPLUS AND status WAS "In Progress" DURING ("2017-01-01", "2017-01-31")
project = PPLUS AND status CHANGED FROM "In Progress" TO "Awaiting Code Review" ON "2017-03-15"

This might provide you with an automatic or at least semi-automatic way of doing what you want.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

An update on Confluence Cloud customer feedback – June 2022

Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...

378 views 2 11
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you