Running Custom JIRA Reports

[Kristen Viscardi]

Is there a way to run a report that will show me all of the issues that had the status of reopened for February, March and April?

[Thomas Schlegel · Accepted solution]

Hi Kristen,

yes, use this JQL:

status was "reopened" during ('2017-02-01','2017-04-30')

And this is the one, if you want to check, if the status didn't change for the whole duration:

status was "reopened" during ('2017-02-01','2017-04-30') and !(status changed during ('2017-02-01','2017-04-30'))

[Kristen Viscardi]

during isn't an operator though.

[Thomas Schlegel]

which version of Jira are you using?

[Kristen Viscardi]

7.2 

I just tried creating the JQL filter and it told me it wasn't valid.

[Thomas Schlegel]

I tried in Jira 7.3, but also in an older Jira 7.0.2 and it works fine.

Maybe there's something wrong with the date format. Try "2017/02/01" instead. Maybe the double quotes instead of single quotes.

JQL date formats are described here: 

https://confluence.atlassian.com/adminjiraserver071/__jql-date-time-formats-802592031.html

[Kristen Viscardi]

project = LIR AND status was = Reopened ("2017/02/01","2017/04/30/")

This is my query and it still is throwing an error: Error in JQL Query: Expecting either a value, list or function but got '='. You must surround '=' in quotation marks to use it as a value. (line 1, character 30)

I tried using the quotes and it still didn't work. Any ideas?

[Thomas Schlegel]

project = LIR and status was reopened during ("2017/02/01","2017/04/30")