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"?
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
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.
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")
Yes it does, and is more precise too! Thx for sharing!
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.
It looks like you're new here. Sign in or register to get started.
