Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Questions regarding JQL and reporting?

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? 





2 answers

1 accepted

1 vote
Answer accepted
Ignacio Pulgar Community Leader Dec 03, 2019

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.

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

Like Ignacio Pulgar likes this

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.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Confluence

What do you think is the most *delightful* Confluence feature? Comment for a prize!

- 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...

402 views 23 8
Join discussion

Community Events

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

Events near you