Query issues within a given project(s) featuring 1-5 days between created and due dates

Nick Jennings_a1y08g

Is there an advanced JQL that compares the created date and due date for any issues within a given project and returns any issues that satisfied that criteria?

i.e. I want a query to identify any issues that were submitted within a project that, based on the issue creation date and assigned due date, only allows for 1-5 days response time.

I'm thinking this JQL would require a date comparison to occur between created and due, although I am unaware of any such function available in the standard JQL.

Bill Sheboy

Hi @Nick Jennings 

You are correct: there is nothing in out-of-the-box JQL as it is not a SQL.  There are marketplace addons which enhance JQL to do this.

If you just need this once for a few issues, you could try exporting the issues to perform the comparison.

Kind regards,
Bill