nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Thomas Schlegel

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'))

All comments

Thomas Schlegel

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

report