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
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs