jira version progress bar in a confluence table?

[Tyler Peters]

For each version, JIRA creates a nice version page and progress bar for that version.  Is there a way to add that version progress bar to a Confluence table?

Here is an example of what I would like to do.  The progress bars below are just screen shots.  I would like them to be dynamically updated from Jira.

image2017-1-5 12:44:5.png

[Julien Levrier · Accepted solution]

i created a user macro that does that using Confluence chart

kind of a workaround, but might help!

i am trying to see how to embed results from JIRA queries, at the moment, i have to enter those parameters by hand

it accepts three parameters, number of open items, items in progress and closed items and renders a small colored bar

here is the code

## @Param open:title=number of open topics|type=int|desc=enter a number of open items|required=true|default=0|multiple=false
## @Param progress:title=number of topics in progress|type=int|desc=enter a number of items in progress|required=true|default=0|multiple=false
## @Param closed:title=number of completed topics|type=int|desc=enter a number of closed items|required=true|default=0|multiple=false

## convert inputs to integers (standard is char for confluence)
#set ( $tempint = 0 )
#set ( $openint = $tempint.parseInt($paramopen))
#set ( $progressint = $openint + $tempint.parseInt($paramprogress))
#set ( $closedint = $progressint + $tempint.parseInt($paramclosed))

## create chart
<ac:structured-macro ac:name="chart">

<ac:parameter ac:name="borderColor">#ffffff</ac:parameter>
<ac:parameter ac:name="orientation">horizontal</ac:parameter>
<ac:parameter ac:name="stacked">true</ac:parameter>
<ac:parameter ac:name="legend">false</ac:parameter>
<ac:parameter ac:name="rangeAxisTickUnit">0</ac:parameter>
<ac:parameter ac:name="dataOrientation">vertical</ac:parameter>
<ac:parameter ac:name="type">xyStepArea</ac:parameter>
<ac:parameter ac:name="colors">#205081,#f6c342,#14892c</ac:parameter>
<ac:parameter ac:name="width">200</ac:parameter>
<ac:parameter ac:name="height">40</ac:parameter>

<ac:rich-text-body>
<table class="wrapped">
<colgroup>
<col style="width: 90.0px;"/>
<col style="width: 57.0px;"/>
<col style="width: 79.0px;"/>
<col style="width: 30.0px;"/>
</colgroup>
<tbody>
<tr>
<th colspan="1">y</th>
<th>Open</th>
<th>In Progress</th>
<th colspan="1">Closed</th>
</tr>
<tr>
<td colspan="1">1</td>
<td>$openint</td>
<td>$progressint </td>
<td colspan="1">$closedint</td>
</tr>
<tr>
<td colspan="1">6</td>
<td colspan="1">$openint</td>
<td colspan="1">$progressint</td>
<td colspan="1">$closedint</td>
</tr>
</tbody>
</table>
</ac:rich-text-body>

</ac:structured-macro>

[Randy]

I've also tried looking for this exact thing.

There isn't a way to do that out of the box and i have not been able to find an add-on that provides it.

[Tyler Peters]

That is too bad!  It would be such a great thing to have.

[Dana Pull]

We would love an option for this, too. Quite frankly it's surprising it's not available.

I would even like to be able to create a progress bar down to an epic or an issue filter.