Need the report for closed date is overwritten

[kiranmai genkolla]

KEY-1997 was closed on 9th Mar 2020 and re-opened again and closed on 7th July 2020. The closed date is overwritten.

Now we have a query from business to extract the closed tickets between 1st July 2019 to 30th June 2020. In this case this record is not extracted, but we need these type of records in the output. Do we have any way to get these type of records where the closed date is overwritten?

[Dave Theodore [Coyote Creek Consulting]]

There are a pair of JQL operators: WAS and WAS IN, that are designed to do what you want. They search through the issue's history and should be able to display the issues you're after.

[kiranmai genkolla]

here if i need to get the closed date between 1st july 2019 to 01st july 2020 . how do i write the JQL 

Can you help me

[Dave Theodore [Coyote Creek Consulting]]

Something like this should do the trick. You may need to add some additional filters to get exactly what you want.

resolutiondate >= "2019-07-01" AND resolutiondate <= "2020-07-01" order by created DESC

Note: "resolutiondate" is when the "Resolution" field was set to a value. If your workflow(s) are broken and don't force a Resolution to be set when you close an issue, this won't work. You'd need to revert to using WAS or WAS IN to search the issues history.

If you want to do this sort of thing regularly, it would be worth doing some reading on advanced searching from my previous link. You can't do this type of searching in "Basic" mode.

[kiranmai genkolla]

Ok I will check 

[kiranmai genkolla]

still unable to get the details with WAS aswell