What is the JQL query for searching tickets which were rejected(Test Failed) in Tests?

Question

I'm searching for the query which gives me a list of tickets which were moved from Test column to ToDo column as the test was failed.

The query I'm using currently is:

Example: status was Reopened DURING("2018-03-27”,”2018-04-06")

But the above query gives all the tickets which were reopened from other column/status as well. This makes it hard to identity which stories were rejected during testing phase.

Srilatha Kondapalli · Answer

Thanks. It worked.

Warren_mz9b4z · Answer

Hi

You can use a query similar to this :

status changed FROM "In Testing" TO Reopened DURING("2018-03-27”,”2018-04-06")

You need to make sure that the statuses In Testing and Reopened match your Jira