Im currently creating some reports in Confluence that should simply show all issues we finished during the year.
To do so i created this filter: project = MyTestProject AND status changed to (r.release,done) DURING ("2019/01/01","2019/12/31")
Now i have two questions:
1. If an issue went trough the statuses R.Release and Done will JQL count it only once or twice? Like a user story that was first moved to the status R.Release than back to "Open" and then to Done.
2. ("2019/01/01","2019/12/31") Whats the beginning and end time here? Is it the 01.01.2019 at 00:00 to the 31.12.2019 23:59 or something different?
Here we have answers to your questions:
Please, note that your query actually returns issues from MyTestProject that have ever transitioned to the r.release or done statuses during the specified date range, disregarding their current statuses, so you might want to add ...AND status in (r.release, done) to your query.
If you would like to take an unmutable picture of the issues returned by your query, you may select the entire table returned once the macro had loaded the results > Ctrl + C > Edit the page & paste. That way you will have a static table that will not vary depending on Jira data changes that may occur in the future.
Should you wish to create such an inmutable report in the first week of the new year, you may use the following query:
project = MyTestProject AND status in (r.release, done) AND status changed to (r.release, done) DURING (startOfYear(-1), endOfYear(-1))
Hope it helps.
As you are reporting tickets that r finished in the specific years then you should include the resolution in your JQL. in jira if the ticket resolution is set then only it treats as resolved and shows it on the report.
And whenever ticket reopens then you should reset the resolution so that the specific ticket exclude from the report.
- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events