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; } } }

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

Accepted answers

Jack Brickey

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.

All comments

Jack Brickey

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

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

Here you go...

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

Jack Brickey

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

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

jql