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"?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes it does, and is more precise too! Thx for sharing!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.