CODEWITHSUNDEEP
jirajql
user2117045
user2117045

Reputation: 221

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

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.

Upvotes: 22

Views: 27541

Answers (3)

GaTechThomas
GaTechThomas

Reputation: 6076

To filter on items that have not had a status change in some time, add to the filter in the format:

AND NOT ({field Name} CHANGED AFTER {some date or date function})

For example, I have a "stale" board that includes this in the filter to show all items that haven't changed in more than two months:

AND (status NOT IN (Closed, Done, "To Do")) AND NOT (status CHANGED AFTER startOfMonth(-2))

Upvotes: 0

user2908957
user2908957

Reputation: 69

type = "Bug" AND status was in ("Resolved")

Upvotes: 0

Kuf
Kuf

Reputation: 17828

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.

Upvotes: 47

Related Questions