Questions regarding JQL and reporting?

[Markus]

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.

[Ignacio_Pulgar · Accepted solution]

Hi Markus,

Here we have answers to your questions:

1. JQL queries will either retrieve an issue or not. They will never return an issue more than once, no matter the query.
2. If a static date is provided without a time, the time will default to 00:00 hours. You may also add a specific hour to your date like this: "2019/12/31 23:59". The endOfYear() function would also work for covering the full last day of the year.

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.

[Markus]

Hi, thanks that a really superb answer, helped me a lot!

[Yogesh_Mude]

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.