Very easy, see the JQL example:

Project = “JIRA” AND Status CHANGED TO “In Progress” DURING (“2015/08/01″,”2015/10/05”)

Other Syntax:

This JQL shows all issues which have been in “Status A” for more than 14 days

project=XXX and status changed to “Status A” before startofday(-14) and status = “Status A”

This JQL shows all issues which have been in “Status A” 14 days or less

project=XXX and not status changed to “Status A” after startofday(-14) and status = “Status A”

Others…

PROJECT = “XXX” AND (STATUS WAS “Status A” AFTER “Date1”) AND (STATUS WAS “Status A” BEFORE “Date2”)

 

If you need more info about how to use JQL, tricks, etc, we strongly recommend the Book “JQL Per tutti” of Fabio Genovese (Artigiano del Software)

Available in ItalianSpanishCatalanFrench and English!

51bQoQNh7AL

Advertisements
Posted by:.

2 replies on “JIRA JQL trick: Filter issues based on transition state execution date in JIRA

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s