Is it possible to filter the issues based on the transition date from a particular status to "Done"?

[Ankit Yadav]

Dear Friends,

Is it possible to filter the issues based on the transition date?

We need to filter the bugs having the Status "Closed" or "Done" based on the date they actually got transitioned to Closed or Done (independent of the actual end/closed date field).

Looking forward to your responses.

Thanks & regards

Ankit Yadav

[Jack Brickey · Accepted solution]

Hi @Ankit Yadav , you can use the "was" and "was not" operators that may meet your goals. For example...

Status = done and status was not done before startOfMonth(-1)

the above finds issues that are now Done but we're not before 8/1/2023.

if you can provide the details of your goal maybe I could provide a more specific JQL.

[Ankit Yadav]

Thanks @Jack Brickey for your prompt response. I will try your suggestion and will keep you updated.

[Ankit Yadav]

Hi @Jack Brickey I and one of my colleague tried your suggestion but we could not succeed.

Could you please help us by providing the specific JQL?

Requirements are as follows:

Issuetype = Bug

Issue Status = Closed

Transitioned to Status "Closed" between 1st Aug 2023 and 31st Aug 2023

Is the above information sufficient or you need more to provide the specific JQL?

Looking forward to receiving your help.

Thanks

[Jack Brickey]

Here you go...

status changed To Closed AFTER 2023-07-31 and status changed to Closed before 2023-09-01

[Jack Brickey]

Oh and add in the Issuetype bit too...

Type = bug and status changed To Closed AFTER 2023-07-31 and status changed to Closed before 2023-09-01

also note, if the issue transitioned out of closed during or after moving to closed then the above will still capture the bug in the results. In other words, if you wish to exclude any issues that are not still in the closed status, then use the following...

status = closed and Type = bug and status changed To Closed AFTER 2023-07-31 and status changed to Closed before 2023-09-01

[Ankit Yadav]

Thanks a lot @Jack Brickey for your help and detailed response. I will try the suggested JQL and will keep you posted.

[Ankit Yadav]

@Jack Brickey we got the desired outcome through the JQL you shared. Thanks a lot for your support.

[Jack Brickey]

@Ankit Yadav , Great! Please consider accepting the answer.

[Ankit Yadav]

@Jack Brickey Sure. 

[Emre Toptancı _OBSS_]

Hello @Ankit Yadav ,

Try this:

status CHANGED TO Done AFTER '2022-09-01 00:00:00'

EmreT 

[Ankit Yadav]

Thanks @Emre Toptancı _OBSS_ for your response. I will try this and revert.

[Jack Brickey]

I don't think that is what you want based on the mentioned detail.