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?
Thanks.
Hi Markus,
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.
HI @Markus
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.