Jira jql query to search for tickets that status changed to a particular status after a date

jira jql
user2117045 picture user2117045 · Feb 27, 2013 · Viewed 20.7k times · Source

I need to filter on tickets that went into status a status of RTT after a particular date. These tickets would be resolved now but I need to see all those that entered that status after a date regardless of their current status.

Answer

Kuf picture Kuf · Feb 28, 2013

for example, find all issues that their status changed from Open to Closed after 2012/12/31:

status CHANGED FROM "Open" TO "Closed" AFTER "2012/12/31"

you can find for info about CHANGED search key on Atlasian's Advanced Searching page.

Related questions

JIRA JQL searching by date - is there a way of getting Today() (Date) instead of Now() (DateTime)

I am trying to create some Issue Filters in JIRA based on CreateDate. The only date/time function I can find is Now() and searches relative to that, i.e. "-1d", "-4d" etc. The only problem with this …

Read More
JIRA: Searching for all issues with a given link type

Is there a way to query for all issues with a particular link type? For example, let there be a dependency link where an issue can "depends on" another issue. Is there a query to find all issues that depend …

Read More
How do I query Jira to search for all issues that have been resolved within a length of time from when it was created?

For example, let's say I need to find all issues that were resolved within 1 week's time. I need something like: resolved - created < '1w' Another example: Let's say I have 3 issues: 1) created 2 days ago, resolved 1 day ago. 2) created 5 …

Read More