JQL to list tickets that were in closed or resolved status as on date

[Mint S]

Hi

I am running below query on JIRA Service Desk

status within quote

project = ABC and resolution is not EMPTY and status was in ("Resolved","Closed") on 2023-11-30

status without quote

project = ABC and resolution is not EMPTY and status was in (Resolved,Closed) on 2023-11-30

to get jira list in status Resolved or Closed on as on 2023-11-30.

Any tickets status (even if reopned after 2023-11-30) should be fetched.

The above query is returning empty list.

Thanks for help

[Uday Kiran Bhaviri]

Hi @Mint S 

Try to remove resolution not empty once the request is reopen it may have been cleared the resolution 

Did you try the below query  using during period

project = ABC and status was in (Resolved,Closed) DURING ("2021-06-30","2021-08-04")

[Mint S]

Hi @Uday Kiran Bhaviri 

I tried the following, nothing worked

project = ABC and status was in ("Resolved","Closed") on 2023-11-30

project = ABC and status was in (Resolved,Closed) on 2023-11-30

project = ABC and status was in ("Resolved","Closed") DURING ("2023-06-30","2023-08-04")

project = ABC and status was in (Resolved,Closed) DURING ("2023-06-30","2023-08-04")

[Uday Kiran Bhaviri]

Adjust the dates according to your requirement while using the during.

[Uday Kiran Bhaviri]

---

The WAS IN operator is used to find issues that currently have or previously had any of multiple specified values for a specified field. The values are specified as a comma-separated list, surrounded by parentheses.

In a search query, with this operator, you can use the following:

• AFTER "date"
• BEFORE "date"
• BY "username"
• DURING ("date1","date2")
• ON "date"

The WAS IN operator will match the value name (for example, "Resolved") that was configured in your system at the time when the field was changed.

The operator will also match the value ID associated with the value name. For example, it will match "4" as well as "Resolved".

CHANGED

The CHANGED operator is used to find issues where the value of a specified field was changed.

In a search query, with this operator, you can use the following:

AFTER "date"

BEFORE "date"

BY "username"

DURING ("date1","date2")

ON "date"

FROM "oldvalue"

TO "newvalue"

You can try the above operators and update the values according to the requirement.

[Uday Kiran Bhaviri]

status WAS IN ("Resolved","Closed") ON "2023/11/30"