How do I query for closed items over a time period?

Laura B Livnat August 31, 2015

I would like to get a listing of all items closed since last November. How do I do that? I am using JIRA v7.0.0-OD-02-259

3 answers

0 votes
Ignacio Pulgar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 31, 2015
status CHANGED TO Closed AFTER "2014/11/01" AND status = Closed
0 votes
Nick August 31, 2015

My interpretation of your requirement from the title is "items closed since 2014-11-01 (start of november) and not changed since".

So something like

status changed during ("2014-11-01",  now()) and status = "Closed"

Otherwise you can further refine your query using a variation of this (with more clauses perhaps), namely

status changed during ("2014-11-01", now())
  and status was in ("Closed") during ("2014-11-01", now())
0 votes
GabrielleJ
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 31, 2015

Take a good read the JIRA Advance Searching which documents everything you need to know on stuff like this. Particularly, take a look at the "WAS" features and  try to generate the JQL on your own.

Suggest an answer

Log in or Sign up to answer