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?
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'))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
which version of Jira are you using?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
7.2
I just tried creating the JQL filter and it told me it wasn't valid.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
project = LIR and status was reopened during ("2017/02/01","2017/04/30")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.