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; } } }

time machine JQL query

Donal Murtagh

I can find out how many critical bugs have been opened in the last month using a JQL query like

issuetype = Bug
AND priority = Critical
AND status in (Open, "In Progress", Reopened)
AND created >= 2012-02-13

If I want to compare this figure, with the corresponding figure from last year, a naiive attempt at getting last year's equivalent might be

issuetype = Bug
AND priority = Critical
AND status in (Open, "In Progress", Reopened)
AND created >= 2011-02-13
AND created < 2011-03-13

But of course this is completely wrong, because it will tell me how many critical bugs that were created between 2011-02-13 and 2011-03-13 currently have staus open, in progress, or reopened. What I want to know is how many of these bugs had such a status one year ago.

I don't know if the JIRA data model, allows such a query to be formulated, but if it does, I'd appreciate it if someone could show me how.

Accepted answers

All comments

Thomas Schlegel

Hi,

you can use "status was"

Best regards

Thomas

Donal Murtagh

Thanks for the response. Would you mind showing exactly how to use this? Specifically, how do I specify the date that want to get the status for?

Thomas Schlegel

But if I think of it for a while, it is not necessary to ask for the status. The only relevant thing is, that the creation date is between 2011-02-13 and 2011-03-13. Every issue that is created then was in status "open", of course...

Thomas Schlegel

This should do it:

issuetype = Bug
AND priority = Critical
AND status was in (Open, "In Progress", Reopened)
AND created >= 2011-02-13
AND created < 2011-03-13

Welcome!

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

Quick Links

Find more posts tagged with

jql

query