show the status of JIRA tasks in the past

Please help me:

I have to create weekly meeting notes, which include the status of  JIRA tasks from last week (open ones, closed ones etc.) I am doing this with this code:

assignee in membersOf(Mustererkennung) AND resolved >= startOfDay(-7d) ORDER BY resolved   

I am using a templet to create the reports. Now, I have created something like 15 weekly reports, but every report has the same content. What I need is the status of the JIRA tasks of the particular week. So if i watch i.e.: the report of week 5 in 2017 I would like to see the status at this time period.

//I hope i could describe my problem - English is not my mother tongue

1 answer

1 accepted

Accepted Answer
0 votes
Thomas Schlegel Community Champion Jun 13, 2017

Hi Silke,

you can do something like that:

for every status in your workflow, use a JQL query in your report:

status was "<your status>" during ("yyyy/mm/dd", "yyyy/mm/dd")

Show the number of issues for each JQL  in your report. There might be a problem if an issues changed its status between start and end date. These issues are counted twice.

 

Hallo Thomas, thanks for the answer. This suggestion perfectly works out.

But how can I include this in a template?

Thomas Schlegel Community Champion Jun 13, 2017

do you want to show the report in Jira or in Confluence?

The report should be shown in Confluence, once a week. And if i go back to the report of last week, I want to see the status of last week (and not the actual how it is now)

Thomas Schlegel Community Champion Jun 13, 2017

Hi Silke,

sorry for the delay, I had to do my own work for a moment ;-)

I've a solution for you based on the post by Adam Barylak in this question: https://community.atlassian.com/t5/Confluence-questions/Using-template-variables-as-input-parameters-to-jira-gadget/qaq-p/189292

Tried that and it works fine.

First, follow the steps to create a user macro. My user macro looks like this:

## Macro title: jirawrapper
## @noparams

#set ($body = $body.replaceAll("\Q&lt;p&gt;\E",""))
#set ($body = $body.replaceAll("\Q&lt;/p&gt;\E",""))
#set ($body = $body.replaceAll("\Q&lt;span&gt;\E",""))
#set ($body = $body.replaceAll("\Q&lt;/span&gt;\E",""))
#set ($body = $body.trim())

<p>
  <ac:structured-macro ac:macro-id="a4cf4a1c-c4fd-4aa6-86e4-5b14bad97c55" ac:name="jira" ac:schema-version="1">
    <ac:parameter ac:name="server">yourJiraServerName</ac:parameter>
    <ac:parameter ac:name="jqlQuery">$body</ac:parameter>
    <ac:parameter ac:name="count">true</ac:parameter>
    <ac:parameter ac:name="serverId">yourserverid</ac:parameter>
  </ac:structured-macro>
</p>

Save the macro and then create your template as described by Adam. 

My template looks like this:

jiratemplate.png

Create as many jirawrapper elements as you need. Put them e.g. in a table. 

When you then create a page with this jira-template, you are asked for startdate and enddate and the rest will be created for you. 

This worked fine for me. If you have any further questions, please ask.

Viele Grüße aus Hamburg

Thomas

Hi Thomas, thanks a lot for your help. I think this will work fine. I'll let you know how it woked.

Cheers, Silke

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 18, 2018 in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

21,672 views 2 7
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