show the status of JIRA tasks in the past

[Silke Auer]

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

[Thomas Schlegel · Accepted solution]

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.

[Silke Auer]

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

But how can I include this in a template?

[Thomas Schlegel]

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

[Silke Auer]

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]

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<p>\E",""))
#set ($body = $body.replaceAll("\Q</p>\E",""))
#set ($body = $body.replaceAll("\Q<span>\E",""))
#set ($body = $body.replaceAll("\Q</span>\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:

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

[Silke Auer]

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

Cheers, Silke