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

[Daniel Jonsson]

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 >= -1d

[Udo Brand · Accepted solution]

use

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


[Aakash Mehta]

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

[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

[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!