The number of returning issues

Piotr Jarzyna December 21, 2023

Hello everyone!

I'm trying to create a simple issue list that shows all tasks moved from status XYZ to ZYX during certain dates. I use this JQL: 

project="ABC" AND status changed from "under review" to "in progress" OR status changed from "under review" to "blocked" DURING ("YYYY/MM/DD","YYYY/MM/DD")

Unfortunately, the issue list is showing also tasks that were moved before the period.

Maybe you have faced a similar challenge. It would be amazing to have your insights and hints.

Thank you!

 

1 answer

0 votes
Duc Thang TRAN
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 21, 2023

Can you try adding project="ABC" AND (status changed from "under review" to "in progress" OR status changed from "under review" to "blocked" DURING ("YYYY/MM/DD","YYYY/MM/DD"))
"Or" operator will  reset the parameters of your search 

Piotr Jarzyna December 21, 2023

Hey, thank you for your answer! 

I did it, and I think that nothing has changed:
project="ABC" AND (status changed from "under review" to "in progress" or status changed from "under review" to "blocked" DURING ("2023/12/10","2024/03/15"))

Duc Thang TRAN
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 21, 2023

:)

Duc Thang TRAN
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 21, 2023


I have understood you looking for all ticket of project ABC and status changed from "under review" to "in progress" or status changed from "under review" to "blocked" during certain dates 

If you looking to find also status changed from "under review" to "in progress" during certain dates , you need to add DURING ("YYYY/MM/DD","YYYY/MM/DD") aswell  in this block. 
New jql : 
project="ABC" AND ((status changed from "under review" to "in progress"  DURING ("YYYY/MM/DD","YYYY/MM/DD")) OR (status changed from "under review" to "blocked" DURING ("YYYY/MM/DD","YYYY/MM/DD")))

Hope this will help you 

Like Piotr Jarzyna likes this
Piotr Jarzyna December 21, 2023

Amazing, it works! 

Thank you so much for your help!

Suggest an answer

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

Atlassian Community Events