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

Question

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_cp1r58 · Answer

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

Uday Kiran Bhaviri_cp1r58 · Answer

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_cp1r58 · Answer

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