Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

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.

like image 751
user2117045 Avatar asked Feb 27 '13 20:02

user2117045


People also ask

What does != Mean in JQL?

The " != " operator is used to search for issues where the value of the specified field does not match the specified value. (Note: cannot be used with text fields; see the DOES NOT MATCH (" !~ ") operator instead.)

What is a subquery in JQL?

Subqueries allow you to create complex JQL queries that normally require creating more than one query and possibly some manual copy and paste operations. They can free you from Excel for a number of tasks. They are easy to use thanks to support for autocompletion.

How do I do a wildcard search in Jira?

Jira supports single and multiple character wildcard searches. To perform a single character wildcard search, use the " ? " symbol. To perform a multiple character wildcard search, use the " * " symbol.


1 Answers

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.

like image 112
Kuf Avatar answered Oct 11 '22 01:10

Kuf