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

JQL Query to find issues that have transitioned between two specific dates and statuses

Daniel Jonsson3

The JQL below almost works, but this also shows tickets that have been updated with anything (such as a comment). I only want to see issues that transitioned between Open and Resolved/Closed between two specific dates. is this possible?

project in (PROJECT) AND status changed from "Open" to ("Resolved", "Closed") AND updatedDate &gt;= -1d

Accepted answers

Udo Brand

use

project in (PROJECT) AND status changed from "Open" to ("Resolved", "Closed") during("2013-10-01", "2013-10-17")<br>

All comments

Andrey Markelov

Try, https://marketplace.atlassian.com/plugins/ru.andreymarkelov.atlas.plugins.utils

Use function: transitionDate(?1, ?2) or transitionReporter(?1, ?2) see doc: https://bitbucket.org/amarkelov/andreymarkelov-atlas-plugins-utils/wiki/Home

Udo Brand

use

project in (PROJECT) AND status changed from "Open" to ("Resolved", "Closed") during("2013-10-01", "2013-10-17")<br>

erick.mirandamarquez@telefonica.com

Hello @Andrey Markelov, do you have the correct sentence to use trasitionDate("",""), my example:

status changed FROM "ejecution" TO "done"

Thanks in advanced!

Aakash Mehta_d3lahp

HI @Udo Brand,

Is it possible to find issues between two specific dates but any status to closed?

project = <Project Key> abd Sprint = 72728 and status changed during (2019-06-03, 2019-06-07) from "any status" to "closed"

Udo Brand

yes, this is possible:

status changed to "closed" during ("2019-06-03", "2019-06-07")

just use the "to" and "during" predicate on the changed operator

Simon Tost _TNG_

For future reference: Documentation
https://confluence.atlassian.com/jiracoreserver/advanced-searching-operators-reference-939937721.html#Advancedsearchingoperatorsreference-CHANGEDCHANGED