Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL needed to pull all issues changing status within a date range.

DeAnna Law August 21, 2024

Someone on my team is looking to create a JQL where:
•Date range can be defined ( July 1 - XX) 
•Issues that fall under EPICS only 
•Where Issues move from OPEN to any other Status within said date range. 

She is currently only selecting from certain projects which is defined by:  Project in (  ) , statement. 

Any help will be appreciated. 

1 answer

1 vote
Shikha Verma
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.
August 21, 2024

Hi @DeAnna Law, You can try this:
Project in (ProjectA, ProjectB)
AND "Epic Link" is not EMPTY
AND status WAS "Open" DURING ("2023-07-01", "2023-XX-XX")
AND updated >= "2023-07-01" AND updated <= "2023-XX-XX" 

OR

project in (Project1, Project2, ...)
AND "Epic Link" is not EMPTY
AND status changed FROM "Open"
AND updated >= "2024-07-01" AND updated <= "2024-XX-XX"


DeAnna Law August 26, 2024

Thank you @Shikha Verma we did a manual compare and it looks like maybe we need a slight tweak to the JQL.   Looks like maybe it is only pulling when the status is OPEN to another STATUS.  However we are looking at tickets that move from any open status to another STATUS.  So if a ticket is IN PROGRESS and moves or , IN TESTING and moves etc. 

Suggest an answer

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

Atlassian Community Events