Using JQL to filter

Vladimir Matveev April 21, 2021

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"?

2 answers

1 accepted

2 votes
Answer accepted
Walter Buggenhout
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 21, 2021

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 21, 2021

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 April 21, 2021

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")

Like # people like this
Walter Buggenhout
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 21, 2021

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

0 votes
Yuliia_Borivets__SaaSJet_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 21, 2021

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:

2021-04-21_15-44-47.png

Hope you find this helpful.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events