nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

All comments

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-software