Using JQL to filter

[Vladimir Matveev]

How to write a JQL filter that will select only those issues that (for example) on 02/25/2021 were transferred from the status "Working on it" to the status "Waiting for code review"?

[Walter Buggenhout · Accepted solution]

Hi @Vladimir Matveev,

It might not be entirely correct, but it will be pretty close:

status was "Working on it" on 2021-02-05 AND status changed to "Waiting for code review" ON 2021-02-05

[Walter Buggenhout]

The above JQL may also return issues that changed to status Waiting for code review from another status, but were also in status Work in progress on the same day.

[Vladimir Matveev]

Unfortunately, such a JQL query throws an error...

But I was prompted for another solution that works: 

status changed from "Working on it" to ("Waiting for code review") during ("2021-04-18", "2021-04-19")

[Walter Buggenhout]

Yes it does, and is more precise too! Thx for sharing!

[Yuliia_Borivets__SaaSJet_]

Hi @Vladimir Matveev 

For the next cases when you have issues with JQL, you can try Dynamic Filters: JQL Replacer add-on. It's developed by my team to simplify database searches. Visual composer helps to set queries. It's easy to choose dates there:

Hope you find this helpful.