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
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.
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
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot