How to display Jira Issue field values in Confluence page

Hi All,

We define all our small projects as Epicss in Jira. I have a page for each of our sub-projects in confluence with some page properties defined on them. Then I have a page property report to summarise the project stats in on table.

I want to be able to automatically update these page properties from JIRA issue fields. At the moment i am looking at fields like Original Estimate, Remaining Estimate, Time Spent and some more custom fields defining Project code etc.

Below is an screenshot of the report that I need to maintain.

Is there anyway to do this in Confluence? Or is there any other way anyone can suggest to achieve the same results?

 

image2016-10-26 11:15:29.png

3 answers

1 accepted

I found a workaround for this. Although it is not ideal but it seems is the only available option at the moment.

I added a page property for the original estimate and add the JIRA filter macro  with a filter to show the single issue. It shows the value. The only problem is that it shows the field name as well as the value itself.

It would be good to have a tick in Display Option section to select whether I want the field name to be displayed or not.

 

image2016-10-27 16:4:32.png

Hi Saeed,

Apologies, this is exactly what I was trying to suggest (poorly) in my original comment.  Good job on getting it sorted.

Hi Saeed,

The Page Properties Report macro will show the results of macros.  So you can add - for example - a JIRA Issue Filter macro that returns the number of bugs in a sprint into a row in the Page Properties table and the Page Properties Report will show the results of that filter.  Every time you refresh the page with the Page Properties Report on, the values will refresh as well.

 

You should be able to pull the information you're looking for from JIRA using JQL and the JIRA Issue Filter macro - here's the main JQL help page to get you started: https://confluence.atlassian.com/jirasoftwareserver070/advanced-searching-762877735.html

Hi Rob,

Issue filter just returns the issues found in multiple rows and two dimensional reports show the counts etc. I understand that. But I want to be able to show the value of a specific field in one issue. For example in screenshot above, every line is an Epic and I want to pull the Original estimate values for each of those epics.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

995 views 23 13
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you