How to get a closed tickets with range of date irrespective of update in the ticket

[Sachin Guttala]

i need to see the tickets which are closed within the range of dates for particular project irrespective of updates after closed.  

[John Funk · Accepted solution]

Hi Sachin,

Try this query/filter: Project = ABC and status changed to Done DURING (2024-03-01, 2024-03-31)

This will show all issues on the ABC project that moved to Done during the month of March. You can change the project and dates for your specific needs. 

[Bill Sheboy]

Hi @Sachin Guttala 

Adding to John's answer:

Please look here to learn more about creating JQL queries like this: https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#CHANGED

Kind regards,
Bill

[Iryna Komarnitska_SaaSJet_ · Accepted solution]

Hi @Sachin Guttala ,

You might also try this query: 

Project = XXX AND status changed to Done ON (2024-03-18, 20024-03-24) AND NOT updated IN (now())

[Perisic Nikola · Accepted solution]

Hello @Sachin Guttala , to answer your question, more details would be needed like for which date range this is?

[Sachin Guttala]

like i need the tickets which closed during 18/03/2024 to 25/03/2024 and after closing if anyone updated in the ticket, it should not come, only closed tickets within the date.

[Matt Parks]

How do you determine that something was closed? Is it because it moved to a particular status? Did you set a particular Resolution? Do you track whether something was completed successfully as opposed to canceled and, if so, how do you do that (and does it even matter for the purposes of this query)?

[Matt Parks]

Also, when you say "after closing if anyone updated in the ticket, it should not come", what do you mean by that?

Do you mean that, if someone updated the ticket after it was closed that it should not show up in your query? Or that it doesn't matter if they updated the ticket after it was closed, all you care about is when it was closed?